在下拉列表中显示已保存的数据 - html选择标记

Question

I have a static dropdown list in a form as below:

<select class="form-control" id="brand" name="brand">
<option value="">Please select a Brand</option>
<option value="Apple">Apple</option>
<option value="Samsung">Samsung</option>
<option value="Sony">Sony</option>
</select>

When User choose a brand, let say: Apple and Submit the form. The value "Apple" will be saved in mysql database. I have option for user to edit their form after submitting it.

When user edits the form, I know how to retrieve data from mysql and echo it out but how to make this option which contains value "Apple" as selected so that this value "Apple" will be shown up as default in stead of "Please select a brand"?

Thanks,

Answer 1

Assuming the variable from your database holding this value is $brand then you could do something like this:

<select class="form-control" id="brand" name="brand">
   <option value="">Please select a Brand</option>
   <option value='Apple' <?php echo $brand=='Apple'?'selected':''; ?>>Apple</option>
   <option value='Samsung' <?php echo $brand=='Samsung'?'selected':''; ?>>Samsung</option>
   <option value='Sony' <?php echo $brand=='Sony'?'selected':''; ?>>Sony</option>
</select>

Of course this could be done by a loop if you could get all your brands in one query. Perhaps something like this:

<select class="form-control" id="brand" name="brand">
<?php
 $brands_array=array("Apple","Samsung","Sony"); // could come from DB
  foreach($brands_array as $b) {
   echo '<option value="',$b,'"',( $brand==$b ?' selected="selected"':'').'>',$b,'</option>';
  }
?>
</select>

Hope this helps.

Credits to Ismael Miguel for his valuable comments and suggestions