The sample below shows the entire code you need to create this map. This allows the fields to store 6 digits after the decimal, plus up to 4 digits before the decimal.You can interact with the My SQL datbase through the php My Amin interface.The map can use the XML file to retrieve the marker data through asynchronous Java Script calls.Using an XML file as an intermediary between your database and your Google map allows for faster initial page load, and a more flexible map application.It makes debugging easier as you can independently verify the XML output from the database, and the Java Script parsing of the XML.You can also run the map entirely based on static XML files only, and not use the My SQL database.The map in this tutorial displays two kinds of markers to differentiate between the location of restaurants and bars respectively.A database in My SQL stores information about the individual marker locations like the type of place (whether it's a restaurant or a bar), its name, address and geographic coordinates.
Below is the marker data for the map in this tutorial, in the format. Fish,"580 Darling Street, Rozelle, NSW",-33.861034,151.171936,restaurant 2, Young Henrys,"76 Wilford Street, Newtown, NSW",-33.898113,151.174469,bar 3, Hunter Gatherer,"Greenwood Plaza, 36 Blue St, North Sydney NSW ",-33.840282,151.207474,bar 4, The Potting Shed,"7A, 2 Huntley Street, Alexandria, NSW",-33.910751,151.194168,bar 5, Nomad,"16 Foster Street, Surry Hills, NSW",-33.879917,151.210449,bar 6, Three Blue Ducks,"43 Macpherson Street, Bronte, NSW",-33.906357,151.263763,restaurant 7, Single Origin Roasters,"60-64 Reservoir Street, Surry Hills, NSW",-33.881123,151.209656,restaurant 8, Red Lantern,"60 Riley Street, Darlinghurst, NSW",-33.874737,151.215530,restaurant INSERT INTO `markers` (`id`, `name`, `address`, `lat`, `lng`, `type`) VALUES ('1', 'Love.If you have never used PHP to connect to a My SQL database, visit and read up on When using a public browser to access a database using PHP files, it's important to ensure that your database credentials are secure.You can do this by putting your database connection information in a separate PHP file to that of the main PHP code.This tutorial shows you how to display information from a My SQL database on a Google Map using the Maps Java Script API.It suits people with intermediate knowledge of My SQL, PHP and XML.
The map retrieves this information from the database, through an XML file that acts as an intermediary between the database and the map.