Drop Down Menus - Codewalkers

Codewalkers Forums Sponsor:

AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!

March 29th, 2004, 12:24 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Drop Down Menus

Ok I have this code based on the Codewalkers tutorial:

php Code:

Original - php Code

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<?PHP
$link = mysql_connect("", "", ""); 
mysql_select_db("", $link); 
?>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin

team = new Array(
new Array(
new Array("Ryan Bleam"),
new Array("Martin Rucinsky", 34802389),
new Array("Jeff Hackett", 39823498),
new Array("Sheldon Sourray", 87587343),
new Array("Richard Zednik", 68798735),
new Array("Brian Savage", 98098509),
new Array("Stephane Robidas", 49490583),
new Array("Patrice Brisebois", 32898334),
new Array("Oleg Petrov", 92340934),
new Array("Chad Kilger", 34923409),
new Array("Benoit Brunet", 59384093),
new Array("Jan Bulis", 83948023),
new Array("Patrick Traverse", 41239812),
new Array("Jose Theodore", 98402398),
new Array("Craig Darby", 82393434),
new Array("Patric Poulin", 34290348),
new Array("Karl Dykhuis", 89092834)
),
new Array(
new Array("Mario Lemieux", 23840238),
new Array("Jaromir Jagr", 92390484),
new Array("Robert Lang", 29048203),
new Array("Alexei Kovalev", 94098230),
new Array("Jean-Sebastien Aubin", 39234923),
new Array("Kevin Stevens", 29345423)
),
null,
new Array(
new Array("Alexei Yashin", 20394802),
new Array("Daniel Alfredson", 34982039),
new Array("Marian Hossa", 92348902),
new Array("Patrick Lalime", 98203894),
new Array("Radek Bonk", 98234902)
)
);
function fillSelectFromArray(selectCtrl, itemArray, goodPrompt, badPrompt, defaultItem) {
var i, j;
var prompt;
// empty existing items
for (i = selectCtrl.options.length; i >= 0; i--) {
selectCtrl.options[i] = null; 
}
prompt = (itemArray != null) ? goodPrompt : badPrompt;
if (prompt == null) {
j = 0;
}
else {
selectCtrl.options[0] = new Option(prompt);
j = 1;
}
if (itemArray != null) {
// add new items
for (i = 0; i < itemArray.length; i++) {
selectCtrl.options[j] = new Option(itemArray[i][0]);
if (itemArray[i][1] != null) {
selectCtrl.options[j].value = itemArray[i][1]; 
}
j++;
}
// select first item (prompt) for sub list
selectCtrl.options[0].selected = true;
   }
}
//  End -->
</script>

</head>

<body>
<?
$query1 = "SELECT * FROM master Limit 0 , 1";
$result1 = mysql_query($query1) or die('aa');

echo "<FORM NAME="main">";
echo "<SELECT NAME="Make" onChange="fillSelectFromArray(this.form.Team, ((this.selectedIndex == -1) ? null : team[this.selectedIndex-1]));">";
if (mysql_num_rows($result1) > 0) {
for ($i = 0; $i<mysql_num_fields($result1); $i++) {
    echo "<option value='arr".mysql_field_name($result1, $i)."'>".mysql_field_name($result1, $i)."</option>";
	}
	}
echo "</SELECT>";
?>
<BR>
<SELECT NAME="Team" SIZE="5">
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
</SELECT>
</FORM>

</body>
</html>

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<?PHP
$link = mysql_connect("", "", ""); 
mysql_select_db("", $link); 
?>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE="JavaScript">
<!-- Original:  Jerome Caron (jerome.caron@globetrotter.net) -->
 
<!-- This script and many more are available free online at -->
<!-- The JavaScript Source!! http://javascript.internet.com -->
 
<!-- Begin
 
