Help me to display enum fields value in form

[linux1880]

I have a database field

 

 `color` enum('red','blue','green','white') DEFAULT NULL,

and php form

<label for="color">Colors</label><br />
<input type="text" name="color" />

How do i display enum value on the php form from mysql database? Please help

 

php mysql

[mikosiko]

One way:

 

- execute a query to the DB to get the enum field definition... per example:

  $query = "SHOW columns FROM yourtable LIKE 'yourenumcolname'";
  $result = mysql_query($query) or die(mysql_error());
  $row = mysql_fetch_assoc($result);
   $thevalues =  $row['Type'];
   echo $thevalues;  // here instead of echo you must parse it to obtain the values individually
  // rest of your code

 

   

[linux1880]

Thannks mikosiko,

after applying above i got the below print of var_export($variable)

array (
  'Field' => 'color',
  'Type' => 'enum(\'red\',\'blue\',\'green\',\'white\')',
  'Null' => 'YES',
  'Key' => '',
  'Default' => NULL,
  'Extra' => '',
)

 

How do i now make it a selection list of colors ? Pls help

[ignace]

$values = array_map('trim', explode(',', trim(substr($row['Type'], 4), '()')));

 

Returns: 'red', 'blue', 'green', 'white' surrounded with '

[linux1880]

well echo $values just giving Array.

[Andy-H]

<label for="color">Colors</label><br />
<select name="color" id="color">
<?php
   foreach($values as $color):
      echo '<option value="' . $color . '">' . $color . '</option>' . "\r\n";
   endforeach;
?>
</select>

 

That should do it.

[mikosiko]

<label for="color">Colors</label><br />
<select name="color" id="color">
<?php
   foreach($values as $color):
      echo '<option value="' . $color . '">' . $color . '</option>' . "\r\n";
   endforeach;
?>
</select>

 

That should do it.

 

EDITED: I was replying the same when I saw this

 

 

[ignace]

well echo $values just giving Array.

 

Maybe take a PHP course?