<select> dropdown default value

Question

I have this code:

if(isset($_POST['search']))
{
    $res1=mysql_query("SELECT * FROM aircraft where acode = '$_POST[ac]'") or die(mysql_error());
    while($row=mysql_fetch_array($res1))
    {
        $airc=$row['acode'];
        $amode=$row['amodel'];
        $stat=$row['status'];
        $rem=$row['remarks'];

    echo "<center><table><form name=\"frmMain\" method=\"post\"> 
        <tr><td><font face=consolas><b>Aircraft Code:</b></font></td><td><input type=text name=arc value='$airc' readonly=readonly></td></tr>
        <tr><td><font face=consolas><b>Aircraft Model:*</b></font></td><td><input type=text name=am value='$amode'></td></tr>
        <tr><td><font face=consolas><b>Status:*</b></font></td><td><input type=text name=st value='$stat'></td></tr>
        <tr><td><font face=consolas><b>Remarks:*</b></font></td><td><input type=text name=rm value='$rem'></td></tr></table>";
    }
}

On submit 'search' button, this code displays the data from aircraft table. The user is allowed to update the data with the (*) sign.

Since the Status are the following by default (Available, Not Available), I changed this

 <tr><td><font face=consolas><b>Status:*</b></font></td><td><input type=text name=st value='$stat'></td></tr>

to this,

<tr><td><font face=consolas><b>Status:*</b></font></td><td><select name=st>
    <option value=Available>Available</option>
    <option value='Not Available'>Not Available</option>
</select></td></tr>

But I want the dropdown to have it's default value depending on $stat=$row['status']; since this is an update form.

If the data being retrieved has it's status 'Available', then the dropdown should have it's default value as 'Available'.

How can I achieve that? I tried <select name=status value='$stat'> but it doesn't work. Any help will be appreciated. Thanks!

Possible duplicate How to set default value for HTML select element? — Havelock
– Havelock, Commented Sep 6, 2012 at 6:18

Vinay · Accepted Answer · 2012-09-06 06:20:46Z

14

Just put selected="selected" on the option depending on your $row['status'],

<option selected="selected" value="available">Available</option>

answered Sep 6, 2012 at 6:20

Vinay

2,5944 gold badges27 silver badges35 bronze badges

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

Comments

Sam Janssens · Accepted Answer · 2012-09-06 06:24:30Z

write Available and Unavailable into an array

$theArray = array("Available","Not Available");

loop the array:

<tr><td><font face=consolas><b>Status:*</b></font></td><td><select name=st>
<?php
foreach ($theArray as $key => $value) {
    if ($value == $stat) {
        echo('<option selected="selected" value='.$value.'>'.$value.'</option>');
    } else {
        echo('<option value='.$value.'>'.$value.'</option>');
    }
}
?>
</select></td></tr>

and in each loop we check if the value in the array, is the same as it is in the variable, if so, we put the selected there

understand the logic?

Pro Tip: there is absolutely no advantage/benefit in repeating the option's text as the value declaration.

Rohan Sood · Accepted Answer · 2012-09-06 06:15:24Z

1

<select name=status>
<option value="available" <?php if($row['status']=="available") echo "selected=\"selected\""; ?>>Available</option>
<option value="unavailable" <?php if($row['status']=="unavailable") echo "selected=\"selected\""; ?>>Unvailable</option>
</select>

Basically echo selected="selected" for the option depending on value of the concerned field.

answered Sep 6, 2012 at 6:15

Rohan Sood

4371 gold badge4 silver badges19 bronze badges

1 Comment

Rohan Sood Over a year ago

It is basic php code editing. I could type it out for you, but you really should figure it out your self. TIP : Use separate echo commands for your fields/commands.

amitchhajer · Accepted Answer · 2012-09-06 06:17:11Z

1

<?php
$status = "navail";
?>
<select name="sel">
<option value="avail" <?php if($status == "avail") echo "SELECTED";?> > Avail </option>
<option value="navail" <?php if($status == "navail") echo "SELECTED";?> > Navail </option>
</select>

answered Sep 6, 2012 at 6:17

amitchhajer

13k6 gold badges43 silver badges54 bronze badges

Comments

mickmackusa · Accepted Answer · 2021-04-05 10:27:33Z

1

You can define your variable value with additional option tag and mark that as selected like:

<select name="role" id="role">
<!-- This is default define value using php variable $r -->
<option selected="selected" value="<?php echo $r; ?>" disabled="disabled"><?php echo $r; ?></option>

<!-- Other options values -->
<option value="2">Option-2</option>
<option value="2">Option-2</option>
</select>

edited Apr 5, 2021 at 10:27

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Nov 9, 2016 at 18:11

A.Aleem11

1,97417 silver badges12 bronze badges

Comments

Pragnesh Chauhan · Accepted Answer · 2021-04-05 16:20:31Z

1

You can set the selected dropdown option from database as below:

<select name="status"> 
<option <?php echo ($row['status'] == 'Available') ? 'selected' : '' ?> value='Available'>Available</option> 
<option <?php echo ($row['status'] == 'Not Available') ? 'selected' : '' ?> value='Not Available'>Not Available</option> 
</select>

edited Apr 5, 2021 at 16:20

answered Sep 6, 2012 at 6:22

Pragnesh Chauhan

8,49410 gold badges46 silver badges58 bronze badges

1 Comment

mickmackusa Over a year ago

Pro Tip: there is absolutely no advantage/benefit in repeating the option's text as the value declaration. "You can do this" is not an explanation of how your snippet works or why it is a good idea.

jeswin · Accepted Answer · 2013-10-08 10:33:48Z

0

Declare the options in an array like

$arr = array("available" => "available","unavailable" => "unavailable");

and input the drop down like this

echo form_dropdown("st", $arr, set_value("st", (isset($row['status'];) ? $row['status']; : ""))

This is the method commonly used in frameworks like codeigniter.. i think it works in core php too..

answered Oct 8, 2013 at 10:33

jeswin

3824 silver badges9 bronze badges

Comments

justin · Accepted Answer · 2018-09-29 06:05:13Z

its my first time here though and i tried using basic principles in php, dont know if this helps you but if you're trying to grab the defaulted value which you inputted on your database then edit it again i suggest you try this one

<select name="st">
<?php if($row['status']=="Available"){?><option value="Available">Available</option><?php }?>
<?php if($row['status']=="Unavailable"){?><option value="Unavailable">Unavailable</option><?php }?>
</select>

Assuming that the column name in your database is 'status', give it a try works for me

Collectives™ on Stack Overflow

<select> dropdown default value

8 Answers 8

Comments

1 Comment

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

1 Comment

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Linked

Related