reading enum field from database

[pradeepjain]

hii guys ,
I have a mysql enum column field with say

'type'   enum(cdma,gsm,both) 

is there a way from php to read the enums and make it a dropdown list ???

[Atli]

Hi.

You can get the type of the column using the "SHOW COLUMNS" command:

mysql> SHOW COLUMNS FROM `table`LIKE 'type';
+-------+---------------------------+------+-----+---------+-------+
| Field | Type                      | Null | Key | Default | Extra |
+-------+---------------------------+------+-----+---------+-------+
| type  | enum('cdma','gsm','both') | YES  |     | NULL    |       |
+-------+---------------------------+------+-----+---------+-------+

And from there you could just parse the values out of the "Type" field.

[Atli]

On second thought, you would probably be better of using the PHP functions specifically made to get that info:
mysql_list_fields or mysql_field_type.

That should get you the type, which you can extract the values from.

[pradeepjain]

http://www.imranulhoque.com/mysql/bu...r-enum-fields/

i found this post with a function to create dropdown ... this helped me !! :)

[pradeepjain]

that link worked for me but i am getting the values like 'cdma' 'gsm' ....i dont what's the reason :(

[Atli]

Isn't that what you wanted? To get the enum values like that?

Anyways, we can't do much unless you show us the code, and perhaps an example of the output you are getting, and the output you actually wanted.

[pradeepjain]

@Atli
yeah i wanted the same but output is getting displayed along with the quotes like 'gsm' instead of gsm !!!

function getEnumFieldValues($tableName, $fieldName){
$field_query = mysql_query("show columns from $tableName where Field='$fieldName'");
if(mysql_num_rows($field_query) <= 0) return false;
$fieldDetail = mysql_fetch_array($field_query);
$type = preg_replace('/(^set\()|(^enum\()/i', '', $fieldDetail['Type']);
$enumFields = substr($type, 0, -1);
$fieldSplit = split(',', $enumFields);
return $fieldSplit;
}
 
 
 
$enumFields = getEnumFieldValues('agree', 'test');
echo '<select name="agree">';
foreach($enumFields as $value){
echo '<option value="' . $value . '">' . $value . '</option>';
}
echo '</select>';

[Atli]

Ahh so it's just the quote-marks that need to be removed?

Try using the str_replace function on the "$enumFields" string *before* it is split into induvidual words. (Which happens on line #7)

[pradeepjain]

i dono how strange it is but the same thing i use for value and displaying

 echo '<option value=' . $value . ">' . $value . '</option>';

the value which gets stored in DB gets stored with out quotes . while displaying alone quotes getting displayed .