Populate multiple dropdown from DB using PHP & AJAX

PHP
1

Hello I am working on a car portal and having a problem in populating multiple dropdown from database using PHP and AJAX. For example

I have 1st drop down of CAR MAKE which has 3 car companies names (Filled from databse)

  1. Toyota
  2. Honda
  3. Nissan

Then I have another dropdown which which will populate on selecting the above described CAR MAKE dropdown.

  1. Corolla (for Toyota)
  2. Civic (for Honda)
  3. Skyline (for Nissan)

(e.g If I select Toyota then automatically in the next dropdown corolla will appear and so on)

Then I have another dropdown by the name of PRICE which will have car price (e.g Min price 10,000 to Max 100,000,000)

And at last I have a search button which will take me to the search page of my selected values in the above 3 dropdowns and will show a list of cars from database.

Can any one provide a simple piece of code so that I can implement it in my project. For further assistance please visit http://www.drive.com.au/ and look at the basic search criteria for finding cars.

Please Help

2

I have google it alot but didnt get any answer… please help

3

Try Googling “chained select boxes”. If you’re using a specific JS library (jQuery, YUI) maybe add that into your search term.