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?
thank you :)
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).
<form method="get" action="index.php?p=view&m=shop">
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.