|
|
Posted by shawn.ready on 08/21/06 23:40
Hi All
I have a little page I am having issues with. What I am doing is using
php to query a odbc database and create a Google Map with point
information I get back from the db. But the UpdateMyMap() function that
has some php in it is not storing the the $pidpoint variable contents
between calls (this page is a mix of php and javascript)...
----------START CODE HERE----------
<!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"
xmlns:v="urn:schemas-microsoft-com:vml">
<?php
$connectionstring = odbc_connect('some','bits','here');
if (!$connectionstring) {
echo '<p>Not connected to the database server at this time.</p>';
echo '<p>Please try again later.</p>';
}else {
echo '<p>Connected to the database server at this time.</p>';
global $pidpoint;
//This is the var that is giving me issues
$pidpoint="unique_String_1234";
$pidpointNext;
$pidpointOld;
// Now that I have the PID, I can get the Lat/Long/Speed/Angle
$stmt = odbc_prepare($connectionstring, 'EXEC getPIDLocation ?;');
$result = odbc_execute($stmt,array($pidpoint));
$Latitude = odbc_result($stmt, "Latitude");
$Longitude = odbc_result($stmt, "Longitude");
$Speed = odbc_result($stmt, "Speed");
$Angle = odbc_result($stmt, "Angle");
}
odbc_close($connectionstring);
?>
<head>
<meta http-equiv="content-type" content="text/html;
charset=utf-8"/>
<title>Me Google Map</title>
<style type="text/css">
v\:* {
behavior:url(#default#VML);
}
</style>
<script
src="http://maps.google.com/maps?file=api&v=2&key=MyKeyHere"
type="text/javascript"></script>
<script type="text/javascript">
<!-- I need to have some var defined at a high level -->
var Latitude=<?php echo $Latitude ?>;
var Longitude=<?php echo $Longitude ?>;
var Speed=<?php echo $Speed ?>;
var Angle=<?php echo $Angle ?>;
var Pid=<?php echo "\"" . $pidpoint . "\""?>;
var timePeriod=10000;
var map;
<!-- Most of these functions will be moved into suitable files as the
project progresses -->
function createMarker(point, details) {
var marker = new GMarker(point);
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowHtml(details);
});
return marker;
}
function UpdateMyMap() {
<?php
// This is were I am having issues, first time it is uses
// the $pidpoint from first php calls above,
global $pidpoint;
$connectionstring = odbc_connect('some','bits','here');
$pidpointOld=$pidpoint;
$stmNextPoint = odbc_prepare($connectionstring, 'EXEC getNextPoint
?;');
$resultNextPoint = odbc_execute($stmNextPoint,array($pidpointOld));
$pidpointNext = odbc_result($stmNextPoint, "PID");
$stmt = odbc_prepare($connectionstring, 'EXEC getPIDLocation ?;');
$result = odbc_execute($stmt,array($pidpointNext));
$Latitude = odbc_result($stmt, "Latitude");
$Longitude = odbc_result($stmt, "Longitude");
$Speed = odbc_result($stmt, "Speed");
$Angle = odbc_result($stmt, "Angle");
$pidpoint=$pidpointNext; // THIS IS NOT STORE 2nd TIME AROUND!!! it
will use the unique_String_1234 AGAIN, AND AGAIN,
// NOT THE VAR I SET IT TO FROM
$pidpointNext
// I think this is a scope issue, I have
tried global and static...but I am doing something wrong...
odbc_close($connectionstring);
?>
Latitude=<?php echo $Latitude ?>;
Longitude=<?php echo $Longitude ?>;
Speed=<?php echo $Speed ?>;
Angle=<?php echo $Angle ?>;
Pid=<?php echo "\"" . $pidpoint . "\""?>;
PidOld=<?php echo "\"" . $pidpointOld . "\""?>;
alert("Old Point: " +PidOld + " New Point: " + Pid);
details = "Location: Latitude = " + Latitude + " Longitude = " +
Longitude + " <br/>Speed: km=" + Speed + "<br/>Angle=" + Angle;
var point = new GLatLng(Latitude, Longitude);
map.addOverlay(createMarker(point,details));
map.setCenter(new GLatLng(Latitude,Longitude), 15);
}
<!-- This is going to be our main map generation area -->
function load() {
map = new GMap2(document.getElementById("map"));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GOverviewMapControl());
map.setCenter(new GLatLng(Latitude, Longitude), 15);
var point = new GLatLng(Latitude, Longitude);
details = "Location: Latitude = " + Latitude + " Longitude = " +
Longitude + "<br/>Speed: km=" + Speed + "<br/>Angle=" + Angle;
map.addOverlay(createMarker(point,details));
map.setCenter(new GLatLng(Latitude,Longitude), 15);
window.setInterval(UpdateMyMap, timePeriod);
}
</script>
</head>
<body onload="load()">
<div id="map" style="width: 1000px; height: 800px"></div>
</body>
</html>
----------END CODE HERE----------
Any pointers/help would be great.
Thanks Shawn.
Navigation:
[Reply to this message]
|