reading enum field from database

pradeepjain

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

Expand|Select|Wrap|Line Numbers

'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:

Expand|Select|Wrap|Line Numbers

 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

Quote:

Originally Posted by 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.

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

Expand|Select|Wrap|Line Numbers

 
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

Expand|Select|Wrap|Line Numbers

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

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

reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

re: reading enum field from database

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about