xml

<?php

/*

	Template Name: myTemp

*/

	get_header();




 /* >>>>>>>>>>>>>>>>>>>>>>>>>>>>> Read and Get From Table */
 	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;

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



	 $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
		 foreach($query as $single_query) {

		  $data = json_decode($single_query);
			?>

     <li style="list-style:none;">
          <?php
			 // ADD TO XML DOCUMENT NODE
		  $node = $dom->createElement("marker");
		  $newnode = $parnode->appendChild($node);
		  $newnode->setAttribute("lat",$data->results[0]->geometry->location->lat);
		  $newnode->setAttribute("lng", $data->results[0]->geometry->location->lng);







			?>
     </li>

     <?php

		 echo $dom->saveXML();




	} //  end foreach

		  ?>
</ul>
<?php





	}  //  endif




    ?>
<div id="map" style="width:350px; height:300px; margin-bottom:10px;"></div>
<script type="text/javascript">
    //<![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("<?php __FILE__ ?>", function(data) {
        var xml = data.responseXML;
        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();

?>