passing values using get from a dropdown populated from a mysql database

Question

i have problem passing data from one page to another using GET, for example

i have these:

<form method=post action=edit.php>
<td><input type=text name=firstname></td>
<td>
<?
    $query="SELECT * FROM gender;
    $result = mysql_query ($query);
    echo "<select name=gender_id>";
    while($nt=mysql_fetch_array($result))
    {
    echo "<option value=$nt[gender_id]>$nt[gender_name]</option>";
    }
    echo "</select>";
?>
</td>
<td><input type=submit name=edit></td>
</form>

now to pass these to edit.php using GET

if($mode=="edit")
{
$fistname=$_GET["fistname"];
$gender=$_GET["gender_id"];
<td><input type=text name=firstname value="<? echo $fistname; ?>"></td>

Above is a working code for an input type text. I know how to pass values with input type text but my problem is that HOW WOULD I DO THESE WITH A SELECT tag WHICH HAS VALUES FROM A MYSQL DATABASE?.

i do not understand the problem what $gender contain ?

Haim Evgi
– Haim Evgi

2010-10-05 05:20:56 +00:00
Commented Oct 5, 2010 at 5:20 — Haim Evgi
– Haim Evgi, Commented Oct 5, 2010 at 5:20

storm_buster · Accepted Answer · 2010-10-05 11:54:32Z

1

<?
    $query="SELECT * FROM gender;
    $result = mysql_query ($query);
    echo "<select name=gender_id>";
    while($nt=mysql_fetch_array($result))
    {
    if ($nt[gender_id]==$_POST["gender_id"])
       $selected="selected";
    else
        $selected="";
    echo "<option ".$selected."value=$nt[gender_id]>$nt[gender_name]</option>";
    }
    echo "</select>";
?>

answered Oct 5, 2010 at 11:54

storm_buster

7,56818 gold badges56 silver badges76 bronze badges

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

Comments

storm_buster · Accepted Answer · 2010-10-05 05:24:12Z

0

you were using <form method=**post** action=edit.php>, in that way you should use $fistname=$_POST["fistname"]; $gender=$_POST["gender_id"];

if you want to use $fistname=$_GET["fistname"]; $gender=$_GET["gender_id"]; you should use <form method=**get** action=edit.php but in that way, the thoses values will be visible in the url.

answered Oct 5, 2010 at 5:24

storm_buster

7,56818 gold badges56 silver badges76 bronze badges

1 Comment

kester martinez Over a year ago

you didnt get the point. ok let us say i should use post. then how should pass the value of the dropdown? for example a user chose female as her gender, then she tries to edit it to male, how can i echo the value gender which is female in the dropdown? same as i can echo her name after choosing the edit button. thank you.

Ruel · Accepted Answer · 2010-10-05 05:27:01Z

0

You have a typographical error on your edit.php change $_GET['fistname'] to $_GET['firstname']. Then edit:

<form method=post action=edit.php>

and put method="get"

<form method=post action=edit.php method="get">

And to prevent errors on edit.php. Add these:

if ((isset($_GET['firstname']) && (isset($_GET['gender_id'])) {
    //your code
} else {
    //some error message
}

answered Oct 5, 2010 at 5:27

Ruel

15.8k7 gold badges41 silver badges49 bronze badges

1 Comment

kester martinez Over a year ago

my bad. typo error.. you didnt get the point. ok let us say i should use post. then how should pass the value of the dropdown? for example a user chose female as her gender, then she tries to edit it to male, how can i echo the value gender which is female in the dropdown? same as i can echo her name after choosing the edit button. thank you.

Ignacio Vazquez-Abrams · Accepted Answer · 2010-10-05 07:28:10Z

0

<form method="GET" action="edit.php">

Or use $_POST in the script instead.

EDIT, since you didn't bother putting your question in the question:

As you iterate through the options, test the value of $nt[gender_id] and add the selected attribute to the one that matches.

edited Oct 5, 2010 at 7:28

answered Oct 5, 2010 at 5:22

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

2 Comments

kester martinez Over a year ago

you didnt get the point. ok let us say i should use post. then how should pass the value of the dropdown? for example a user chose female as her gender, then she tries to edit it to male, how can i echo the value gender which is female in the dropdown? same as i can echo her name after choosing the edit button. thank you.

Ignacio Vazquez-Abrams Over a year ago

... You don't know how to write an if statement?

Collectives™ on Stack Overflow

passing values using get from a dropdown populated from a mysql database

4 Answers 4

Comments

1 Comment

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related