HTML <Select> <Option> default based on MySQL data

Question

I have a simple inventory database and on the input_data form, one of the input fields is field, as follow:

<select>
    <option>In Inventory</option>
    <option>In Process</option>
    <option>Shipped/in-transit</option>
    <option>Received by recipient</option>
</select>

If for example I input a data with "In Process" and later I would like to update that perticular data. The default back to "In Inventory" on my update_page.php file. I would like to see the "In Process" value selected.

Here is a snippet from my non-working code from my update_page.php:

<select name="status" value="<?php echo $row['status']; ?>">
    <option>In Inventory</option>
    <option>In Process</option>
    <option>Shipped/in-transit</option>
    <option>Received by recipient</option>
</select>

HorusKol · Accepted Answer · 2013-06-12 22:22:30Z

Select has no value attribute in HTML - you can have multiple options selected, and this is determined by the selected attribute on the option element

Mucky way:

<select name="status">
    <option<?php if ($row['status'] == "In Inventory"): ?> selected="selected"<?php endif; ?>>In Inventory</option>
    <option<?php if ($row['status'] == "In Process"): ?> selected="selected"<?php endif; ?>>In Process</option>
    <option<?php if ($row['status'] == "Shipped/in-transit"): ?> selected="selected"<?php endif; ?>>Shipped/in-transit</option>
    <option<?php if ($row['status'] == "Received by recipient"): ?> selected="selected"<?php endif; ?>>Received by recipient</option>
</select>

Slightly better way:

 <?php
      $options = array("In Inventory", "In Process", "Shipped/in-transit", "Received by recipient");
 ?>

 <select>
     <?php foreach ($options as $option): ?>
         <option value="<?php echo $option; ?>"<?php if ($row['status'] == $option): ?> selected="selected"<?php endif; ?>>
             <?php echo $option; ?>
         </option>
     <?php endforeach; ?>
 </select>

Best way - store these options in a database table - probably better using ID values rather than strings (allows for easier updating of option labels) and loop over the possible options taking from a DB query like I have above. If this select list is used a lot, cache the results of the query to get the options (remember that you'd need to clear the cache if the list gets updated)

xmarston · Accepted Answer · 2013-06-12 22:24:45Z

0

Each option has its corresponding value not the select tag. So, you will have to compare the values of each option with the status.

answered Jun 12, 2013 at 22:24

xmarston

8833 gold badges13 silver badges38 bronze badges

Comments

Joel Hinz · Accepted Answer · 2013-06-12 22:28:35Z

0

You'll have to check for each one if it's the selected one, like this, for exampel:

<option <?php if ($row['status'] == 'In Process') echo 'selected'; ?>>In Process</option>

If you use jQuery, you could do a somewhat cleaner solution, in your case give your select tag an id, then:

$(document).ready(function() {
    $('#select-id option:contains("<?php echo $row['status']; ?>")').prop('selected', true);
});

answered Jun 12, 2013 at 22:28

Joel Hinz

25.4k8 gold badges65 silver badges78 bronze badges

2 Comments

HorusKol Over a year ago

That's not cleaner - that's complicating the issue by putting the logic in two different places

Joel Hinz Over a year ago

Yeah, fair enough. I disagree, but I see your point, and I realise it's not necessarily a good suggestion.

Sarchophagi · Accepted Answer · 2015-02-20 12:03:19Z

0

The simpler code I've found, using only JavaScript (no jQuery needed). Put it right after the declaration of the listbox and set the selected index there:

<script>
document.getElementById('listBoxId').selectedIndex=<?php echo $INDEX ?>;
</script>

answered Feb 20, 2015 at 12:03

Sarchophagi

3862 gold badges7 silver badges21 bronze badges

Collectives™ on Stack Overflow

HTML <Select> <Option> default based on MySQL data

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related