Php/mysql/js script
Budget: $30 – $250 AUD
Hi guys,
I need a php/mysql/gmaps script which will do the follow:
One page with 1 text input and 1 select list input
1 mysql db with 2 tables
1st mysql table will have 2 fields
Id(int primary key), name(varchar)
2nd table ill have 3 fields
id(int primary key), name(varchar 200), id_first_table(int)
Why I need this?
When we organize a daily tour we make meeting points where we meet the travelers.
In the first table I will save the names of all hotels in our area
In the second table I will save all our tour meeting points in our area as I will connect the hotels will the meeting points through the 3rd field (id_first_table).
Exampe:
Table 1
id name
1 Name1
2 Name2
3 Name3
Table2
id name id_first_table
1 Name1 2 (which is Name2 from the first table)
2 Name2 2 (which is Name2 from the first table)
3 Name3 1 (which is Name1 from the first table)
And so on.
What the php page should do?
The text input will be where I will input the hotel name.
When I start typing in the text input, I should get suggestion from the names in Table 1 (Field "name").
It is like when you search in google let say something and you start typing it, you get a list with suggested words(phrases)
Example:
I start taping let say "Na" and list with all table 1 (field "name") records containing "Na" will popup.
When I finish typing the name of the hotel in the text input, in the select input the meeting point should get selected.
Last thing:
Next to selectbox input will be an icon "flag" let say.
When I click it after the meeting point and the hotel are selected js need to open google map and draw the route between the hotel and the meeting point.
Thats it
I hope you understand what I mean. If no just ask and I will try to explain it in different way.
The budget is $50. If you can make it for less I will appreciate it it because we are startup and every penny has a value at the moment :) :)
Thank you
I need a php/mysql/gmaps script which will do the follow:
One page with 1 text input and 1 select list input
1 mysql db with 2 tables
1st mysql table will have 2 fields
Id(int primary key), name(varchar)
2nd table ill have 3 fields
id(int primary key), name(varchar 200), id_first_table(int)
Why I need this?
When we organize a daily tour we make meeting points where we meet the travelers.
In the first table I will save the names of all hotels in our area
In the second table I will save all our tour meeting points in our area as I will connect the hotels will the meeting points through the 3rd field (id_first_table).
Exampe:
Table 1
id name
1 Name1
2 Name2
3 Name3
Table2
id name id_first_table
1 Name1 2 (which is Name2 from the first table)
2 Name2 2 (which is Name2 from the first table)
3 Name3 1 (which is Name1 from the first table)
And so on.
What the php page should do?
The text input will be where I will input the hotel name.
When I start typing in the text input, I should get suggestion from the names in Table 1 (Field "name").
It is like when you search in google let say something and you start typing it, you get a list with suggested words(phrases)
Example:
I start taping let say "Na" and list with all table 1 (field "name") records containing "Na" will popup.
When I finish typing the name of the hotel in the text input, in the select input the meeting point should get selected.
Last thing:
Next to selectbox input will be an icon "flag" let say.
When I click it after the meeting point and the hotel are selected js need to open google map and draw the route between the hotel and the meeting point.
Thats it
I hope you understand what I mean. If no just ask and I will try to explain it in different way.
The budget is $50. If you can make it for less I will appreciate it it because we are startup and every penny has a value at the moment :) :)
Thank you