How To Feed Mysql Data Into Google Map – Free Source Code

Modem day shopper server functions assist lot of cellular system platform so actual time GPS information will probably be accumulate a lot of the functions. Projection of collected information visualized on GIS functions has huge development a lot of these functions. On this tutorial I’m going to show you tips on how to visualize information on google map utilizing mysql databases.
For a tutorial I’m going to create on-line occasion publishing utility as our pattern. On this case individuals set of knowledge containing some details about occasions and a few of them have accomplished data and a few of them have some information solely.
At first I want to present you snap shot of what we’re going to create

gmap - How To Feed Mysql Data Into Google Map - Free Source Code

Now let’s transfer ahead. Right here is our information base desk construction

<ol>
<li class="li1"><div class="de1">
<span class="kw1">CREATE</span> <span class="kw1">TABLE</span> <span class="kw1">IF</span> <span class="kw1">NOT</span> <span class="kw1">EXISTS</span> <span class="st0">`geo_location`</span> <span class="br0">(</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`id`</span> <span class="kw1">INT</span><span class="br0">(</span><span class="nu0">11</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span> <span class="kw1">AUTO_INCREMENT</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`event_title`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">50</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`location_address`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">150</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`location_city`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">75</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`location_state`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">75</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`zip_code`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">20</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`nation`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">50</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`lat`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">20</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`lang`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">20</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`location_discription`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">200</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`start_time`</span> datetime <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`end_time`</span> datetime <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`lcation_url`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">150</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="st0">`locaton_type`</span> <span class="kw1">VARCHAR</span><span class="br0">(</span><span class="nu0">50</span><span class="br0">)</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">PRIMARY</span> <span class="kw1">KEY</span> <span class="br0">(</span><span class="st0">`id`</span><span class="br0">)</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">)</span></div></li>
</ol>

<ol>

CREATE TABLE IF NOT EXISTS `geo_location` (

</div></li>

<li class="li1"><div class="de1"> `id` INT(11) NOT NULL AUTO_INCREMENT,

</div></li>

<li class="li1"><div class="de1"> `event_title` VARCHAR(50) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `location_address` VARCHAR(150) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `location_city` VARCHAR(75) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `location_state` VARCHAR(75) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `zip_code` VARCHAR(20) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `nation` VARCHAR(50) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `lat` VARCHAR(20) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `lang` VARCHAR(20) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `location_discription` VARCHAR(200) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `start_time` datetime NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `end_time` datetime NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `lcation_url` VARCHAR(150) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> `locaton_type` VARCHAR(50) NOT NULL,

</div></li>

<li class="li1"><div class="de1"> PRIMARY KEY (`id`)

</div></li>

</ol>

Then we’re going to insert few data to above desk

<ol>
<li class="li1"><div class="de1">
<span class="kw1">INSERT</span> <span class="kw1">INTO</span> <span class="st0">`geo_location`</span> <span class="br0">(</span><span class="st0">`id`</span><span class="sy0">,</span> <span class="st0">`event_title`</span><span class="sy0">,</span> <span class="st0">`location_address`</span><span class="sy0">,</span> <span class="st0">`location_city`</span><span class="sy0">,</span> <span class="st0">`location_state`</span><span class="sy0">,</span> <span class="st0">`zip_code`</span><span class="sy0">,</span> <span class="st0">`nation`</span><span class="sy0">,</span> <span class="st0">`lat`</span><span class="sy0">,</span> <span class="st0">`lang`</span><span class="sy0">,</span> <span class="st0">`location_discription`</span><span class="sy0">,</span> <span class="st0">`start_time`</span><span class="sy0">,</span> <span class="st0">`end_time`</span><span class="sy0">,</span> <span class="st0">`lcation_url`</span><span class="sy0">,</span> <span class="st0">`locaton_type`</span><span class="br0">)</span> <span class="kw1">VALUES</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">1</span><span class="sy0">,</span> <span class="st0">'Check Occasion One'</span><span class="sy0">,</span> <span class="st0">'140 Previous Kent Highway, London SE1, UK'</span><span class="sy0">,</span> <span class="st0">'check location'</span><span class="sy0">,</span> <span class="st0">'london'</span><span class="sy0">,</span> <span class="st0">'Nw1 w42'</span><span class="sy0">,</span> <span class="st0">'United Kindom'</span><span class="sy0">,</span> <span class="st0">'51.49164465653034'</span><span class="sy0">,</span> <span class="st0">'-0.0823974609375'</span><span class="sy0">,</span> <span class="st0">'Al marj Cinema middle check information '</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'http://www.geoshaper.com/Reupload/'</span><span class="sy0">,</span> <span class="st0">'restaurant'</span><span class="br0">)</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">2</span><span class="sy0">,</span> <span class="st0">'Check Occasion Two'</span><span class="sy0">,</span> <span class="st0">'16 Pine Coombe, Croydon, Larger London CR0 5HS, UK'</span><span class="sy0">,</span> <span class="st0">'check location two'</span><span class="sy0">,</span> <span class="st0">'london'</span><span class="sy0">,</span> <span class="st0">'Nw1 w42'</span><span class="sy0">,</span> <span class="st0">'United Kindom'</span><span class="sy0">,</span> <span class="st0">'51.36492148825955'</span><span class="sy0">,</span> <span class="st0">'-0.0439453125'</span><span class="sy0">,</span> <span class="st0">'Check information description two '</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'http://www.geoshaper.com/Reupload/'</span><span class="sy0">,</span> <span class="st0">'restaurant'</span><span class="br0">)</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">3</span><span class="sy0">,</span> <span class="st0">'Check even 3'</span><span class="sy0">,</span> <span class="st0">'Steinau 1, 8844 Einsiedeln, Switzerland'</span><span class="sy0">,</span> <span class="st0">'swiss check '</span><span class="sy0">,</span> <span class="st0">'Zurich zug'</span><span class="sy0">,</span> <span class="st0">'215466'</span><span class="sy0">,</span> <span class="st0">'Awitzerland'</span><span class="sy0">,</span> <span class="st0">'47.08508535995383'</span><span class="sy0">,</span> <span class="st0">'8.778076171875'</span><span class="sy0">,</span> <span class="st0">'Al marj Cinema middle check information '</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'www.geoshaper.com'</span><span class="sy0">,</span> <span class="st0">'restaurant'</span><span class="br0">)</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">4</span><span class="sy0">,</span> <span class="st0">'London tree'</span><span class="sy0">,</span> <span class="st0">'16 Choats Highway, Barking, Dagenham, Larger London RM9 6LF, UK'</span><span class="sy0">,</span> <span class="st0">'check location'</span><span class="sy0">,</span> <span class="st0">'london'</span><span class="sy0">,</span> <span class="st0">'Nw1 w42'</span><span class="sy0">,</span> <span class="st0">'United Kindom'</span><span class="sy0">,</span> <span class="st0">'51.52241608253253'</span><span class="sy0">,</span> <span class="st0">'0.1318359375'</span><span class="sy0">,</span> <span class="st0">'Al marj Cinema middle check information '</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'www.geoshaper.com'</span><span class="sy0">,</span> <span class="st0">'bar'</span><span class="br0">)</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">5</span><span class="sy0">,</span> <span class="st0">'Swiz occasion two'</span><span class="sy0">,</span> <span class="st0">'Alte Winterthurerstrasse 51A, 8304 Wallisellen, Switzerland'</span><span class="sy0">,</span> <span class="st0">'swiss check '</span><span class="sy0">,</span> <span class="st0">'london'</span><span class="sy0">,</span> <span class="st0">'215466'</span><span class="sy0">,</span> <span class="st0">'switzerland'</span><span class="sy0">,</span> <span class="st0">'47.416937456635445'</span><span class="sy0">,</span> <span class="st0">'8.59130859375'</span><span class="sy0">,</span> <span class="st0">'Al marj Cinema middle check information '</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'www.geoshaper.com'</span><span class="sy0">,</span> <span class="st0">'restaurant'</span><span class="br0">)</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">
<span class="br0">(</span><span class="nu0">6</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">'TQ3 3ST'</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">'51.95780738871554'</span><span class="sy0">,</span> <span class="st0">'-2.887207567691803'</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">'0000-00-00 00:00:00'</span><span class="sy0">,</span> <span class="st0">''</span><span class="sy0">,</span> <span class="st0">'restaurant'</span><span class="br0">)</span>;</div></li>
</ol>

<ol>

INSERT INTO `geo_location` (`id`, `event_title`, `location_address`, `location_city`, `location_state`, `zip_code`, `nation`, `lat`, `lang`, `location_discription`, `start_time`, `end_time`, `lcation_url`, `locaton_type`) VALUES

</div></li>

(1, 'Check Occasion One', '140 Previous Kent Highway, London SE1, UK', 'check location', 'london', 'Nw1 w42', 'United Kindom', '51.49164465653034', '-0.0823974609375', 'Al marj Cinema middle check information ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'http://www.geoshaper.com/Reupload/', 'restaurant'),

</div></li>

(2, 'Check Occasion Two', '16 Pine Coombe, Croydon, Larger London CR0 5HS, UK', 'check location two', 'london', 'Nw1 w42', 'United Kindom', '51.36492148825955', '-0.0439453125', 'Check information description two ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'http://www.geoshaper.com/Reupload/', 'restaurant'),

</div></li>

(3, 'Check even 3', 'Steinau 1, 8844 Einsiedeln, Switzerland', 'swiss check ', 'Zurich zug', '215466', 'Awitzerland', '47.08508535995383', '8.778076171875', 'Al marj Cinema middle check information ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'www.geoshaper.com', 'restaurant'),

</div></li>

(4, 'London tree', '16 Choats Highway, Barking, Dagenham, Larger London RM9 6LF, UK', 'check location', 'london', 'Nw1 w42', 'United Kindom', '51.52241608253253', '0.1318359375', 'Al marj Cinema middle check information ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'www.geoshaper.com', 'bar'),

</div></li>

(5, 'Swiz occasion two', 'Alte Winterthurerstrasse 51A, 8304 Wallisellen, Switzerland', 'swiss check ', 'london', '215466', 'switzerland', '47.416937456635445', '8.59130859375', 'Al marj Cinema middle check information ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'www.geoshaper.com', 'restaurant'),

</div></li>

(6, '', 'TQ3 3ST', '', '', '', '', '51.95780738871554', '-2.887207567691803', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'restaurant');</div></li>

</ol>

Then we’re going to learn data from mysql database and convert to xml format which is assist to feed information into goggle map quicker. Have you ever famous that now we have some incomplete data so now we have to do visualization as some type of full information. As a instance if we don’t have lat/ lng values then we have to discover out lat /lng utilizing location tackle. Different hand if we don’t have tackle we should always capable of finding out utilizing lat/ lng values.

This operate is used to get lat /lng values from tackle

<ol>
<li class="li1"><div class="de1">
<span class="kw2">operate</span> getLatLangbyAddress<span class="br0">(</span><span class="re0">$adress</span><span class="sy0">,</span><span class="re0">$location</span><span class="sy0">,</span><span class="re0">$zip</span><span class="br0">)</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">{</span></div></li>
<li class="li1"><div class="de1">    <span class="re0">$tackle</span> <span class="sy0">=</span> <span class="st_h">''</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">    <span class="re0">$compornent</span> <span class="sy0">=</span><span class="st_h">'elements=nation:.CH'</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">     <span class="kw1">if</span> <span class="br0">(</span><a href="http://www.php.net/isset" rel="nofollow"><span class="kw3">isset</span></a><span class="br0">(</span><span class="re0">$adress</span><span class="br0">)</span> <span class="sy0">&amp;&amp;</span> <span class="re0">$adress</span> <span class="sy0">!=</span><span class="st0">""</span> <span class="br0">)</span><span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">        <span class="re0">$tackle</span> <span class="sy0">=</span> <span class="re0">$adress</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1"> <span class="kw1">else</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">     <span class="kw1">if</span><span class="br0">(</span><a href="http://www.php.net/isset" rel="nofollow"><span class="kw3">isset</span></a><span class="br0">(</span><span class="re0">$location</span><span class="br0">)</span> <span class="sy0">&amp;&amp;</span> <span class="re0">$location</span> <span class="sy0">!=</span><span class="st0">""</span> <span class="br0">)</span><span class="br0"> $compornent =locality:'</span><span class="sy0">.</span><span class="re0">$location</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="br0"></span>
</div></li>
<li class="li1"><div class="de1"> <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">      <span class="kw1">if</span> <span class="br0">(</span><a href="http://www.php.net/isset" rel="nofollow"><span class="kw3">isset</span></a><span class="br0">(</span><span class="re0">$zip</span><span class="br0">)</span> <span class="sy0">&amp;&amp;</span> <span class="re0">$zip</span> <span class="sy0">!=</span><span class="st0">""</span> <span class="br0">)</span><span class="br0">$compornent =postal_code:'</span><span class="sy0">.</span><span class="re0">$zip</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="br0"></span>
</div></li>
<li class="li1"><div class="de1">
<span class="re0">$a</span> <span class="sy0">=</span> <a href="http://www.php.net/urlencode" rel="nofollow"><span class="kw3">urlencode</span></a><span class="br0">(</span><span class="re0">$tackle</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">
<span class="re0">$b</span> <span class="sy0">=</span> <a href="http://www.php.net/urlencode" rel="nofollow"><span class="kw3">urlencode</span></a><span class="br0">(</span><span class="re0">$compornent</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$geocodeURL</span> <span class="sy0">=</span> </div></li>
<li class="li1"><div class="de1">   <span class="st0">"http://maps.googleapis.com/maps/api/geocode/json?tackle=<span class="es4">$a</span>&amp;<span class="es4">$b</span>&amp;sensor=false"</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$ch</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_init" rel="nofollow"><span class="kw3">curl_init</span></a><span class="br0">(</span><span class="re0">$geocodeURL</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <a href="http://www.php.net/curl_setopt" rel="nofollow"><span class="kw3">curl_setopt</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="sy0">,</span> CURLOPT_RETURNTRANSFER<span class="sy0">,</span> <span class="nu0">1</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$end result</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_exec" rel="nofollow"><span class="kw3">curl_exec</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$httpCode</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_getinfo" rel="nofollow"><span class="kw3">curl_getinfo</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="sy0">,</span> CURLINFO_HTTP_CODE<span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <a href="http://www.php.net/curl_close" rel="nofollow"><span class="kw3">curl_close</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="kw1">if</span> <span class="br0">(</span><span class="re0">$httpCode</span> <span class="sy0">==</span> <span class="nu0">200</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">      <span class="re0">$geocode</span> <span class="sy0">=</span> <a href="http://www.php.net/json_decode" rel="nofollow"><span class="kw3">json_decode</span></a><span class="br0">(</span><span class="re0">$end result</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="kw1">return</span> <span class="re0">$geocode</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">   <span class="br0">}</span> <span class="kw1">else</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">     <span class="re0">$geo_status</span> <span class="sy0">=</span> <span class="st0">"HTTP_FAIL_<span class="es4">$httpCode</span>"</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="br0">}</span> </div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
</ol>

<ol>

operate getLatLangbyAddress($adress,$location,$zip)

</div></li>

<li class="li1"><div class="de1"> $tackle = '';

</div></li>

<li class="li1"><div class="de1"> $compornent ='elements=nation:.CH';

</div></li>

<li class="li1"><div class="de1"> if (<a href="http://www.php.net/isset" rel="nofollow">isset</a>($adress) && $adress !="" ){

</div></li>

<li class="li1"><div class="de1"> $tackle = $adress;

</div></li>

<li class="li1"><div class="de1"> }

</div></li>

<li class="li1"><div class="de1"> else {

</div></li>

<li class="li1"><div class="de1"> if(<a href="http://www.php.net/isset" rel="nofollow">isset</a>($location) && $location !="" ) $compornent =locality:'.$location;

</div></li>

</div></li>

<li class="li1"><div class="de1"> }

</div></li>

<li class="li1"><div class="de1"> if (<a href="http://www.php.net/isset" rel="nofollow">isset</a>($zip) && $zip !="" )$compornent =postal_code:'.$zip;

</div></li>

</div></li>

$a = <a href="http://www.php.net/urlencode" rel="nofollow">urlencode</a>($tackle);

</div></li>

$b = <a href="http://www.php.net/urlencode" rel="nofollow">urlencode</a>($compornent);

</div></li>

<li class="li1"><div class="de1"> $geocodeURL = </div></li>

<li class="li1"><div class="de1"> "http://maps.googleapis.com/maps/api/geocode/json?tackle=$a&$b&sensor=false";

</div></li>

<li class="li1"><div class="de1"> $ch = <a href="http://www.php.net/curl_init" rel="nofollow">curl_init</a>($geocodeURL);

</div></li>

<li class="li1"><div class="de1"> <a href="http://www.php.net/curl_setopt" rel="nofollow">curl_setopt</a>($ch, CURLOPT_RETURNTRANSFER, 1);

</div></li>

<li class="li1"><div class="de1"> $end result = <a href="http://www.php.net/curl_exec" rel="nofollow">curl_exec</a>($ch);

</div></li>

<li class="li1"><div class="de1"> $httpCode = <a href="http://www.php.net/curl_getinfo" rel="nofollow">curl_getinfo</a>($ch, CURLINFO_HTTP_CODE);

</div></li>

<li class="li1"><div class="de1"> <a href="http://www.php.net/curl_close" rel="nofollow">curl_close</a>($ch);

</div></li>

<li class="li1"><div class="de1"> if ($httpCode == 200) {

</div></li>

<li class="li1"><div class="de1"> $geocode = <a href="http://www.php.net/json_decode" rel="nofollow">json_decode</a>($end result);

</div></li>

<li class="li1"><div class="de1"> return $geocode; </div></li>

<li class="li1"><div class="de1"> } else {

</div></li>

<li class="li1"><div class="de1"> $geo_status = "HTTP_FAIL_$httpCode";

</div></li>

</ol>

This operate is used to get tackle info utilizing lat/ lng values

<ol>
<li class="li1"><div class="de1">
<span class="kw2">operate</span> getAdressbyLatLang<span class="br0">(</span><span class="re0">$lat</span><span class="sy0">,</span><span class="re0">$lang</span><span class="br0">)</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">{</span></div></li>
<li class="li1"><div class="de1">    <span class="re0">$tackle</span> <span class="sy0">=</span> <span class="st_h">''</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$tackle</span> <span class="sy0">=</span> <span class="re0">$lat</span><span class="sy0">.</span><span class="st0">","</span><span class="sy0">.</span><span class="re0">$lang</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">
<span class="re0">$a</span> <span class="sy0">=</span> <a href="http://www.php.net/urlencode" rel="nofollow"><span class="kw3">urlencode</span></a><span class="br0">(</span><span class="re0">$tackle</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$geocodeURL</span> <span class="sy0">=</span> </div></li>
<li class="li1"><div class="de1">   <span class="st0">"http://maps.googleapis.com/maps/api/geocode/json?latlng=<span class="es4">$a</span>&amp;sensor=false"</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$ch</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_init" rel="nofollow"><span class="kw3">curl_init</span></a><span class="br0">(</span><span class="re0">$geocodeURL</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <a href="http://www.php.net/curl_setopt" rel="nofollow"><span class="kw3">curl_setopt</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="sy0">,</span> CURLOPT_RETURNTRANSFER<span class="sy0">,</span> <span class="nu0">1</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$end result</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_exec" rel="nofollow"><span class="kw3">curl_exec</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="re0">$httpCode</span> <span class="sy0">=</span> <a href="http://www.php.net/curl_getinfo" rel="nofollow"><span class="kw3">curl_getinfo</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="sy0">,</span> CURLINFO_HTTP_CODE<span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <a href="http://www.php.net/curl_close" rel="nofollow"><span class="kw3">curl_close</span></a><span class="br0">(</span><span class="re0">$ch</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="kw1">if</span> <span class="br0">(</span><span class="re0">$httpCode</span> <span class="sy0">==</span> <span class="nu0">200</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">      <span class="re0">$geocode</span> <span class="sy0">=</span> <a href="http://www.php.net/json_decode" rel="nofollow"><span class="kw3">json_decode</span></a><span class="br0">(</span><span class="re0">$end result</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="kw1">return</span> <span class="re0">$geocode</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="br0">}</span> <span class="kw1">else</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">     <span class="re0">$geo_status</span> <span class="sy0">=</span> <span class="st0">"HTTP_FAIL_<span class="es4">$httpCode</span>"</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">   <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
</ol>

<ol>

operate getAdressbyLatLang($lat,$lang)

</div></li>

<li class="li1"><div class="de1"> $tackle = '';

</div></li>

<li class="li1"><div class="de1"> $tackle = $lat.",".$lang;

</div></li>

</div></li>

<li class="li1"><div class="de1"> $geocodeURL = </div></li>

<li class="li1"><div class="de1"> "http://maps.googleapis.com/maps/api/geocode/json?latlng=$a&sensor=false";

</div></li>

<li class="li1"><div class="de1"> return $geocode;

</div></li>

<li class="li1"><div class="de1"> } else {

</div></li>

<li class="li1"><div class="de1"> $geo_status = "HTTP_FAIL_$httpCode";

</div></li>

<li class="li1"><div class="de1"> }

</div></li>

</ol>

Earlier than we’re going to learn data from information base we have to contemplate tackle discipline. If we get information from google map , values is perhaps contained some particular characters. So we have to clear it out.

Our enter cleansing methodology appear to be follows

<ol>
<li class="li1"><div class="de1">
<span class="kw2">operate</span> parseToXML<span class="br0">(</span><span class="re0">$htmlStr</span><span class="br0">)</span> </div></li>
<li class="li1"><div class="de1">
<span class="br0">{</span> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$xmlStr</span><span class="sy0">=</span><a href="http://www.php.net/str_replace" rel="nofollow"><span class="kw3">str_replace</span></a><span class="br0">(</span><span class="st_h">'&lt;'</span><span class="sy0">,</span><span class="st_h">'&amp;lt;'</span><span class="sy0">,</span><span class="re0">$htmlStr</span><span class="br0">)</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$xmlStr</span><span class="sy0">=</span><a href="http://www.php.net/str_replace" rel="nofollow"><span class="kw3">str_replace</span></a><span class="br0">(</span><span class="st_h">'&gt;'</span><span class="sy0">,</span><span class="st_h">'&amp;gt;'</span><span class="sy0">,</span><span class="re0">$xmlStr</span><span class="br0">)</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$xmlStr</span><span class="sy0">=</span><a href="http://www.php.net/str_replace" rel="nofollow"><span class="kw3">str_replace</span></a><span class="br0">(</span><span class="st_h">'"'</span><span class="sy0">,</span><span class="st_h">'&amp;quot;'</span><span class="sy0">,</span><span class="re0">$xmlStr</span><span class="br0">)</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$xmlStr</span><span class="sy0">=</span><a href="http://www.php.net/str_replace" rel="nofollow"><span class="kw3">str_replace</span></a><span class="br0">(</span><span class="st0">"'"</span><span class="sy0">,</span><span class="st_h">'&amp;#39;'</span><span class="sy0">,</span><span class="re0">$xmlStr</span><span class="br0">)</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$xmlStr</span><span class="sy0">=</span><a href="http://www.php.net/str_replace" rel="nofollow"><span class="kw3">str_replace</span></a><span class="br0">(</span><span class="st0">"&amp;"</span><span class="sy0">,</span><span class="st_h">'&amp;amp;'</span><span class="sy0">,</span><span class="re0">$xmlStr</span><span class="br0">)</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">
<span class="kw1">return</span> <span class="re0">$xmlStr</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
</ol>

<ol>

operate parseToXML($htmlStr) </div></li>

{ </div></li>

$xmlStr=<a href="http://www.php.net/str_replace" rel="nofollow">str_replace</a>('<','&lt;',$htmlStr); </div></li>

$xmlStr=<a href="http://www.php.net/str_replace" rel="nofollow">str_replace</a>('>','&gt;',$xmlStr); </div></li>

$xmlStr=<a href="http://www.php.net/str_replace" rel="nofollow">str_replace</a>('"','&quot;',$xmlStr); </div></li>

$xmlStr=<a href="http://www.php.net/str_replace" rel="nofollow">str_replace</a>("'",'&#39;',$xmlStr); </div></li>

$xmlStr=<a href="http://www.php.net/str_replace" rel="nofollow">str_replace</a>("&",'&amp;',$xmlStr); </div></li>

return $xmlStr; </div></li>

</ol>

Lets put all collectively and browse information from databse and convert them to XML

<ol>
<li class="li1"><div class="de1"><span class="co1">// Opens a connection to a MySQL server</span></div></li>
<li class="li1"><div class="de1">
<span class="re0">$connection</span><span class="sy0">=</span><a href="http://www.php.net/mysql_connect" rel="nofollow"><span class="kw3">mysql_connect</span></a> <span class="br0">(</span><span class="re0">$localhost</span><span class="sy0">,</span> <span class="re0">$username</span><span class="sy0">,</span> <span class="re0">$password</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">
<span class="kw1">if</span> <span class="br0">(</span><span class="sy0">!</span><span class="re0">$connection</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">  <a href="http://www.php.net/die" rel="nofollow"><span class="kw3">die</span></a><span class="br0">(</span><span class="st_h">'Not related : '</span> <span class="sy0">.</span> <a href="http://www.php.net/mysql_error" rel="nofollow"><span class="kw3">mysql_error</span></a><span class="br0">(</span><span class="br0">)</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1"><span class="co1">// Set the lively MySQL database</span></div></li>
<li class="li1"><div class="de1">
<span class="re0">$db_selected</span> <span class="sy0">=</span> <a href="http://www.php.net/mysql_select_db" rel="nofollow"><span class="kw3">mysql_select_db</span></a><span class="br0">(</span><span class="re0">$database</span><span class="sy0">,</span> <span class="re0">$connection</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">
<span class="kw1">if</span> <span class="br0">(</span><span class="sy0">!</span><span class="re0">$db_selected</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">  <a href="http://www.php.net/die" rel="nofollow"><span class="kw3">die</span></a> <span class="br0">(</span><span class="st_h">'Cannot use db : '</span> <span class="sy0">.</span> <a href="http://www.php.net/mysql_error" rel="nofollow"><span class="kw3">mysql_error</span></a><span class="br0">(</span><span class="br0">)</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1"><span class="co1">// Choose all of the rows within the markers desk</span></div></li>
<li class="li1"><div class="de1">
<span class="re0">$question</span> <span class="sy0">=</span> <span class="st0">"SELECT * FROM geo_location"</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">
<span class="re0">$end result</span> <span class="sy0">=</span> <a href="http://www.php.net/mysql_query" rel="nofollow"><span class="kw3">mysql_query</span></a><span class="br0">(</span><span class="re0">$question</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">
<span class="kw1">if</span> <span class="br0">(</span><span class="sy0">!</span><span class="re0">$end result</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">  <a href="http://www.php.net/die" rel="nofollow"><span class="kw3">die</span></a><span class="br0">(</span><span class="st_h">'Invalid question: '</span> <span class="sy0">.</span> <a href="http://www.php.net/mysql_error" rel="nofollow"><span class="kw3">mysql_error</span></a><span class="br0">(</span><span class="br0">)</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">
<a href="http://www.php.net/header" rel="nofollow"><span class="kw3">header</span></a><span class="br0">(</span><span class="st0">"Content material-type: textual content/xml"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1"><span class="co1">// Begin XML file, echo mum or dad node</span></div></li>
<li class="li1"><div class="de1">
<span class="kw1">echo</span> <span class="st_h">'&lt;markers&gt;'</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1"><span class="co1">// Iterate by way of the rows, printing XML nodes for every</span></div></li>
<li class="li1"><div class="de1">
<span class="kw1">whereas</span> <span class="br0">(</span><span class="re0">$row</span> <span class="sy0">=</span> <a href="http://www.php.net/mysql_fetch_assoc" rel="nofollow"><span class="kw3">mysql_fetch_assoc</span></a><span class="br0">(</span><span class="re0">$end result</span><span class="br0">)</span><span class="br0">)</span><span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">  <span class="co1">// ADD TO XML DOCUMENT NODE</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">       <span class="re0">$lat</span> <span class="sy0">=</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lat'</span><span class="br0">]</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">      <span class="re0">$lng</span> <span class="sy0">=</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lang'</span><span class="br0">]</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">      <span class="re0">$formatted_address</span> <span class="sy0">=</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_address'</span><span class="br0">]</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="re0">$loc_city</span> <span class="sy0">=</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_city'</span><span class="br0">]</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
<li class="li1"><div class="de1">    <span class="kw1">if</span><span class="br0">(</span> <span class="br0">(</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lat'</span><span class="br0">]</span> <span class="sy0">==</span> <span class="st0">""</span> <span class="sy0">||</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lang'</span><span class="br0">]</span> <span class="sy0">==</span> <span class="st0">""</span> <span class="br0">)</span> <span class="sy0">&amp;&amp;</span>  <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_address'</span><span class="br0">]</span> <span class="sy0">!=</span> <span class="st0">""</span> <span class="br0">)</span><span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">        <span class="co1">// getting lat/ lng</span>
</div></li>
<li class="li1"><div class="de1">       <span class="re0">$responce</span> <span class="sy0">=</span> getLatLangbyAddress<span class="br0">(</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'Location_address'</span><span class="br0">]</span><span class="sy0">,</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_city'</span><span class="br0">]</span><span class="sy0">,</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'zip_code'</span><span class="br0">]</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">       <span class="re0">$randomFloat</span> <span class="sy0">=</span> <a href="http://www.php.net/rand" rel="nofollow"><span class="kw3">rand</span></a><span class="br0">(</span><span class="nu0">0</span><span class="sy0">,</span> <span class="nu0">10</span><span class="br0">)</span> <span class="sy0">/</span> <span class="nu0">10000</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">       <span class="re0">$randomFloat2</span> <span class="sy0">=</span> <a href="http://www.php.net/rand" rel="nofollow"><span class="kw3">rand</span></a><span class="br0">(</span><span class="nu0">0</span><span class="sy0">,</span> <span class="nu0">10</span><span class="br0">)</span> <span class="sy0">/</span> <span class="nu0">10000</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">     <span class="co1">// Including some variation //</span>
</div></li>
<li class="li1"><div class="de1">        <span class="re0">$lat</span> <span class="sy0">=</span> <span class="re0">$responce</span><span class="sy0">-&gt;</span><span class="me1">outcomes</span><span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span><span class="sy0">-&gt;</span><span class="me1">geometry</span><span class="sy0">-&gt;</span><span class="me1">location</span><span class="sy0">-&gt;</span><span class="me1">lat</span> <span class="sy0">+</span> <span class="re0">$randomFloat</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">        <span class="re0">$lng</span> <span class="sy0">=</span> <span class="re0">$responce</span><span class="sy0">-&gt;</span><span class="me1">outcomes</span><span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span><span class="sy0">-&gt;</span><span class="me1">geometry</span><span class="sy0">-&gt;</span><span class="me1">location</span><span class="sy0">-&gt;</span><span class="me1">lng</span> <span class="sy0">+</span> <span class="re0">$randomFloat2</span><span class="sy0">;</span> </div></li>
<li class="li1"><div class="de1">    <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1">            <span class="kw1">if</span><span class="br0">(</span> <span class="br0">(</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lat'</span><span class="br0">]</span> <span class="sy0">!=</span> <span class="st0">""</span> <span class="sy0">&amp;&amp;</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lang'</span><span class="br0">]</span> <span class="sy0">!=</span> <span class="st0">""</span> <span class="br0">)</span> <span class="sy0">&amp;&amp;</span>  <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_address'</span><span class="br0">]</span> <span class="sy0">==</span> <span class="st0">""</span> <span class="br0">)</span><span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">                <span class="co1">// Getting tackle </span>
</div></li>
<li class="li1"><div class="de1">                <span class="re0">$responce</span> <span class="sy0">=</span> getAdressbyLatLang<span class="br0">(</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lat'</span><span class="br0">]</span><span class="sy0">,</span><span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lang'</span><span class="br0">]</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">                <span class="re0">$formatted_address</span> <span class="sy0">=</span> <span class="re0">$responce</span><span class="sy0">-&gt;</span><span class="me1">outcomes</span><span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span><span class="sy0">-&gt;</span><span class="me1">formatted_address</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">            <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'&lt;marker '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'title="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'event_title'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'tackle="'</span> <span class="sy0">.</span> parseToXML<span class="br0">(</span><span class="re0">$formatted_address</span><span class="br0">)</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'metropolis="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_city'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'state="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_state'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'nation="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'nation'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'zip="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'zip_code'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'lat="'</span> <span class="sy0">.</span>  <span class="re0">$lat</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'lng="'</span> <span class="sy0">.</span> <span class="re0">$lng</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'sort="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'locaton_type'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'description="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'location_discription'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'begin="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'start_time'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'finish="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'end_time'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'url="'</span> <span class="sy0">.</span> <span class="re0">$row</span><span class="br0">[</span><span class="st_h">'lcation_url'</span><span class="br0">]</span> <span class="sy0">.</span> <span class="st_h">'" '</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">  <span class="kw1">echo</span> <span class="st_h">'/&gt;'</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"><span class="br0">}</span></div></li>
<li class="li1"><div class="de1"><span class="co1">// Finish XML file</span></div></li>
<li class="li1"><div class="de1">
<span class="kw1">echo</span> <span class="st_h">'&lt;/markers&gt;'</span><span class="sy0">;</span>
</div></li>
</ol>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

<ol>

<li class="li1"><div class="de1">// Opens a connection to a MySQL server</div></li>

$connection=<a href="http://www.php.net/mysql_connect" rel="nofollow">mysql_connect</a> ($localhost, $username, $password);

</div></li>

if (!$connection) {

</div></li>

<li class="li1"><div class="de1"> <a href="http://www.php.net/die" rel="nofollow">die</a>('Not related : ' . <a href="http://www.php.net/mysql_error" rel="nofollow">mysql_error</a>());

</div></li>

<li class="li1"><div class="de1">// Set the lively MySQL database</div></li>

$db_selected = <a href="http://www.php.net/mysql_select_db" rel="nofollow">mysql_select_db</a>($database, $connection);

</div></li>

if (!$db_selected) {

</div></li>

<li class="li1"><div class="de1"> <a href="http://www.php.net/die" rel="nofollow">die</a> ('Cannot use db : ' . <a href="http://www.php.net/mysql_error" rel="nofollow">mysql_error</a>());

</div></li>

<li class="li1"><div class="de1">// Choose all of the rows within the markers desk</div></li>

$question = "SELECT * FROM geo_location";

</div></li>

$end result = <a href="http://www.php.net/mysql_query" rel="nofollow">mysql_query</a>($question);

</div></li>

if (!$end result) {

</div></li>

<li class="li1"><div class="de1"> <a href="http://www.php.net/die" rel="nofollow">die</a>('Invalid question: ' . <a href="http://www.php.net/mysql_error" rel="nofollow">mysql_error</a>());

</div></li>

<a href="http://www.php.net/header" rel="nofollow">header</a>("Content material-type: textual content/xml");

</div></li>

<li class="li1"><div class="de1">// Begin XML file, echo mum or dad node</div></li>

echo '<markers>';

</div></li>

<li class="li1"><div class="de1">// Iterate by way of the rows, printing XML nodes for every</div></li>

whereas ($row = <a href="http://www.php.net/mysql_fetch_assoc" rel="nofollow">mysql_fetch_assoc</a>($end result)){

</div></li>

<li class="li1"><div class="de1"> // ADD TO XML DOCUMENT NODE

</div></li>

<li class="li1"><div class="de1"> $lat = $row['lat'];

</div></li>

<li class="li1"><div class="de1"> $lng = $row['lang'];

</div></li>

<li class="li1"><div class="de1"> $formatted_address = $row['location_address'];

</div></li>

<li class="li1"><div class="de1"> $loc_city = $row['location_city'];

</div></li>

<li class="li1"><div class="de1"> if( ($row['lat'] == "" || $row['lang'] == "" ) && $row['location_address'] != "" ){

</div></li>

<li class="li1"><div class="de1"> // getting lat/ lng

</div></li>

<li class="li1"><div class="de1"> $responce = getLatLangbyAddress($row['Location_address'],$row['location_city'],$row['zip_code']);

</div></li>

<li class="li1"><div class="de1"> $randomFloat = <a href="http://www.php.net/rand" rel="nofollow">rand</a>(0, 10) / 10000;

</div></li>

<li class="li1"><div class="de1"> $randomFloat2 = <a href="http://www.php.net/rand" rel="nofollow">rand</a>(0, 10) / 10000;

</div></li>

<li class="li1"><div class="de1"> // Including some variation //

</div></li>

<li class="li1"><div class="de1"> $lat = $responce->outcomes[0]->geometry->location->lat + $randomFloat; </div></li>

<li class="li1"><div class="de1"> $lng = $responce->outcomes[0]->geometry->location->lng + $randomFloat2; </div></li>

<li class="li1"><div class="de1"> }

</div></li>

<li class="li1"><div class="de1"> if( ($row['lat'] != "" && $row['lang'] != "" ) && $row['location_address'] == "" ){

</div></li>

<li class="li1"><div class="de1"> // Getting tackle

</div></li>

<li class="li1"><div class="de1"> $responce = getAdressbyLatLang($row['lat'],$row['lang']);

</div></li>

<li class="li1"><div class="de1"> $formatted_address = $responce->outcomes[0]->formatted_address;

</div></li>

<li class="li1"><div class="de1"> }

</div></li>

<li class="li1"><div class="de1"> echo '<marker ';

</div></li>

<li class="li1"><div class="de1"> echo 'title="' . $row['event_title'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'tackle="' . parseToXML($formatted_address) . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'metropolis="' . $row['location_city'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'state="' . $row['location_state'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'nation="' . $row['nation'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'zip="' . $row['zip_code'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'lat="' . $lat . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'lng="' . $lng . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'sort="' . $row['locaton_type'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'description="' . $row['location_discription'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'begin="' . $row['start_time'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'finish="' . $row['end_time'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo 'url="' . $row['lcation_url'] . '" ';

</div></li>

<li class="li1"><div class="de1"> echo '/>';

</div></li>

<li class="li1"><div class="de1">// Finish XML file</div></li>

echo '</markers>';

</div></li>

</ol>

Above code will generate output like this

<ol>
<li class="li1"><div class="de1"><span class="sc2">&lt;markers&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">"Check Occasion One"</span> tackle<span class="sy0">=</span><span class="st0">"140 Previous Kent Highway, London SE1, UK"</span> metropolis<span class="sy0">=</span><span class="st0">"check location"</span> state<span class="sy0">=</span><span class="st0">"london"</span> nation<span class="sy0">=</span><span class="st0">"United Kindom"</span> zip<span class="sy0">=</span><span class="st0">"Nw1 w42"</span> lat<span class="sy0">=</span><span class="st0">"51.49164465653034"</span>lng<span class="sy0">=</span><span class="st0">"-0.0823974609375"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"restaurant"</span> description<span class="sy0">=</span><span class="st0">"Al marj Cinema middle check information "</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> url<span class="sy0">=</span><span class="st0">"http://www.geoshaper.com/Reupload/"</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">"Check Occasion Two"</span> tackle<span class="sy0">=</span><span class="st0">"16 Pine Coombe, Croydon, Larger London CR0 5HS, UK"</span> metropolis<span class="sy0">=</span><span class="st0">"check location two"</span> state<span class="sy0">=</span><span class="st0">"london"</span> nation<span class="sy0">=</span><span class="st0">"United Kindom"</span> zip<span class="sy0">=</span><span class="st0">"Nw1 w42"</span>lat<span class="sy0">=</span><span class="st0">"51.36492148825955"</span> lng<span class="sy0">=</span><span class="st0">"-0.0439453125"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"restaurant"</span> description<span class="sy0">=</span><span class="st0">"Check information description two "</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span>url<span class="sy0">=</span><span class="st0">"http://www.geoshaper.com/Reupload/"</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">"Check even 3"</span> tackle<span class="sy0">=</span><span class="st0">"Steinau 1, 8844 Einsiedeln, Switzerland"</span> metropolis<span class="sy0">=</span><span class="st0">"swiss check "</span> state<span class="sy0">=</span><span class="st0">"Zurich zug"</span> nation<span class="sy0">=</span><span class="st0">"Awitzerland"</span> zip<span class="sy0">=</span><span class="st0">"215466"</span> lat<span class="sy0">=</span><span class="st0">"47.08508535995383"</span>lng<span class="sy0">=</span><span class="st0">"8.778076171875"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"restaurant"</span> description<span class="sy0">=</span><span class="st0">"Al marj Cinema middle check information "</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> url<span class="sy0">=</span><span class="st0">"www.geoshaper.com"</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">"London tree"</span> tackle<span class="sy0">=</span><span class="st0">"16 Choats Highway, Barking, Dagenham, Larger London RM9 6LF, UK"</span> metropolis<span class="sy0">=</span><span class="st0">"check location"</span> state<span class="sy0">=</span><span class="st0">"london"</span> nation<span class="sy0">=</span><span class="st0">"United Kindom"</span> zip<span class="sy0">=</span><span class="st0">"Nw1 w42"</span>lat<span class="sy0">=</span><span class="st0">"51.52241608253253"</span> lng<span class="sy0">=</span><span class="st0">"0.1318359375"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"bar"</span> description<span class="sy0">=</span><span class="st0">"Al marj Cinema middle check information "</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> url<span class="sy0">=</span><span class="st0">"www.geoshaper.com"</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">"Swiz occasion two"</span> tackle<span class="sy0">=</span><span class="st0">"Alte Winterthurerstrasse 51A, 8304 Wallisellen, Switzerland"</span> metropolis<span class="sy0">=</span><span class="st0">"swiss check "</span> state<span class="sy0">=</span><span class="st0">"london"</span> nation<span class="sy0">=</span><span class="st0">"switzerland"</span> zip<span class="sy0">=</span><span class="st0">"215466"</span>lat<span class="sy0">=</span><span class="st0">"47.416937456635445"</span> lng<span class="sy0">=</span><span class="st0">"8.59130859375"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"restaurant"</span> description<span class="sy0">=</span><span class="st0">"Al marj Cinema middle check information "</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span>url<span class="sy0">=</span><span class="st0">"www.geoshaper.com"</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;marker <span class="kw3">title</span><span class="sy0">=</span><span class="st0">""</span> tackle<span class="sy0">=</span><span class="st0">"TQ3 3ST"</span> metropolis<span class="sy0">=</span><span class="st0">""</span> state<span class="sy0">=</span><span class="st0">""</span> nation<span class="sy0">=</span><span class="st0">""</span> zip<span class="sy0">=</span><span class="st0">""</span> lat<span class="sy0">=</span><span class="st0">"51.95780738871554"</span> lng<span class="sy0">=</span><span class="st0">"-2.887207567691803"</span> <span class="kw3">sort</span><span class="sy0">=</span><span class="st0">"restaurant"</span> description<span class="sy0">=</span><span class="st0">""</span> <span class="kw3">begin</span><span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span>finish<span class="sy0">=</span><span class="st0">"0000-00-00 00:00:00"</span> url<span class="sy0">=</span><span class="st0">""</span><span class="sy0">/</span>&gt;</span></div></li>
<li class="li1"><div class="de1"><span class="sc2">&lt;<span class="sy0">/</span>markers&gt;</span></div></li>
</ol>

<ol>

</ol>

Now now we have all required info that we want visualizes on google map. Lets create map.
Initializing map

<ol>
<li class="li1"><div class="de1">geocoder <span class="sy0">=</span> <span class="kw1">new</span> google.<span class="me1">maps</span>.<span class="me1">Geocoder</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">    <span class="kw1">var</span> latlng <span class="sy0">=</span> <span class="kw1">new</span> google.<span class="me1">maps</span>.<span class="me1">LatLng</span><span class="br0">(</span><span class="nu0">46.837649560937464</span><span class="sy0">,</span> <span class="nu0">8.60452651977539</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">    <span class="kw1">var</span> mapOptions <span class="sy0">=</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">      zoom<span class="sy0">:</span> <span class="nu0">2</span><span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">      middle<span class="sy0">:</span> latlng<span class="sy0">,</span>
</div></li>
<li class="li1"><div class="de1">      mapTypeId<span class="sy0">:</span> google.<span class="me1">maps</span>.<span class="me1">MapTypeId</span>.<span class="me1">ROADMAP</span>
</div></li>
<li class="li1"><div class="de1">    <span class="br0">}</span>
</div></li>
<li class="li1"><div class="de1">    map <span class="sy0">=</span> <span class="kw1">new</span> google.<span class="me1">maps</span>.<span class="me1">Map</span><span class="br0">(</span>doc.<span class="me1">getElementById</span><span class="br0">(</span><span class="st0">"map-canvas"</span><span class="br0">)</span><span class="sy0">,</span> mapOptions<span class="br0">)</span><span class="sy0">;</span>
</div></li>
</ol>

<ol>

<li class="li1"><div class="de1">geocoder = new google.maps.Geocoder();

</div></li>

<li class="li1"><div class="de1"> var latlng = new google.maps.LatLng(46.837649560937464, 8.60452651977539);

</div></li>

<li class="li1"><div class="de1"> var mapOptions = {

</div></li>

<li class="li1"><div class="de1"> zoom: 2,

</div></li>

<li class="li1"><div class="de1"> middle: latlng,

</div></li>

<li class="li1"><div class="de1"> mapTypeId: google.maps.MapTypeId.ROADMAP

</div></li>

<li class="li1"><div class="de1"> }

</div></li>

<li class="li1"><div class="de1"> map = new google.maps.Map(doc.getElementById("map-canvas"), mapOptions);

</div></li>

</ol>

Then we’re creating infowindow to point out information on icon

<ol><li class="li1"><div class="de1">
<span class="kw1">var</span> infoWindow <span class="sy0">=</span> <span class="kw1">new</span> google.<span class="me1">maps</span>.<span class="me1">InfoWindow</span><span class="sy0">;</span>
</div></li></ol>

var infoWindow = new google.maps.InfoWindow;

</div></li></ol>

Subsequent we transfer to load from our xml out put file

<ol>
<li class="li1"><div class="de1">  downloadUrl<span class="br0">(</span><span class="st0">"location_xml_reader.php"</span><span class="sy0">,</span> <span class="kw1">operate</span><span class="br0">(</span>information<span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">        <span class="kw1">var</span> xml <span class="sy0">=</span> information.<span class="me1">responseXML</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">         <span class="kw1">var</span> markers <span class="sy0">=</span> <span class="br0">[</span><span class="br0">]</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">        <span class="kw1">var</span> markers <span class="sy0">=</span> xml.<span class="me1">documentElement</span>.<span class="me1">getElementsByTagName</span><span class="br0">(</span><span class="st0">"marker"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">        <span class="kw1">for</span> <span class="br0">(</span><span class="kw1">var</span> i <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> i <span class="sy0">&lt;</span> markers.<span class="me1">size</span><span class="sy0">;</span> i<span class="sy0">++</span><span class="br0">)</span> <span class="br0">{</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> title <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"title"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> metropolis <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"metropolis"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> state <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"state"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> nation <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"nation"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> tackle <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"tackle"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> sort <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"sort"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">          <span class="kw1">var</span> zip <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"zip"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">		  <span class="kw1">var</span> description <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"description"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">                  <span class="kw1">var</span> starttime <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"begin"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">                  <span class="kw1">var</span> endtime <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"finish"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1">		  <span class="kw1">var</span> url <span class="sy0">=</span> markers<span class="br0">[</span>i<span class="br0">]</span>.<span class="me1">getAttribute</span><span class="br0">(</span><span class="st0">"url"</span><span class="br0">)</span><span class="sy0">;</span>
</div></li>
<li class="li1"><div class="de1"> </div></li>
</ol>

<ol>

<li class="li1"><div class="de1"> downloadUrl("location_xml_reader.php", operate(information) {

</div></li>

<li class="li1"><div class="de1"> var xml = information.responseXML;

</div></li>

<li class="li1"><div class="de1"> var markers = [];

</div></li>

<li class="li1"><div class="de1"> var markers = xml.documentElement.getElementsByTagName("marker");

</div></li>

<li class="li1"><div class="de1"> for (var i = 0; i < markers.size; i++) {

</div></li>

<li class="li1"><div class="de1"> var title = markers[i].getAttribute("title");

</div></li>

<li class="li1"><div class="de1"> var metropolis = markers[i].getAttribute("metropolis");

</div></li>

<li class="li1"><div class="de1"> var state = markers[i].getAttribute("state");

</div></li>

<li class="li1"><div class="de1"> var nation = markers[i].getAttribute("nation");

</div></li>

<li class="li1"><div class="de1"> var tackle = markers[i].getAttribute("tackle");

</div></li>

<li class="li1"><div class="de1"> var sort = markers[i].getAttribute("sort");

</div></li>

<li class="li1"><div class="de1"> var zip = markers[i].getAttribute("zip");

</div></li>

<li class="li1"><div class="de1"> var description = markers[i].getAttribute("description");

</div></li>

<li class="li1"><div class="de1"> var starttime = markers[i].getAttribute("begin");

</div></li>

<li class="li1"><div class="de1"> var endtime = markers[i].getAttribute("finish");

</div></li>

<li class="li1"><div class="de1"> var url = markers[i].getAttribute("url");

</div></li>

</ol>

Share this:

Related posts: