Dependent Drop Down Menus

SecureCP Guest

Messages:: 226

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#1

Hey Guys, I'm assuming I'm in the write area since what I'm writing is in php, but may turn out to be javascript. Like I said, not positive but I find this is my best area to ask.

I'm writing a program that will pull a manufacturer of a vehicle in drop down number 1, and in drop down number 2 a model. If drop down number 1, for instance is porsche, I only want to show porsche models in drop down 2. I'm pulling all makes and models from db, with each in seperate db's but models linked to makes with the makes primary key.

I hope that makes sense. If anyone could even just kick me in the right direction, it would be fantastic.

SecureCP, May 3, 2010 IP

bartolay13 Active Member

Messages:: 735

Likes Received:: 14

Best Answers:: 1

Trophy Points:: 98

#2

i think your in the right category, you can use ajax for your concern.

bartolay13, May 4, 2010 IP

yoursanjay Member

Messages:: 42

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 41

#3

There is a example below of just same functionality but here I have used some different names in the drop down. Just try to get the logic.

1. File: dd.php

<?php
$dbservertype='mysql';
$servername='localhost';
// username and password to log onto db server
$dbusername='root';
$dbpassword='pwdadmin';
// name of database
$dbname='drop_down';

connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
//////// End of connecting to database ////////
?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Multiple drop down list box</title>
<SCRIPT language=JavaScript>
function reload(form)
{
var val=form.cat.options[form.cat.options.selectedIndex].value;
self.location='dd.php?cat=' + val ;
}

</script>
</head>

<body>
<?

@$cat=$_GET['cat']; // Use this line or below line if register_global is off
if(strlen($cat) > 0 and !is_numeric($cat)){ // to check if $cat is numeric data or not.
echo "Data Error";
exit;
}

///////// Getting the data from Mysql table for first list box//////////
$quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category");
///////////// End of query for first list box////////////

/////// for second drop down list we will check if category is selected else we will display all the subcategory/////
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory where cat_id=$cat order by subcategory");
}else{$quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory order by subcategory"); }
////////// end of query for second subcategory drop down list box ///////////////////////////

echo "<form method=post name=f1 action='dd-check.php'>";
/// Add your form processing page address to action in above line. Example action=dd-check.php////
////////// Starting of first drop downlist /////////
echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while($noticia2 = mysql_fetch_array($quer2)) {
if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";}
else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";}
}
echo "</select>";
////////////////// This will end the first drop down list ///////////

////////// Starting of second drop downlist /////////
echo "<select name='subcat'><option value=''>Select one</option>";
while($noticia = mysql_fetch_array($quer)) {
echo "<option value='$noticia[subcategory]'>$noticia[subcategory]</option>";
}
echo "</select>";
////////////////// This will end the second drop down list ///////////
//// Add your other form fields as needed here/////
echo "<input type=submit value=Submit>";
echo "</form>";
?>

</body>

</html>
Click to expand...

2. File: dd-check.php

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Demo Multiple drop down list box</title>
</head>

<body>
<?
$cat=$_POST['cat'];
$subcat=$_POST['subcat'];

echo "Value of \$cat = $cat <br>Value of \$subcat = $subcat ";

?>
</center>
</body>

</html>
Click to expand...

3. SQL:

CREATE TABLE category ( cat_id int(2) NOT NULL auto_increment, category varchar(25) NOT NULL default '', PRIMARY KEY (cat_id) ) TYPE=MyISAM;
# # Dumping data for table `category` #
INSERT INTO category VALUES (1, 'Fruits'); INSERT INTO category VALUES (2, 'Colors'); INSERT INTO category VALUES (3, 'Games'); INSERT INTO category VALUES (4, 'Vehicles');
# -------------------------------------------------------- # # Table structure for table `subcategory` #
CREATE TABLE subcategory ( cat_id int(2) NOT NULL default '0', subcategory varchar(25) NOT NULL default '' ) TYPE=MyISAM;
# # Dumping data for table `subcategory` #
INSERT INTO subcategory VALUES (1, 'Mango'); INSERT INTO subcategory VALUES (1, 'Banana'); INSERT INTO subcategory VALUES (1, 'Orange'); INSERT INTO subcategory VALUES (1, 'Apple'); INSERT INTO subcategory VALUES (2, 'Red'); INSERT INTO subcategory VALUES (2, 'Blue'); INSERT INTO subcategory VALUES (2, 'Green'); INSERT INTO subcategory VALUES (2, 'Yellow'); INSERT INTO subcategory VALUES (3, 'Cricket'); INSERT INTO subcategory VALUES (3, 'Football'); INSERT INTO subcategory VALUES (3, 'Baseball'); INSERT INTO subcategory VALUES (3, 'Tennis'); INSERT INTO subcategory VALUES (4, 'Cars'); INSERT INTO subcategory VALUES (4, 'Trucks'); INSERT INTO subcategory VALUES (4, 'Blkes'); INSERT INTO subcategory VALUES (4, 'Train');
Click to expand...

yoursanjay, May 4, 2010 IP

SecureCP Guest

Messages:: 226

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#4

Greatly, greatly appreciate this! Thanks so much. Sometimes this place is better than school.

SecureCP, May 4, 2010 IP

Log in or Sign up

Dependent Drop Down Menus

SecureCP Guest

bartolay13 Active Member

yoursanjay Member

SecureCP Guest

Useful Searches