如何在php中填充数据库中的Dropdown值

Question

Hello Friends how to get data from database in Drop-down list?

This is my code but i can't get data in Drop-down list,

This is my php code.

public function System_parameter_dropdown_value() {
   $sql= " SELECT * FROM SYSTEM_PARAMETERS WHERE     PARAMETER_KEY='ROLE_TYPE'";
   $rs=  mysql_query($sql) or die(mysql_error());
   $option_list="<option value=0>Select Role Type</option>";
   while($data=  mysql_fetch_assoc($rs)) {
      $option_list.="<option value='$data[PARAMETER_KEY]'>
      $data[PARAMETER_VALUE]</option>";
   }
   return $option_list;
}

This is my html option list, When i run the code it's show nothing in Dropdown list

<label class="control-label" for="roleid"  style="padding-right: 80px;">ROLE TYPE</label>
   <select id="" name="roleid">
      <?php echo $option_list['PARAMETER_KEY']['PARAMETER_VALUE'];?>
   </select>

I am Stuck on this code , please Guide me How to Resolve it.

Answer 1

Try some thing like this:

$arr = array(1 => 'MP', 2 => 'UP');

echo '<select>';
foreach($arr as $key => $val)
{
    echo '<option value="'.$key.'">'.$val.'</option>';
}
echo '</select>';

It will generate html like:

<select>
  <option value="1">MP</option>
  <option value="2">UP</option>
</select>

In your case it is like:

<select id="" name="roleid">
  <?php echo System_parameter_dropdown_value();?>
</select>