How To Feed Mysql Data Into Google Map

Modem day client server applications support lot of mobile device platform so real time GPS data will be collect most of the applications. Projection of collected data visualized on GIS applications has big trend these types of applications. In this tutorial I am going to teach you how to visualize data on google map using mysql databases. For a tutorial I am going to create online event publishing application as our sample. In this case people set of data containing some information about events and some of them have completed records and some of them have some data only. At first I would like to show you snap shot of what we are going to create Now let’s move forward. Here is our data base table structure Then we are going to insert few records to above table Then we are going to read records from mysql database and convert to xml format which is help to feed data into goggle map faster. Have you noted that we have some incomplete records so we have to do visualization as some kind of complete data. As a example if we don’t have lat/ lng values then we need to find out lat /lng using location address. Other hand if we don’t have address we should able to find out using lat/ lng values. This function is used to get lat /lng values from address This function is used to get address information using lat/ lng values Before we are going to read records from data base we need to consider address field. If we get data from google map , values might be contained some special characters. So we need to clean it out. Our input cleaning method look like follows Lets put all together and read data from databse and convert them to XML Above code will generate output like this Now we have all required information that we need visualizes on google map. Lets create map. Initializing map Then we are creating infowindow to show data on icon Next we move to load from our xml out put file