First, please excuse my english as we are a french web agency :-)
I need you to write me a little script that will pick datas in a mysqltable and display them in a input text using Typeahead or similar.
Other informations :
Datas from 2 tables will be needed.
The call must be done with the "remote" (cf. Github typeahead)
The display must be like "Multiple Datasets" (cf. Github typeahead)
I need to get both the full name and the ID specified by the JSON on the form submit
Making a clic on a proposition will go to a new url
My database (i give you the queries) :
SELECT * FROM country WHERE name LIKE '%$_GET['QUERY']%' (return NAME and ID)
SELECT * FROM city WHERE name LIKE '%$_GET['QUERY']%' (return NAME and ID)
Are expected :
An index.php file with the form
A ajax.php file to load and return the data in Json
In case of questions or more detaisl feel free to contact !