Php: Set default drop down value in a loop

Question

A drop down list is printed in php in a while loop by taking value from database table. Here is the code:

  <select name='supervisor' class='form-control' name='supervisor'>
  <?php
  $sql = "SELECT username FROM system_user where type='supervisor'";
  $result = mysql_query($sql); 
  while ($row = mysql_fetch_array($result)) {
  echo "<option value='" . $row['username'] ."'>" . $row['username'] ."</option>";}?>
  </select>

How can I set a default value for this? There is one 'username' value that i want to make as the default value. How can i do that?

Harish Singh · Accepted Answer · 2013-11-21 17:20:39Z

2

<select name='supervisor' class='form-control' name='supervisor'>
  <?php
      $sql = "SELECT username FROM system_user where type='supervisor'";
      $result = mysql_query($sql); 
      while ($row = mysql_fetch_array($result)) {
          $sel = ''; if($row['username'] == 'usename'){ $sel = 'selected'; }
          echo "<option $sel value='" . $row['username'] ."'>" . $row['username'] ."</option>";
      } ?>
  </select>

answered Nov 21, 2013 at 17:20

Harish Singh

3,3195 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammed Al Ashaal · Accepted Answer · 2013-11-21 17:37:16Z

1

function dropDown(array $array, $default = null, $select_attrs = '')
{

     $s = '<select $select_attr>';
     foreach((array)$array as $k => &$v) {
          $default = ($v === $default) ? 'selected' : null;
          $s.='<option '.$default.' >'.$v.'</option>';
     }
     return $s;
}

answered Nov 21, 2013 at 17:37

Mohammed Al Ashaal

4204 silver badges11 bronze badges

Comments

hakkim · Accepted Answer · 2014-09-04 08:19:59Z

1

this one worked for me...

<select name='supervisor' class='form-control' name='supervisor'>


<?php
  $sql = "SELECT username FROM system_user where type='supervisor'";
  $result = mysql_query($sql); 
  while ($row = mysql_fetch_array($result)) {
      $sel = ''; if($row['username'] == 'usename'){ $sel = 'selected'; }
      echo "<option $sel value='" . $row['username'] ."'>" . $row['username'] ."</option>";
  } ?>

answered Sep 4, 2014 at 8:19

hakkim

6581 gold badge15 silver badges37 bronze badges

Collectives™ on Stack Overflow

Php: Set default drop down value in a loop

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related