assign selected option value from database

Question

I have a form which contains a dropdown list of countries generated from database. The values are stored in database. There is an option in which user can view or update the valuesinserted. For updating all the form values get fetched from database. What i require is that when form is loaded for updating the selected option of the country dropdown must be that stored in the database. For eg: if from the following dropdown option2 is selected and inserted into database.

 Dropdown: |option1|<selected>
           |option2|
           |option3|

during update it should be like this

 Dropdown: |option1|
           |option2|<selected>
           |option3|

Here is the code i tried.

      $selected = $list["country_country_name"];

     <tr><td>Country</td><td><select onchange="getCountry(this.value);" name="country" id="country" ><?php  foreach( $query as $qry ) { 
     print '<option value="'.$qry["country_country_name"].'"'; 
     if( $qry["country_country_name"] == $selected ) print'selected'; 
     print '>'.$qry["country_country_name"].'</option>'."\n";} ?>
     </select></td></tr>

the person who downvoted pls tell the reason so that i can make my question clear if thats the reason — Avinash
– Avinash, Commented Oct 9, 2012 at 11:58
why dont you use a select ? with an list of options ? with that you can fetch the selected option. do you want an example? — Tiago Moutinho
– Tiago Moutinho, Commented Oct 9, 2012 at 11:59
i am populating my dropdown from db. if this is not what u meant pls provide eg: — Avinash
– Avinash, Commented Oct 9, 2012 at 12:01

Tiago Moutinho · Accepted Answer · 2012-10-09 12:03:51Z

1

<select id="list" name="list">
    <option value=""> Please Select </option>
    <?
        $list = array('1',
                        '2',
                        '3',
                        '4',
                        '5',
                        '6');

        while ($L = array_shift($list)) {
            ?>
                <option value="<?=$L?>" <? if($selected == $L){ echo 'selected="selected"'; }?> > 
                    <?= $L ?> 
                </option> 
            <?
         }
    ?>
</select>

you can simple get the selected option with this:

$("#list").val();

try please.

answered Oct 9, 2012 at 12:03

Tiago Moutinho

1,3721 gold badge13 silver badges18 bronze badges

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

Comments

harsh4u · Accepted Answer · 2012-10-09 12:00:51Z

0

$selected = $list["country_country_name"];

 <tr><td>Country</td>
 <td>
 <select onchange="getCountry(this.value);" name="country" id="country" >
 <?php  foreach( $query as $qry ) { 
    $sel = '';
   if( $qry["country_country_name"] == $selected ) 
    $sel = 'selected="selected"';           

    echo '<option value="'.$qry["country_country_name"].'" '.$sel.'>'.$qry["country_country_name"].'</option>'."\n";
    } ?>
    </select>
    <?php echo form_error('country'); ?>
    </td>
 </tr>

answered Oct 9, 2012 at 12:00

harsh4u

2,6104 gold badges26 silver badges39 bronze badges

Comments

mickmackusa · Accepted Answer · 2018-10-25 10:30:51Z

0

When your option tag's value attribute contains the same value as the option's text, the value attribute is not necessary -- so omit it.

Below shows an inline condition statement.

<tr>
    <td>Country</td>
    <td><select onchange="getCountry(this.value);" name="country" id="country">
        <?php
        foreach ($query as $row) { 
            echo "<option" ,
                ($row["country_country_name"] == $list['country_country_name'] ? ' selected' : '') ,
                "{$row['country_country_name']}</option>\n";
        }
        ?>
    </select></td>
</tr>

answered Oct 25, 2018 at 10:30

mickmackusa♦

49.3k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

assign selected option value from database

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related