PHP MySQL Dropdown box

Question

I have a dropdown box which is populated through MySQL:

echo "<form>";<br>
echo "Please Select Your Event<br />";
echo "<select>";
$results = mysql_query($query)
    or die(mysql_error());
    while ($row = mysql_fetch_array($results)) {
    echo "<option>";
    echo $row['eventname'];
    echo "</option>";
    }   
echo "</select>";
echo "<input type='submit' value='Go'>";
echo "</form>";

How do i make it that if one clicks submit it will display a value from a MySQL db

Thanks for the help

Do you want it to display the value on the page that submitted was clicked on, or on the page that the submit button leads to? — Mike Lentini
– Mike Lentini, Commented Sep 26, 2011 at 12:20
on the same page would be better. Basically the value for the dropdown is $row['eventname']; When selected or submited it displays the value $row['result']; Those two values are already connected using a SQL query. — SebastianOpperman
– SebastianOpperman, Commented Sep 26, 2011 at 12:26
Just an FYI, it may be easier to just add the loop between the <select>..</select> tags in regular HTML, rather than echoing each tag -- unless that was just for posting on here. Also, may want to check out jQuery's Ajax capabilities - www.jquery.com — NightMICU
– NightMICU, Commented Sep 26, 2011 at 13:16

Olli · Accepted Answer · 2011-09-26 12:29:47Z

1

Just change your query like SELECT result FROM somedb WHERE eventname = '".$eventname."'

Then you just do: (remember to check before while has user already requested info)

The value was: <?php print $row["result"]; ?>

Remember to check $_POST["eventname"] with htmlspecialchars before inserting it to query.

answered Sep 26, 2011 at 12:29

Olli

7526 silver badges20 bronze badges

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

Comments

Simone · Accepted Answer · 2011-09-26 12:27:02Z

0

1) Give a name to your <select>, i.e. <select name='event'>.

2) Redirect your form to the display page (and set method POST): <form method='POST' action='display.php'>

3) just display the selected value: <?php echo $_POST['event']; ?>

If you want to use the same page, give a name to your submit button and then do this:

<?php
   if (isset($_POST['submit']))
      echo $_POST['event'];
?>

Hope it helps.

answered Sep 26, 2011 at 12:27

Simone

21.6k15 gold badges84 silver badges112 bronze badges

2 Comments

SebastianOpperman Over a year ago

So i can post a value to the same page it came from. Then the page just reloads and i pull the value from the post?

Olli Over a year ago

But remember to use htmlspecialchars before printing anything. Otherwise there is risk of XSS attack

Collectives™ on Stack Overflow

PHP MySQL Dropdown box

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