XML Map

<?php

/*

	Template Name: myTemp

*/



	get_header();

	/* >>>>>>>>>>>>>>>>>>>>>>>>>>>>> check form submission */
 	if(isset($_POST['address']) && $_POST['address'] != '' && (isset($_POST['city'])) && $_POST['city'] != '')  {
	 $user_search = esc_attr($_POST['city']);

	 global $wpdb;

	 $wpdb->show_errors();
	 //global $user_search;


	/* >>>>>>>>>>>>>>>>>>>>>>>>>>>>> XML creation */
	$dom = new DOMDocument("1.0");
	$node = $dom->createElement($wpdb->prefix.'address_table');
	$parnode = $dom->appendChild($node);

	 /* >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Read and Get From Table */
	$query = $wpdb->get_col( $wpdb->prepare('SELECT json FROM '.$wpdb->prefix.'address_table WHERE city = %s', $user_search ) );

	 ?>

<pre><?php
	 //var_dump( $query );
	 ?>
</pre>
<?php
	 $result = array();
	 ?>
<ul style="float:right;">
     <?php
	      $node = $dom->createElement("marker");
		  $newnode = $parnode->appendChild($node);

		  foreach($query as $single_query) {

		  $data = json_decode($single_query);
			?>
     <li style="list-style:none;">
          <?php
			 // ADD TO XML DOCUMENT NODE

		  $newnode->setAttribute("lat", $data->results[0]->geometry->location->lat);
		  $newnode->setAttribute("lng", $data->results[0]->geometry->location->lng);

		  echo $dom->saveXML($newnode);

			?>
     </li>
     <?php

	} //  end foreach

		  ?>
</ul>
<?php

	}  //  endif

    ?>
<div id="map" style="width:350px; height:300px; margin-bottom:10px;"></div>

<script>
//<![CDATA[
    function load() {
      var map = new google.maps.Map(document.getElementById("map"), {
        center: new google.maps.LatLng("lat", "lng"),
        zoom: 8,
        mapTypeId: 'roadmap'
      });
      var infoWindow = new google.maps.InfoWindow;

      // Change this depending on the name of your PHP file
      downloadUrl("", function(data) {
        var xml = data.responseXML;
		// for each row of coords, iterate into point var below
        var markers = xml.documentElement.getElementsByTagName("marker");
        for (var i = 0; i < markers.length; i++) {



          var point = new google.maps.LatLng(
              parseFloat(markers[i].getAttribute("lat")),
              parseFloat(markers[i].getAttribute("lng")));
          var html = "<b>" + "hi there" + "</b> <br/>" ;

          var marker = new google.maps.Marker({
            map: map,
            position: new google.maps.LatLng("lat", "lng")
          });
          bindInfoWindow(marker, map, infoWindow, html);
        }
      });
    }

    function bindInfoWindow(marker, map, infoWindow, html) {
      google.maps.event.addListener(marker, 'click', function() {
        infoWindow.setContent(html);
        infoWindow.open(map, marker);
      });
    }

    function downloadUrl(url, callback) {
      var request = window.ActiveXObject ?
          new ActiveXObject('Microsoft.XMLHTTP') :
          new XMLHttpRequest;

      request.onreadystatechange = function() {
        if (request.readyState == 4) {
          request.onreadystatechange = doNothing;
          callback(request, request.status);
        }
      };

      request.open('GET', url, true);
      request.send(null);
    }

    function doNothing() {}
//]]>

	 google.maps.event.addDomListener(window, 'load', load);
  </script>
<form method="post" action="" id="insertForm" name="insertForm">
     <input type="text" value="" placeholder="enter city" id="city" name="city">
     <input type="text" value="" placeholder="enter full address" id="address" name="address">
     <input type="submit" value="search">
</form>
<?php

	get_footer();

?>