Use of mySQL/PHP/JavaScript to plot a list of GPS coordinates

gps_SQR

http://mindbodymetrics.com/demo_map/

This link demonstrates the mapping a of list of addresses loaded into a mySQL database. A connection is established to the database and the queried list of addresses is pushed on to a client computer. Modifying the GPS coordinates in the mySQL database would alter the pins on this map; InfoWindow information can be modified using the database as well.

Note: Only a few locations have pictures attached to the Infowindows; the others could be given pictures as well and it would be simple to do so.

Future implementations:

-Creating alternative marker icons (by adjusting the img source for markers)

-Using multiple mySQL databases on one map (high cluster and low cluster)

-More InfoWindow columnar data; Images, Descriptions, …

 

Technologies used: Google Maps API, mySQL, PHP, Javascript, HTML

Leave a Reply

Your email address will not be published.