PHP dynamic population of three drop down list

Before reading this please read the dynamic filling of second drop down list with selected value of first list. Here we will work with three drop down lists where the value of second list is populated based on the selection of first list and the values of third drop down list are populated based on the selection of second drop down list. Now after selecting option for second dropdown list the page reloads by taking the data of first and second dropdown list. This part is done with the help of JavaScript.


function reload3(form)
{
var val=form.cat.options[form.cat.options.selectedIndex].value; 
var val2=form.subcat.options[form.subcat.options.selectedIndex].value; 
self.location='dd3.php?cat=' + val + '&cat3=' + val2 ;
}

Using the same concept we can extend to add more dropdown list boxes.

Here the page is reloaded on selection of second drop down list and for this the table structure is changed with creation of third table.

Jquery PHP MySQL Learn Jquery based three interlinked dropdown list box using PHP, MySQL

If you are facing any problem in using this code, please post it in php discussion forum with your error messages, bugs etc ..

view demo for three dropdown list here

Subscribe to our YouTube Channel here

kiran	04-11-2013
i am using 3 dropdown menues, there are three table in my database,these tables are linked with foreign keys,but when i using just like your dd3.php, then 1st dropdown menu lost their value and get default value also when i getting the selected value in same page using this self.location="reg3.php?Result=" + nam; in javascript, and when i got notice error. please reply as soon as possible..

Aji Mohan Singh	10-02-2014
keep the drop down menu value javascript after submitting

Mark	19-11-2014
If I have more than 12 items in the subcategory2 table that link to one item in subcategory table, it will not list them all. Do you know why?

smo	19-11-2014
There is no reason why it should not list all 12 items ( if they are linked with category id )

mark	20-11-2014
yeah its weird. i had to truncate the table and reenter the values then it started working.

Mark	20-11-2014
how does this solution handle duplicate values. I want it to be able to display duplicates if possible.

smo	20-11-2014
At the database table the duplicate records are to be handled. You can use distinct command to get only unique records from table and display them as options.

Akhil Nasim	01-04-2017
code is working.But i need the same code but when i select the city then i need to display the names of the person that stays in the city.how can i do this ? and also the name of the person should not displayed in dropdown , instead of i need to display just on the screen.

Stacey	15-08-2014
I am looking for an easy php code

Dynamic populating three drop down list based on the selected value of first two list

Subscribe