INTEGRASI PHP/MySQL DENGAN GOOGLE MAPS API

Intisari / Abstract

This article is intended who want to learn how to use Google Maps with a MySQL database. After completing this tutorial, you will have a Google Map based off a database of places.  An info window with name and address information will display above a marker when clicked. By using an XML file as an intermediary between our database and our Google Map, it makes for a faster initial page load, a more flexible map application, and easier debugging. You can independently verify the XML output from the database and the JavaScript parsing of the XML. And at any point, you could even decide to eliminate your database entirely and just run the map based on static XML files. In the PHP, first initialize a new XML document and create the "markers" parent node. Then connect to the database, execute a SELECT * (select all) query on the markers table, and iterate through the results. For each row in the table (each location), create a new XML node with the row attributes as XML attributes, and append it to the parent node. Then dump the XML to the screen.