Hi everyone,
I am trying to make three dynamic drop down lists. When I say dynamic I mean when I choose a value from the first one, the second one changes options and when I choose a value from the second one then the third one changes options. But at the end I want the to keep the selected values because I will submit them. For example the first list may be Country, the second one may be City and the third one Postal Code. So once I choose country I want the cities in that country to be visible and again once I choose city I want postal code to be visible, buy I do not want to loose my selections every time because I will submit them at the end. I was able to make it up to two drop down menus and it works perfect, but once I add the third everything is destroyed.
Take a look at my code for the first two menus and if you can help me I will really appreciate it -
<!doctype html public "-//w3c//dtd html 3.2//en">
-
-
<html>
-
<head>
-
<title>Multiple drop down list box from plus2net</title>
-
<SCRIPT language=JavaScript>
-
function reload(form)
-
{
-
var val=form.cat.options[form.cat.options.selectedIndex].value;
-
self.location='dropmenutest.php?cat=' + val ;
-
}
-
</script>
-
</head>
-
-
<body>
-
<?php
-
require_once("../../dbconnection.php");
-
?>
-
-
<?php
-
@$cat=$_GET['cat'];
-
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 PARK FROM PARK");
-
-
// 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){
-
$test="SELECT DISTINCT Room FROM Rooms where AREA = '";
-
$test = $test . $cat . "'";
-
$quer=mysql_query("$test");
-
}else{$quer=mysql_query("SELECT DISTINCT Room FROM Rooms"); }
-
-
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['PARK']==@$cat){echo "<option selected value='$noticia2[PARK]'>$noticia2[PARK]</option>"."<BR>";}
-
else{echo "<option value='$noticia2[PARK]'>$noticia2[PARK]</option>";}
-
}
-
echo "</select>";
-
-
//Starting of second drop downlist
-
echo "<select name='subcat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
-
while($noticia = mysql_fetch_array($quer)) {
-
echo "<option value='$noticia[Room]'>$noticia[Room]</option>";
-
}
-
echo "</select>";
-
-
//Starting of the third drop downlist
-
echo "<select name='subcat'><option value=''>Select one</option>";
-
while($noticia = mysql_fetch_array($quer)) {
-
echo "<option value='$noticia[Room]'>$noticia[Room]</option>";
-
}
-
echo "</select>";
-
-
-
//Add your other form fields as needed here
-
echo "<input type=submit value=Submit>";
-
echo "</form>";
-
?>
-
-
<?php
-
require("../../disconnect.php")
-
?>
-
</body>
-
</html>
-
4  6472 
If you dont understand AJAX
you can follow this example
In your source file you can simply create the SELECT drop down list. and in ajax reply you can add the return in the proper value as HTML.
You are not using Ajax in your code example.
If you want to use your existing code; which would be simpler than Ajax, you'll need to send the value(s) of all of the DropDown (Combobox) elements with each reload. -
This:
-
# var val=form.cat.options[form.cat.options.selectedIndex].value;
-
# self.location='dropmenutest.php?cat=' + val ;
-
-
Should change to something like this:
-
-
# populate vars
-
val1=form.cat.options[form.cat.options.selectedIndex].value;
-
val2=form.subcat1.options[form.subcat1.options.selectedIndex].value;
-
val3=form.subcat2.options[form.subcat2.options.selectedIndex].value;
-
-
self.location='dropmenutest.php?cat=' + val1 + '&subcat1=' + val2 + '&subcat2=' + val3 ;
-
-
Then your PHP code should test for the existence and validity of all of the arguments and variably perform the sql queries.
i.e.
1- if cat1 is invalid; reset all dropdowns
2- if cat1 is valid and subcat1 and subcat2 are both invalid; keep the value of cat1, perform sql on cat1, and populate subcat1, subcat2's value is reset
3- if cat1 is valid and subcat1 is valid; keep the values of cat1 and subcat1, perform sql on subcat1, and populate subcat2
4- if cat1, subcat1, and subcat2 are valid; complete whatever logic is appropriate.
===> it is only static as you can get ideas .... how to work it.....
if you wanna change the values from database then make it with php and mysql
Bharat Parmar(Bharat38 3)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: pmud |
last post by:
Hi,
I have 2 drop down lists on an asp.Net page. The 1st contains alphabets.
When the user selects an alphabet frm the first list, the second drop down
list should be populated with names from the sql database, which begin with
that alphabet.
For this I used an sql data Adapter & created a data set. The user's
selection in 1st list is passed as parameter to the sql statement.
|
by: mart2006 |
last post by:
I've created a dynamic drop down menu that populates itself with data from a MySQL table. What I would like to do is create a non dynamic drop down menu that alters what is shown in the dynamic menu.
For example, the first menu has three cities London, Paris, New York. If I choose London it populates the second menu with people from London.
Here is the code I have for my dynamic menu
<td valign=top><strong>Name:</strong></td>
<td>...
|
by: Prof |
last post by:
Hi,
I have the requirement of autoupdating the drop down lists , when a
selectin is done in another drop down box. I dont have a server through
which i can make it dynamic. I have to hard code it in the html. Can
someone suggest anything.
Prof
|
by: penny111 |
last post by:
Hi there,
For my application, i need to have 3 drop down lists
1. drop down list of folder names
2. drop down list of documents in the folder selected
3. drop down list of instances of the document selected
(my application uses the BusinessObjects Java Web Services SDK)
The 2nd list is dependent on the 1st, while the 3rd list is dependent on the 2nd. In other words, this is what i want my application to do
-select a folder from the...
|
by: icepoint |
last post by:
Hey everyone,
Can anyone tell me how to make dynamice drop down lists for country and states? I have the models for country and states build and have the country drop down list worked, so how can I make the state list changes corressponding to the change of the country list? etc. Canada -> only canada provinces... Thanks
| | |
by: rpeterson84 |
last post by:
Hello:
I was hoping to gain some insight, a point in the right direction if you will...
We use an .asp web page to select from a couple of dynamic drop down menus then enter a number, and press go to query the sql db.
Is it possible to use a javascript to open the web page, and the select the options I want from a dynamic dropdown menus?
Also selecting the option I want from the available checkboxes,
then "clicking" go.
|
by: amcoldspy |
last post by:
Hi,
am trying to create dynamic drop down boxes..
there are 3 drop down boxes.
The second drop down box elements are to be update based on the selection made in the first drop down box (selecting an element on the first drop down box calls a getData.jsp file which returns the result.)
the third drop down box elements are to be update based on the selection made in the second drop down box (selecting an element on the second drop down...
|
by: mart2006 |
last post by:
Hi,
I'm fairly new to PHP and I've created a dynamic drop down menu that populates itself with data from a MySQL table. What I would like to do is create a non dynamic drop down menu that alters what is shown in the dynamic menu.
For example, the first menu has three cities London, Paris, New York. If I choose London it populates the second menu with people from London.
Here is the code I have for my dynamic menu
<td...
|
by: Bar2aYunie |
last post by:
Hello,
I just found this great forum and I'm really looking for some help! I've been trying to create a dynamic drop down select list script with descriptions. And I have been working on this script for three months already....but now I'm totally stuck!!
Lemme explain what I need first.
I have 19 products that each have it's own details: size, colors, materials and fnish. Therefore I need 5 select lists. The first one will list all of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