team = new Array(
new Array(
new Array("Ryan Bleam"),
new Array("Martin Rucinsky", 34802389),
new Array("Jeff Hackett", 39823498),
new Array("Sheldon Sourray", 87587343),
new Array("Richard Zednik", 68798735),
new Array("Brian Savage", 98098509),
new Array("Stephane Robidas", 49490583),
new Array("Patrice Brisebois", 32898334),
new Array("Oleg Petrov", 92340934),
new Array("Chad Kilger", 34923409),
new Array("Benoit Brunet", 59384093),
new Array("Jan Bulis", 83948023),
new Array("Patrick Traverse", 41239812),
new Array("Jose Theodore", 98402398),
new Array("Craig Darby", 82393434),
new Array("Patric Poulin", 34290348),
new Array("Karl Dykhuis", 89092834)
),
new Array(
new Array("Mario Lemieux", 23840238),
new Array("Jaromir Jagr", 92390484),
new Array("Robert Lang", 29048203),
new Array("Alexei Kovalev", 94098230),
new Array("Jean-Sebastien Aubin", 39234923),
new Array("Kevin Stevens", 29345423)
),
null,
new Array(
new Array("Alexei Yashin", 20394802),
new Array("Daniel Alfredson", 34982039),
new Array("Marian Hossa", 92348902),
new Array("Patrick Lalime", 98203894),
new Array("Radek Bonk", 98234902)
)
);
function fillSelectFromArray(selectCtrl, itemArray, goodPrompt, badPrompt, defaultItem) {
var i, j;
var prompt;
// empty existing items
for (i = selectCtrl.options.length; i >= 0; i--) {
selectCtrl.options[i] = null; 
}
prompt = (itemArray != null) ? goodPrompt : badPrompt;
if (prompt == null) {
j = 0;
}
else {
selectCtrl.options[0] = new Option(prompt);
j = 1;
}
if (itemArray != null) {
// add new items
for (i = 0; i < itemArray.length; i++) {
selectCtrl.options[j] = new Option(itemArray[i][0]);
if (itemArray[i][1] != null) {
selectCtrl.options[j].value = itemArray[i][1]; 
}
j++;
}
// select first item (prompt) for sub list
selectCtrl.options[0].selected = true;
   }
}
//  End -->
</script>
 
</head>
 
<body>
<?
$query1 = "SELECT * FROM master Limit 0 , 1";
$result1 = mysql_query($query1) or die('aa');
 
echo "<FORM NAME="main">";
echo "<SELECT NAME="Make" onChange="fillSelectFromArray(this.form.Team, ((this.selectedIndex == -1) ? null : team[this.selectedIndex-1]));">";
if (mysql_num_rows($result1) > 0) {
for ($i = 0; $i<mysql_num_fields($result1); $i++) {
    echo "<option value='arr".mysql_field_name($result1, $i)."'>".mysql_field_name($result1, $i)."</option>";
    }
    }
echo "</SELECT>";
?>
<BR>
<SELECT NAME="Team" SIZE="5">
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
<OPTION>                                  </OPTION>
</SELECT>
</FORM>
 
</body>
</html>

At the top where it says new Array, how do I populate those arrays using PHP from data that is in my database. So for example whenever a field name is selected from the first drop down list I want it to list all of the values for that field in the next box. Hope someone can PLEASE help me out....

March 29th, 2004, 12:30 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Drop Down Menus

Also I want to be able to submit the form to be processed as well....PLEASE Help I'm begging, I can't figure this out at all

March 29th, 2004, 12:52 AM

Nicky

Contributing User

Join Date: Apr 2007

Location: Neverland

Posts: 606

Time spent in forums: 1 h 3 m 26 sec
Reputation Power: 2

RE: Drop Down Menus

Check out this FAQ
http://codewalkers.com/faq/12/33.html

March 29th, 2004, 12:58 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Drop Down Menus

That is the tutorial I used to get the first part to work, I just can't seem to figure out how to popuate the array based on which field name was selected. Right now it works and based on certain selections it displays the names that are in the array at the top...

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: