Dynamic Linked Option Form

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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”

Flow:

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.

AJAX JavaScript jQuery / Prototype MySQL PHP

Project ID: #17181053

About the project

13 proposals Remote project Active 5 years ago

Awarded to:

kypergio

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

$250 USD in 0 days
(100 Reviews)
6.2

13 freelancers are bidding on average $449 for this job

Yknox

Dear, I am Smile Song, WEB developer in China. I've just read your job posting and I’m very interested. I'm a certificated freelancer with almost 1000 good reviews from clients. I have experienced knowledge in ever More

$555 USD in 10 days
(824 Reviews)
9.2
hiretechexperts

Hello, I have gone through the details provided , but need to clarify some things. So can you please press Chat button to initiate chat and send a message when you have some time to discuss. At present I am putting a More

$556 USD in 10 days
(56 Reviews)
7.8
shailendra041090

"AWESOME" Hi, there - My name is Shail. I have read your brief, checked your MySQL table and understand your requirement. I can develop the select option using PHP, MySQL, and jquery-1.11.1.min.js. I can im More

$250 USD in 2 days
(188 Reviews)
7.0
ITCristRo

hello,dear. It's my pleasure meeting you. I have read your requirements and I fully went through it. I am confident and I am sure that I am able to finish such project. Would you contact me for further discussing. Than More

$555 USD in 4 days
(12 Reviews)
6.2
sun0815

AWESOME I'm full stack developer including jQuery, php, mysql. So I'm sure can do your job in time. Regards.

$555 USD in 10 days
(46 Reviews)
6.2
souchadi159

AWESOME HI, i'm a professional full stack web developer with great experience in php/mysql/jQuery, i've read your description and i'm positive i can do this on my local server and provide you a test version today. More

$250 USD in 2 days
(17 Reviews)
3.7
enterpalindia

Hi Sir, I can do the creative work as you are in need for the Awesome new template to dynamically link two form “select options” using php+MySQL+jquery with specific requirements I am specialized developing webs More

$250 USD in 10 days
(12 Reviews)
2.3