Geek Answers Handbook

List of enum values ​​in php mysql dropdown

I have a mysql table that contains the following columns.

 Id     Name      Sex

and the sex column have an enum type ('Male', 'Female', 'Unspecified')

How can I list enumeration values ​​in a drop-down list and make the current saved value selected

+5
source share
2 answers

Check out this link ... its pretty awesome .. the script can be reused for any enum column:

http://jadendreamer.wordpress.com/2011/03/16/php-tutorial-put-mysql-enum-values-into-drop-down-select-box/

+11
source

, , ( ). Enum , , , , . , .

, html:

<form>
  <select name="gender">
    <option value="Unspecified">Unspecified</option>
    <option value="Male">Male</option>
    <option value="Female">Female</option
  </select>
</form>

:

<form>
  <select name="gender">
    <option value="Unspecified" <?php if($gender == "Unspecified") { echo "SELECTED"; } ?>>Unspecified</option>
    <option value="Male" <?php if($gender == "Male") { echo "SELECTED"; } ?>>Male</option>
    <option value="Female" <?php if($gender == "Female") { echo "SELECTED"; } ?>>Female</option
  </select>
</form>

:

function gender_select($default_value='') {
  $select = '<select name="gender">';
  $options = array('Unspecified','Male','Female',);
  foreach($options as $option) {
    $select .= write_option($option, $option, $default_value);
  }
  $select .= '</select>';
  return $select;  
}

function write_option($value, $display, $default_value='') {
  $option = '<option value="'.$value.'"';
  $option .= ($default_value == $value) ? ' SELECTED' : '';
  $option .= '>'.$display.'</option>';
  return $option;
}

, :

<form>
<?php echo $gender_select($gender); ?>
</form>
+5

More articles:


All Articles