I am new to this Google API. Now i wanted to learn Google API with PHP and MySQL.

Actually i wanted to create an application that will track x,y coordinates coordinates on real time bases for android mobile. There will be many Android mobiles which will send data on real time bases and using php and mySQL i wanted to display it on Google map and refresh display and data after certain time interval.

So with respect to this tracking system part can any one suggest me any references material and web site.

  • I'd also be interested in a link or a short step-by-step to implement something like this. I imagine the MySQL Db tables might get a bit large after recording the coordinates for a good amount of time. What kind of Refresh rate are you look at? <30 seconds?
    – MLowry
    Commented Jul 18, 2012 at 12:53
  • 3
    Did you even try googling it? Top result developers.google.com/maps/articles/phpsqlajax_v3 You also need to start accepting answers to some of your questions or people will not help you Commented Jul 18, 2012 at 12:57
  • Refresh rate will have a drop-down list so user can select as per requirement from 1second to 5mins! Is it possible?
    – Pari
    Commented Jul 18, 2012 at 12:59
  • Yes i tried googling but no as useful result was found. Which also really confused me.
    – Pari
    Commented Jul 18, 2012 at 13:01
  • Read the Terms first (10c iii) Tracking developers.google.com/maps/terms 'you must not: enterprise dispatch, fleet management, business asset tracking or similar applications...
    – Mapperz
    Commented Jul 18, 2012 at 13:19

1 Answer 1


I did a work project like what you described with no experience in the Google Maps API, PHP or mySQL. I worked from this document from Google's developer's resources: From info window to Database.

For my project:

  • A user clicks on the map to drop a point
  • An info window pops up with an html form
  • The Lat and Long auto fill based on the location of the dropped point (auto-update if the user drags the point to a new location)
  • The user fills out the form, which is validated client side with jQuery
  • On form submit (jQuery ajax) the info is sent to a php processing page (php POST), the info window changes to 'Thank you for submitting your sighting'
  • Entry is added to mySQL from php page with INSERT statement

Make sure you do validation on your php processing page too to avoid SQL injection.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.