Generating a selectbox from an Enum

[lordalgae]

Hi,

I'm trying to create a generic admin interface that will work with any database.

It is relying on the mysql_fetch_field function to determine what the field type is so a html form can be generated.

I would like to be able to generate an "on the fly" selectbox for an enum field with the enum choices as options. Has anyone had any success with this? I couldn't find anything useful in the archives.

eg
<= THIS =>

+-----------+------------------------+
| Field | Type |
+-----------+------------------------+
| status | enum('active','disabled') |

+-----------+------------------------+

<= INTO =>

<select name=status>
<option value='active'>active
<option value='disabled'>disabled
</select>

thanks
steve

[brandonschnell]

i used the below code in a project a while back. i haven't tested it recently, but it should get you started.

$field_result = query($db,"DESCRIBE $table");

$field_row = mysql_fetch_array($field_result);

if (stristr($field_row["Type"],"enum"))
{
echo "<SELECT NAME=\"", $field_row["Field"], "\">";

 $array = explode("'",$field_row["Type"]);
 $x = 1;
 while ($array[$x])
      {
      echo "<OPTION ";
      if(($data_row[$field_row["Field"]] == $array[$x]) || (!isset($id)

&& ($field_row["Default"] == $array[$x])))
{
echo "SELECTED ";
}
echo "VALUE=\"",$array[$x],"\">",cleanstr($array[$x]),"</OPTION>";
$x+=2;
}

 echo "</SELECT>";
 }

[brandonschnell]

function cleanstr($str){
$str = str_replace("_", " ",$str);
#strip whitespaces
$str = trim($str);
#capitalize word
$str = ucwords($str);
return $str;
}