PHP Mysqli HTML How to have current value from database selected in <select>

Question

my goal is get current value from database, selected in the dropdown list. I tried that code but it shows always "Ndone" in the dropdownlist

<select name="work" id="work" value="<?php echo $work; ?>">
     <option selected="selected" value=""></option>
     <option selected="selected" value="DONE">DONE</option>
     <option selected="selected" value="NDONE">NDONE</option>
</select>

Also this one and nothing just the first row that selected in the dropdownlist

<select name="work" id="work" value="<?php echo $work; ?>">
     <option value=""></option>
     <option value="DONE">DONE</option>
     <option value="NDONE">NDONE</option>
</select>

I don't know what to do, any help please

When i use a textfield it works, so there's no problem with the variable $work

<input type="text" name="work" value="<?php echo $work; ?>"/>

Problem may be in your SQL, which isn't in your question, even some more PHP. Just dropdown code isn't enough to know for sure. — Funk Forty Niner
– Funk Forty Niner, Commented Oct 23, 2014 at 14:51
php works correctly because when i use a text field instead of dropdownlist, it shows the current value from database, no problem with that — Yassine
– Yassine, Commented Oct 23, 2014 at 14:56
Then see what the differences are between both and base yourself on that. — Funk Forty Niner
– Funk Forty Niner, Commented Oct 23, 2014 at 14:57

BreyndotEchse · Accepted Answer · 2014-10-23 15:04:29Z

1

<select> does not have a "value" Attribute. You must add the selected attribute to one option.

<?php
$options = array(
    '',
    'DONE',
    'NDONE',
);
?>

<select name="work" id="work">
    <?php foreach ($options as $option): ?>
        <option value="<?php echo $option ?>"<?php echo $option === $work ? ' selected="selected"' : '' ?>><?php echo $option ?></option>
    <?php endforeach ?>
</select>

answered Oct 23, 2014 at 15:04

BreyndotEchse

2,23015 silver badges20 bronze badges

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

Comments

David Jones · Accepted Answer · 2014-10-23 15:18:15Z

0

As per your example you could do this:

You just need to check each option value against the $work variable and if it matches add the selected attribute.

<select name="work" id="work">
     <option value=""></option>
     <option value="DONE" <?php echo($work == 'DONE'?'selected="selected"':''); ?>>DONE</option>
     <option value="NDONE" <?php echo($work == 'NDONE'?'selected="selected"':''); ?>>NDONE</option>
</select>

edited Oct 23, 2014 at 15:18

answered Oct 23, 2014 at 15:08

David Jones

4,3157 gold badges31 silver badges51 bronze badges

2 Comments

Yassine Over a year ago

that doesn't work, it shows nothing, Thank you anyway :)

David Jones Over a year ago

Sorry I had an error - see update - The second ? in the ternary operator should have been a :

Collectives™ on Stack Overflow

PHP Mysqli HTML How to have current value from database selected in <select>

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related