Jump to content

Need help in incorporate php into java script - google API


NitinMutkawoa

Recommended Posts

hello.. i urgently need help concerning this page

 

subjectgoogle.php - - to display the google maps togather with the table form:

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
    <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
    <title>Saving User-Added Form Data Example</title>
    <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
    <script type="text/javascript">
    var marker;
    var infowindow;

    function initialize() {
      var latlng = new google.maps.LatLng(37.4419, -122.1419);
      var options = {
        zoom: 13,
        center: latlng,
        mapTypeId: google.maps.MapTypeId.ROADMAP
      }
      var map = new google.maps.Map(document.getElementById("map_canvas"), options);
      var html = "<table>" +
	             "<tr><td>Criminal ID:</td> <td> <?php
            
			if ($subject == "criminal")
			{
			 $sql_query= mysql_query("SELECT max(criminalid) + 1 from `criminal` ");
  $row1 = mysql_fetch_array($sql_query);
  //echo $row1[0];
			//if $row
			
			?><input type='text' id='id' value="<?php echo $row1[0];?>"/></td> </tr>"
			<?php
			 }
			 
			 else if ($subject == "offender")
			 {
				 $sql_query1= mysql_query("SELECT max(offenderid) + 1 from `offender` ");
	 $row = mysql_fetch_array($sql_query1);
	 //echo $row[0];
	 ?> + "<input type='text' name='id' id='id' value ="<?php echo $row[0];?>"/>"+
			 <?php
			 }
			 ?>
	             "<tr><td>Location ID:</td> <td><input type='text' id='locid'/></td> </tr>" +
                 "<tr><td>First Name:</td> <td><input type='text' id='fname'/> </td> </tr>" +
                 "<tr><td>Last Name:</td> <td><input type='text' id='lname'/></td> </tr>" +
				 "<tr><td>Age:</td> <td><input type='text' id='age'/></td> </tr>" +
				 "<tr><td>Address:</td> <td><input type='text' id='address'/></td> </tr>" +
				 "<tr><td>Profession:</td> <td><input type='text' id='profession'/></td> </tr>" +
				 "<tr><td>Modus Operandi:</td> <td><input type='text' id='modus_operandi'/></td> </tr>" +
				 "<tr><td>Hiv Info:</td> <td><input type='text' id='hiv_info'/></td> </tr>" +
				 
                 "<tr><td> Subject:</td> <td><select id='subject'>" +
                 "<option value='criminal' SELECTED>criminal</option>" +
                 "<option value='offender'>offender</option>" +
                 "</select><?php
				 echo "<select name='subject' onchange=\"reload(this.form)\"><option value=''>select one</option>";
if($subject==@$subject)
{echo "<option selected value= ".$subject."></option>";
	echo "<option value='criminal'>criminal</option>"; 
echo "<option value='offender'>offender</option>";}
else{echo  "<option value=\"".$subject."\">".$subject."</option>";}
?> </td></tr>" +
                 "<tr><td></td><td><input type='button' value='Save & Close' onclick='saveData()'/></td></tr>";
    infowindow = new google.maps.InfoWindow({
     content: html
    });

    google.maps.event.addListener(map, "click", function(event) {
        marker = new google.maps.Marker({
          position: event.latLng,
          map: map
        });
        google.maps.event.addListener(marker, "click", function() {
          infowindow.open(map, marker);
        });
    });
    }

    function saveData() {
      var id = escape(document.getElementById("id").value);
	  var locid = escape(document.getElementById("locid").value);
	  var fname = escape(document.getElementById("fname").value);
	  var lname = escape(document.getElementById("lname").value);
	  var age = escape(document.getElementById("age").value);
	  var address = escape(document.getElementById("address").value);
      var profession = escape(document.getElementById("profession").value);
	  var modus_operandi = escape(document.getElementById("modus_operandi").value);
	  var hiv_info = escape(document.getElementById("hiv_info").value);
      var subject = document.getElementById("subject").value;
      var latlng = marker.getPosition();

      var url = "subjectgooglescript.php?id=" + id + 
	                                         "&locid=" + locid + 
											 "&fname=" + fname + 
											 "&lname=" + lname + 
											 "&age=" + age + 
											 "&address=" + address + 
											 "&profession=" + profession +
											 "&modus_operandi=" + modus_operandi +
											 "&hiv_info=" + hiv_info + 
											 "&lat=" + latlng.lat() + 
											 "&lng=" + latlng.lng();
      downloadUrl(url, function(data, responseCode) {
        if (responseCode == 200 && data.length <= 1) {
          infowindow.close();
          document.getElementById("message").innerHTML = "Location added.";
        }
      });
    }

    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.responseText, request.status);
        }
      };

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

    function doNothing() {}
    </script>
  </head>
  <body style="margin:0px; padding:0px;" onload="initialize()">
    <div id="map_canvas" style="width: 500px; height: 300px"></div>
    <div id="message"></div>
  </body>
</html>

can you help in identifying my errors please??

 

regards

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.