lat & lng meesturen naar db

Door philippe op 21-05-2009 12:35

1.417 views

ik gebruik google maps.
ik krijg via een JS bestand de lat & lng geprint, maar nu zou ik die willen meesturen naar mijn databank
JS:


//load Google Map
    //<![CDATA[
 function load() {
      if (GBrowserIsCompatible()) {
        var map = new GMap2(document.getElementById("map"));
        map.addControl(new GSmallMapControl());
        map.addControl(new GMapTypeControl());
        var center = new GLatLng(50.88529, 4.63928);
        map.setCenter(center, 7);
        geocoder = new GClientGeocoder();
        var marker = new GMarker(center, {draggable: true});  
        map.addOverlay(marker);
        document.getElementById("lat").innerHTML = center.lat().toFixed(5);
        document.getElementById("lng").innerHTML = center.lng().toFixed(5);

	  GEvent.addListener(marker, "dragend", function() {
       var point = marker.getPoint();
	      map.panTo(point);
       document.getElementById("lat").innerHTML = point.lat().toFixed(5);
       document.getElementById("lng").innerHTML = point.lng().toFixed(5);

        });


	 GEvent.addListener(map, "moveend", function() {
		  map.clearOverlays();
    var center = map.getCenter();
		  var marker = new GMarker(center, {draggable: true});
		  map.addOverlay(marker);
		  document.getElementById("lat").innerHTML = center.lat().toFixed(5);
	   document.getElementById("lng").innerHTML = center.lng().toFixed(5);


	 GEvent.addListener(marker, "dragend", function() {
      var point =marker.getPoint();
	     map.panTo(point);
      document.getElementById("lat").innerHTML = point.lat().toFixed(5);
	     document.getElementById("lng").innerHTML = point.lng().toFixed(5);

        });
 
        });

      }
    }

	   function showAddress(address) {
	   var map = new GMap2(document.getElementById("map"));
       map.addControl(new GSmallMapControl());
       map.addControl(new GMapTypeControl());
       if (geocoder) {
        geocoder.getLatLng(
          address,
          function(point) {
            if (!point) {
              alert(address + " not found");
            } else {
		  document.getElementById("lat").innerHTML = point.lat().toFixed(5);
	   document.getElementById("lng").innerHTML = point.lng().toFixed(5);
		 map.clearOverlays()
			map.setCenter(point, 14);
   var marker = new GMarker(point, {draggable: true});  
		 map.addOverlay(marker);

		GEvent.addListener(marker, "dragend", function() {
      var pt = marker.getPoint();
	     map.panTo(pt);
      document.getElementById("lat").innerHTML = pt.lat().toFixed(5);
	     document.getElementById("lng").innerHTML = pt.lng().toFixed(5);
        });


	 GEvent.addListener(map, "moveend", function() {
		  map.clearOverlays();
    var center = map.getCenter();
		  var marker = new GMarker(center, {draggable: true});
		  map.addOverlay(marker);
		  document.getElementById("lat").innerHTML = center.lat().toFixed(5);
	   document.getElementById("lng").innerHTML = center.lng().toFixed(5);

	 GEvent.addListener(marker, "dragend", function() {
     var pt = marker.getPoint();
	    map.panTo(pt);
    document.getElementById("lat").innerHTML = pt.lat().toFixed(5);
	   document.getElementById("lng").innerHTML = pt.lng().toFixed(5);
        });
 
        });

            }
          }
        );
      }
    }
//]]>

php bestand:


<?php
	include('db.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
      	<title>lat & long</title>
      <script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAAgrj58PbXr2YriiRDqbnL1RRdqDCIfn-akWLPXbZqJg-hQ6eHehSRJ1rozvQIj0_jjwfMfzxMVY23oQ" type="text/javascript"></script>
      <script src="Googlemaps_duikplaats_toevoegen.js" type="text/javascript"></script>

  </head>

  
<body onload="load()" onunload="GUnload()" >
	    <div align="center" id="map" style="width: 600px; height: 400px"><br/></div>

	    <form action="#">
    	<table border="1">
        	<tr>
				<td width="100"><b>Latitude</b></td>
				<td id="lat"></td>
            </tr>
            <tr>
            	<td width="100"><b>Longitude</b></td>
				<td id="lng"></td>
            </tr>
    		<tr>
        		<td>duikplaast: <input type="text" /></td>
         	</tr>
            <tr>
            	<td>
                	<table border="1">
                    	<tr>
                        	<td>Straat: <input type="text" /></td>
                        </tr>
                        <tr>
                        	<td>Nr: <input type="text" /></td>
                        </tr>
                        <tr>
                        	<td>Postcode: <input type="text" /></td>
                        </tr>
                        <tr>
                        	<td>Gemeente: <input type="text" /></td>
                        </tr>
                    </table>
                </td>
				<td>Parking:</td>
				<td>Max. diepte:</td>
				<td>Douche:</td>
				<td>Prijs:</td>
            </tr>
            <tr>
            	<td>&nbsp;</td>
            	<td><input type="text" /></td>
                <td><input type="text" /></td>
                <td><input type="text" /></td>
                <td><input type="text" /></td>
            </tr>
            <tr>
            	<td>&nbsp;</td>
            	<td>Zuurstof:</td>
                <td>Kleedkamer:</td>
                <td>vulmogelijkheid:</td>
                <td>Inlichtingen:</td>
            </tr>
            <tr>
            	<td>&nbsp;</td>
            	<td><input type="text" /></td>
                <td><input type="text" /></td>
                <td><input type="text" /></td>
                <td><input type="text" /></td>
            </tr>
     	</table>
    </form>
  </body>
</html>