[GIS] Reference materials for learning Google API V3 with PHP and MySQL (tracking)

google mapsgoogle-maps-apiMySQLPHP

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.

Best Answer

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.

Related Question