very easy regex (not for me)

[jd22]

i have a value something like enum('adult','kid')  (This value is result of "SHOW COLUMNS FROM clases LIKE 'School'" school is where enum values store)

how can i parse it those and add into <option value="HERE">HERE</option>

 

Regards

[salathe]

There's no real need for regex.

 

$enum_string = "enum('adult','kid')";
$values = explode(',', str_replace("''", "'", substr($enum_string, 5, -1)));

 

Then you can just loop over $values to build/output your HTML.

[jd22]

Dear salathe

Thank you for your reply.

I build a function yesterday it is simple but works fine form.

function EnumFileds($Table, $Column)
{
	$DSP_RESULT = "";
	$ENUM_NAME = "SHOW COLUMNS FROM " .$Table. " LIKE '" .$Column. "'";
	$ENUM_QUERY = mysql_query($ENUM_NAME);
	$ENUM_ROW = mysql_fetch_array($ENUM_QUERY);

	$GetCol = preg_match("/['](.*)[']/", $ENUM_ROW['Type'], $matches);
	$SplitIt = str_replace("'", "", $matches[0]);
	$Result = explode(",", $SplitIt);
	for($i=0; $i<count($Result); $i++)
		$DSP_RESULT .= '<option value="' .$Result[$i]. '">' .$Result[$i]. '</option>';
	return $DSP_RESULT;
}

 

I hope this code help someone else.

 

Thank you again for your help.