Create XML source from mySQL to populate Google Maps
Posted on 2011-02-17
I am trying to populate a google map nested within my website page to display a number of different markers from an XML source which I have working.
What I want to do is create the XML source on the fly from a mySQL database without having to create the file everytime the page is called as the map will be on shown on different pages with different markers. I have tried to use XML Serialisation to create the XML but cannot find away to create and use the XML without creating the file.
Here is the xml source that is used to populate the map that I need to create;
<marker name="House 2" content="Blah Blah Blah" lat="47.608940" lng="-122.340141" type="house" />
<marker name="House 2" content="Blah Blah Blah" lat="47.613590" lng="-122.344391" type="house" />
I have the name, content, lat, lng and type fields in the database.