php & mysql dropdown option selected issue

Question

when i try to selected option from sql in dropdown list i get all options is selected :

$status1 = $row7["status"];

if($status1 == "draft") { $slc = "selected"; }
if($status1 == "ordered") { $slc = "selected"; } 
if($status1 == "shipped") { $slc = "selected";  }

echo "
  <select class=\"form-control input-sm\" name = \"o_status\">
    <option value = \"draft\" $slc>draft</option>
    <option value = \"ordered\" $slc>ordered</option>
    <option value = \"shipped\" $slc>shipped</option>
  </select>
";

my problem with output selected all options like that :

  <select class="form-control input-sm" name = "status">
<option value = "draft" selected>draft</option>
<option value = "ordered" selected>shipped</option>
<option value = "shipped" selected>shipped</option>

Therichpost · Accepted Answer · 2017-04-04 11:04:00Z

4

Please check now.

Hope this helps you:

$status1 = $row7["status"];

if($status1 == "draft") { $draft = "selected"; }
if($status1 == "ordered") { $ordered = "selected"; } 
if($status1 == "shipped") { $shipped = "selected";  }

  echo "
  <select class=\"form-control input-sm\" name = \"o_status\">
 <option value = \"draft\" $draft>draft</option>
 <option value = \"ordered\" $ordered>ordered</option>
 <option value = \"shipped\" $shipped>shipped</option>
 </select>
  ";

answered Apr 4, 2017 at 11:04

Therichpost

1,8132 gold badges15 silver badges19 bronze badges

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

2 Comments

r00t-err0r Over a year ago

This will cause error like PHP Notice: Undefined variable: ordered in thisfile.php on line 22 cause when one is selected, other does not defined. Take a look on my reply ;)

r00t-err0r Over a year ago

@Sky working fine? Did you look at error.log ? :) This code have errors 100%, take a look ;)

Mihai Matei · Accepted Answer · 2017-04-04 12:37:33Z

4

You can define an array of statuses in order to set the select options:

<?php
    $statuses = array(
        'draft' => 'New draft',
        'ordered' => 'New order',
        'shipped' => 'New ship'
    );
?>

<select class="form-control input-sm" name="status">
<?php
    foreach ($statuses as $status => $name) {
?>
    <option value="<?php echo $status ?>" <?php echo $status === $row7['status'] ? 'selected="selected"' : '' ?>>
        <?php echo $name ?>
    </option>
<?php
    }
?>
</select>

edited Apr 4, 2017 at 12:37

answered Apr 4, 2017 at 10:59

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

2 Comments

Sky Over a year ago

if options name different options value how i can set it ?

r00t-err0r Over a year ago

Yes you can: try this:

<?php     $statuses = array('draft'=>'something1', 'ordered'=>'something2', 'shipped'=>'something3');     $row7['status'] = 'draft'; ?>  <select class="form-control input-sm" name="status"> <?php     foreach ($statuses as $status=>$value) { ?>     <option value="<?php echo $value ?>" <?php echo $status === $row7['status'] ? 'selected="selected"' : '' ?>>         <?php echo $status ?>     </option> <?php     } ?> </select>

r00t-err0r · Accepted Answer · 2017-04-04 11:14:19Z

1

Maybe this helps:

<?php
switch ($row7["status"]) {
    case 'draft':
        $draft = "selected";
        $shipped = "";
        $ordered = "";
        break;
    case 'ordered':
        $ordered = "selected";
        $draft = "";
        $shipped = "";
        break;
    case 'shipped':
        $shipped = "selected";
        $draft = "";
        $ordered = "";
        break;
    default:
        $draft = "";
        $shipped = "";
        $ordered = "";
        break;
}
echo "<select class=\"form-control input-sm\" name = \"o_status\">
    <option value = \"draft\" $draft>draft</option>
    <option value = \"ordered\" $ordered>ordered</option>
    <option value = \"shipped\" $shipped>shipped</option>
  </select>";
?>

edited Apr 4, 2017 at 11:14

answered Apr 4, 2017 at 11:08

r00t-err0r

1841 silver badge11 bronze badges

Collectives™ on Stack Overflow

php & mysql dropdown option selected issue

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related