Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
Thread: Dynamic dropdown list
12-27-2012, 03:10 PM #1
- Join Date
- Nov 2011
- Thanked 0 Times in 0 Posts
Dynamic dropdown list
i need a two dropdown lists where first (manufacturer) populates second (models) and when submit button is clicked it should lead to page of model, like this: index.php?p=view&m=shop&id=<certain_id>
all data is in one table and i can't change that: id, manufacturer, model, price, description
is there any example of something like this or someone knows how to do that?
12-27-2012, 04:20 PM #2
- Join Date
- Dec 2012
- Thanked 17 Times in 17 Posts
You have a couple options:
You can use Ajax to onChange(this.value) of the manufacturer select, query your database with "WHERE `manufacturer`= 'value.passed.to.js.function'". Then populating your second dropdown with the return results.
2) Preload every list.
This is the option I would use. If I'm a user on your site and I have to wait X seconds every time I want to see a new list of models, I'm not happy.
I would use PHP to query your database for (unfortunately) your entire table (unless you know you don't need a few rows) for the `id`, `manufacturer`, and `model` columns (unless you need more).
Originally Posted by 367Code:<form method="get" action="index.php?p=view&m=shop"> <select name="id"> <option value="mysql.id">mysql.model</option>
12-27-2012, 04:25 PM #3
Jquery can help you if you use the .change() trigger or .click()
Of course you need to know Jacascript to do that one.
If it is a particularly long Dropdown, you may combine it with Ajax and load it dynamically using a back-end PHP script that fetches Database data.