DaniWeb Forum Index > Web Development > PHP

bringing data from mysql using select box

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2006

Posts: 6

Reputation: tzan2833 is an unknown quantity at this point

Solved Threads: 0

tzan2833

Offline

Newbie Poster

bringing data from mysql using select box

Sep 21st, 2006

Dear all

I need to build a search with 2 select boxes like;

Search

I need the second box to be populated according to the first. (The first one will be populated by me and not from the database with 5 or 6 values).

After the second drop down is populated I need after selecting a value data from the database to come up according to the selection while one cell’s values to be hyperlinked.

TITLE REFERENCE COUNTRY YEAR
Computer science Willey and Sons England 1997
Environment in the 21st Howard publications Germay 2001

After selecting one hyperlinked value the full study will come up in table format.

Many thanks in advance

Best Regards.

Last edited by tzan2833; Sep 21st, 2006 at 6:50 am.

•

Join Date: Sep 2006

Posts: 57

Reputation: GliderPilot is an unknown quantity at this point

Solved Threads: 2

GliderPilot GliderPilot is offline

Offline

Junior Poster in Training

Re: bringing data from mysql using select box

Sep 21st, 2006

In order to change something on the fly you would have to use Javascript.... However javascript cannot activate a PHP statement because it is a server side script and Javascript is client side.

You would have to use javascript to Submit the form when something is selected, and have the form reload the page with the selection. Than have PHP read the selection, and populate the second Select box from the database.

For example:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
$selected = $_POST['selected'];
 
if ($selected != "")
{
  // MySQL commands to retrieve the info depending on what was selected
}
 
?>
 
//Page Code Here
 
<form action="thispage.php" method="post" name="first_form">
 
<select name="first_select" onChange="document.first_form.submit();">
 
</form>
 
<form action="search.php" method="post" name="second_form">
 
<?php
 
//Use a for loop to go through the array of info recieved from the database and populate the second select field
 
?>
 
<input type="submit>
 
</form>
 
<?php
 
$selected = $_POST['selected'];
 
if ($selected != "")
{
  // MySQL commands to retrieve the info depending on what was selected
}
 
?>
 
//Page Code Here
 
<form action="thispage.php" method="post" name="first_form">
 
<select name="first_select" onChange="document.first_form.submit();">
 
</form>
 
<form action="search.php" method="post" name="second_form">
 
<?php
 
//Use a for loop to go through the array of info recieved from the database and populate the second select field
 
?>
 
<input type="submit>
 
</form>