Php Codes

Php > Database Related sample source codes

ENUM Fields

ENUM Fields

<? 
function DrawComboFromEnum($table,$field) 
    { 
    //connect to DB; 
    $query=mysql_query("SHOW COLUMNS FROM ".$table." LIKE '".$field."'") or die (mysql_error()); 
    if(mysql_num_rows($query)>0) 
        { 
        $row=mysql_fetch_row($query); 
        $options=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$row[1])); 
        } 
    for ($i=0;$i<count($options);$i++) 
        { 
        $items.="<option value=\"".$options[$i]."\">".ucfirst($options[$i])."</option>\n"; 
        } 
    $text="\n\n<select>\n"; 
    $text.=$items; 
    $text.="</select>\n\n"; 
    return "items<hr>".$text; 
    } 
?>

Privacy Policy | Link to Us | Links