Peruttu

google map, php, database combination

Bid on this project ONLY if you have created a dynamic google map with php, reading lat/lon from a database table.

We have a dynamically generated map with over 120 locations.

The map renders slowly because we are displaying all 120 markers.

I require someone with experience to create the following on a google map:

Stage 1:

Show map of North America, and only states where there are locations need to be highlighted.

when user click on a state zoom into the closest zoom that will accommodate ALL locations within that state. the states with locations must be displayed visibly different to states without locations.

Stage 2:

user presses a state. zoom into the state into level where all locations can be seen.

Group together all markers which are close to each other, for this zoom level. The marker should display a number which is the number of locations this marker represents.

Stage 3

clicking on this marker will zoom into this area (closest zoom to show all locations under the marker in stage 2). some locations MAY show under one marker (repeat procedure from stage 2, other locations will show their own location. clicking on a marker that is showing a single location will show it's address (a field in the database) and a url link (<a href="">) with the id (also from a database).

table locations:

CREATE TABLE `location` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

`address` varchar(255) DEFAULT NULL,

`point_x` varchar(12) DEFAULT NULL,

`point_y` varchar(12) DEFAULT NULL,

`city_id` int(11) DEFAULT NULL,

`active` int(11) DEFAULT '1',

PRIMARY KEY (`id`)

CREATE TABLE `city` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

`state_id` int(11) DEFAULT NULL,

`groupid` int(11) DEFAULT '0',

PRIMARY KEY (`id`)

CREATE TABLE `states` (

`abbr` char(2) DEFAULT NULL,

`state_english` varchar(20) DEFAULT NULL,

`state_spanish` varchar(20) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '',

`stateID` int(11) NOT NULL AUTO_INCREMENT,

`active` int(11) DEFAULT '0',

PRIMARY KEY (`stateID`)

when showing states only show states that have locatins: you will need to do a select on states with join to city and location.

when show cities in a state only show cities which have locatins. you will need to select on cities with join on location.

only select locations which are active. location.active=1

All code to be written in PHP.

Successful bidder will be shown working example without the marker grouping which needs to be created.

another required feature is search by zip, with proximity in miles.

a box where user can enter a zip code in North America, and a select box with 10,20,50 miles, and a submit button.

when user enters the zip code and presses enter, then you need to present to user all location in the area of the zip, based on the distance. if no location near the requested zip code, zoom out until at least one location is found.

This project MUST be completed by Monday.

Only bid if you can deliver in the time frame and you have experience with google maps api.

Payment terms will be 50% when you show the code working on your hosted server. balance will be paid once we recieve the code and verify that it is working.

Sample data will be provided.

I expect you to ask necessary questions to clarify this project.

Good luck.

Taidot: PHP, SQL

Näytä lisää: gps google maps, submit google maps, php verify, php create table, one america, int map, google search php api, google search api php code, good questions to ask google, create table php, google map php join table, combination state map, google map php database combination, google maps php database, google maps sql zoom, google maps show address database, map locations database google maps, joomla google map showing location click tell, calculate distance miles google map php, google map locations database, maps google api, google api map, the php group, php level 3, php database

Tietoa työnantajasta:
( 52 arvostelua ) Cape Town, South Africa

Projektin tunnus: #466323

14 freelancers are bidding on average $195 for this job

VALUEONWEB

Please check pmb for demo

250 $ USD 2 päivässä
(207 arvostelua)
7.9
rockerstech

Please check reference work !

250 $ USD 4 päivässä
(77 arvostelua)
7.7
halezabux

Hi,please see PMB.Thanks.

250 $ USD 3 päivässä
(38 arvostelua)
6.1
sscreations

please check PMB.

250 $ USD 4 päivässä
(33 arvostelua)
6.0
goldenDragon

Please check PMB.

250 $ USD 3 päivässä
(12 arvostelua)
5.5
lnj2008

I am php,mysql,ajax,javascript,css,xml expert having 3 yrs. working experience on web development. I'm also a Google Map Api expert with database combination. Please check PM for more details. Regards, lnj.

200 $ USD 3 päivässä
(14 arvostelua)
5.0
uniquelo

Hi, I wish to complete that work for you, with my expertise over Google Map. Thanks

150 $ USD 5 päivässä
(8 arvostelua)
3.7
kraxor

Hi, I have experience with Google Maps API, and done a very similar task recently. Please check PM, I've provided an URL where you can see it.

218 $ USD 3 päivässä
(2 arvostelua)
3.7
darnsin

Hi Please check my reviws first. All are gained from google maps. But I want to tell your that your project requires much more budgets. Regrds. Darn.

30 $ USD 4 päivässä
(5 arvostelua)
2.5
Indiawisdom

Greets To you, We have completed 150+ Project on various freelance websites. We are very interested in this opportunity. Our work is such which exceeds your [url removed, login to view] are able to balance product development effor Lisää

160 $ USD 6 päivässä
(0 arvostelua)
0.0
nikhil1986webdev

i can do this work intime please see your PMB for more details

200 $ USD 3 päivässä
(0 arvostelua)
0.0
anishgeorge

hi, good day. plz check PM for the bid details. thank you.

200 $ USD 20 päivässä
(0 arvostelua)
0.0
ziscrip14

Hi, I could do this work. Please check my PM

135 $ USD 5 päivässä
(2 arvostelua)
0.0
linilogic

We can do the best security based mysql connection with lastest techniques in [url removed, login to view] you need to check our strength, we can give sample projects

180 $ USD 5 päivässä
(0 arvostelua)
0.0