Project: We're in need of a new template to dynamically link two form “select options” using php+MySQL+jquery with specific requirements noted below.
The form will have two option selects: “Makes” and “Models”
On launch of [login to view URL] it will run a MySQL query against “make_model” table with a hard coded ID to determine whether a record exists and behave as follows:
1.) if record with that ID does exist then create/display form populating BOTH option lists with *all* makes and *all* models but tag “selected” for make and model based on values from query.
2.) if no record exists then populate BOTH option lists with *all* makes and *all* models with both defaulting to “select make” and “select model” respectively.
3.) any change of the "makes" select will trigger a dynamic update to "models" select based on MySQL query.
Dynamic form requirement:
If user changes “make” select value then “model” select should dynamically (without page refresh) populate with new values from MySQL query to “models” table based on make ID selected.
Example starter-code and MySQL tables attached.
Must use jQuery version: [login to view URL] for dynamic option refresh.
Must use MySQL tables as-is
No access to our web/MySQL server will be provided, will need to build functioning proof of concept for review on own server.
Please include the word AWESOME in your reply to be considered.
Correction: with respect to #2, should read:
2.) if no record exists then populate BOTH option lists with *all* makes and *all* models [related to that make] with both defaulting to “select make” and “select model” respectively.
AWESOME, sorry I forgot this word at start, I'm from Mexico and I'm sure I can help you. I'm software engineer expert in web development since 10 years, please let me know, I can do this very cheap
17 freelancers are bidding on average $451 for this job
"AWESOME ." hi,nice to meet you. I am very good at php,mysql,jquery. Making modal is very easy for [login to view URL] if you hire me ,i will finish your job quickly and excellently. Best [login to view URL] you.