my html form consists of drop down for selecting city and state.
radio buttons for selecting gender.
and a few check boxes.
the form is filled and the values are stored in a database table.
I am working on a php script, which retrieves values from database into an array.
consider that my array's first element corresponds to a radio button with value M ( M- male)
then i want the radio button for male to be selected.
similarly if a particular city is selected the i want that city selected in the drop down menu...
this is similar to web sites to which we are registered allow us to update our profiles by displaying the fields with the old values....
your response will be of great help to me...
thanking you guys in advance!!
retrieve checkbox,radio and drop down value from database
Moderator: General Moderators
Re: retrieve checkbox,radio and drop down value from databas
To display data pulled of a db in a drop down list you just check if your array holds the needed variable and display it in the list like I use in my country example below.
A very good explanation how to deal with radio buttons you find here http://www.homeandlearn.co.uk/php/php4p10.html.
Hope I could give you a couple of ideas
Code: Select all
<?php
//your mysql connections and query here
$data = mysql_fetch_array($res);
?>
<form action="call the same script" method="post" >
<!-- whatever formfields you have--!>
<select name="country">
<?php
if(!empty($data['country'])
{
echo "<option value=\"".$data['country']."\">".$data['country']."</option>"; //if there is an entry in the db this will be displayed first
}
?>
<option value="Afganistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
</select>
<!--A quick example how to deal with a checkbox --!>
<input type="checkbox" name="option" value="checkbox" <?php if($data['option']=='1'){ echo "checked=\"true\""; }?>>
</form>
Hope I could give you a couple of ideas