[SOLVED] Priniting PHP variables into Javascript without page refresh

mikemessiah · October 22, 2008

Hi all,

I query a mysql database and get values these variables now need to be put into a javascript function and then run that javascript function.

I have tried running:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script language="JavaScript" type="text/javascript">
// JavaScript Document

function getXMLHTTPRequest() {
try {
req = new XMLHttpRequest();
} catch(err1) {
try {
req = new ActiveXObject("Msxml2.XMLHTTP");
} catch (err2) {
	try {
	req = new ActiveXObject("Microsoft.XMLHTTP");
	} catch (err3) {
	  req = false;
	}
}
}
return req;
}

var http = getXMLHTTPRequest();

function getServerText() {
var myurl = 'java-jump.txt';
myRand = parseInt(Math.random()*999999999999999);
var modurl = myurl+"?rand="+myRand;
http.open("GET", modurl, true);
http.onreadystatechange = useHttpResponse;
http.send(null);
}

function useHttpResponse() {
if (http.readyState == 4) {
if(http.status == 200) {
var mytext = http.responseText;;
document.getElementById('myPageElement').innerHTML = mytext;
}
} else {
document.getElementById('myPageElement').innerHTML = '<div id="loading-gif"><img src="anim.gif"><br><p>Loading... Please Wait</p></div>';
}
}
</script>
</head>

<body>

<a onclick="getServerText()">TEST</a>

<div id="MapPanel" style="width:400px;height:300px;"></div>
<div id="myPageElement" class="TEST"></div><!--End #Advanced Search--> 



</body>
</html>

so that it brings in "servertext.php"

<?php 

echo "Wish this would work";

require ("config.php");	

$conn = mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_select_db($dbdatabase, $conn);

$UnitSerialNumber = '358278002008100';

$query = "SELECT * FROM $dbdatabase.$dbtableDecodedData WHERE UnitID = '$UnitSerialNumber' order by MessageDateTime desc limit 1";

$result = mysql_query($query) or die('Unable to run Serial Search query : ' . mysql_error());
$DecodedData = mysql_fetch_array($result);

$UnitID = $DecodedData["UnitID"];
$MessageDateTime = $DecodedData["MessageDateTime"];
$Latitude = $DecodedData["Latitude"];
$Longitude = $DecodedData["Longitude"];
$Speed = $DecodedData["Speed"];
$Altitude = $DecodedData["Altitude"];
$Network = $DecodedData["Network"];
$Address = $DecodedData["Address"];

$query = "SELECT * FROM $dbdatabase.$dbtableUnits WHERE UnitSerialNumber=$UnitSerialNumber ";

$result = mysql_query($query) or die('Unable to run GPSUnits Search query : ' . mysql_error());
$Units = mysql_fetch_array($result);

$Owner = $Units["Owner"];
$DateAdded = $Units["DateAdded"];
$CommonName = $Units["CommonName"];

$query = "SELECT * FROM $dbdatabase.$dbtableABIUnits WHERE UnitSerialNumber=$UnitSerialNumber ";

$result = mysql_query($query) or die('Unable to run ABIUnits Search query : ' . mysql_error());
$ABIUnits = mysql_fetch_array($result);

$Description_Unit = $ABIUnits["Description_Unit"];
$Region = $ABIUnits["Region"];
$Location_Info = $ABIUnits["Location_Info"];
$Location_Latitude = $ABIUnits["Location_Latitude"];
$Location_Longitude = $ABIUnits["Location_Longitude"];

$query = "SELECT * FROM $dbdatabase.$dbtableABIUnits_Alerts WHERE Unit_Serial=$UnitSerialNumber ";

$result = mysql_query($query) or die('Unable to run Alert query : ' . mysql_error());
$ABIUnits_Alerts = mysql_fetch_array($result);

$Unit_Serial = $ABIUnits_Alerts["Unit_Serial"];
$Alert_Type = $ABIUnits_Alerts["Alert_Type"];
$Time = $ABIUnits_Alerts["Time"];
$State = $ABIUnits_Alerts["State"];
$Comment = $ABIUnits_Alerts["Comment"];

echo "$Speed is the speed - lat: $Latitude - long: $Longitude ";


echo "

<script language=\"JavaScript\" type=\"text/javascript\">
		var g_map = null;		
            function initAGMap1()
		{
        		g_map = new AGMap(document.getElementById(\"MapPanel\"), '22615975125160232162022552211342541312121430183244137157');
		}			

		function btnAddSerialClick()
		{
			g_map.AddPoint(\"/images/green.gif\",\"img1\", $Latitude,$Longitude,-8,-8,\"<b>Init $UnitID</b>\",\"State: $State <br>Speed: $Speed Kmph <br> Altitude: $Altitude MSL <br> Network: $Network <br> Area: $Address <br> Region: $Region <br> Location Info: $Location_Info <br> Description: $Description_Unit \");
			g_map.CentreAndScale($Latitude,$Longitude,9);
		}
		function btnResetMapClick()
		{
			g_map.ResetMap();
		}

initAGMap1();			
btnAddSerialClick();			
</script>
"; ?>

The php prints and it is visable on the page. but the javascript functions do not run.

Please help ??? ???

rhodesa · October 22, 2008

check this out:

http://www.phpfreaks.com/forums/index.php/topic,221916.0.html

mikemessiah · October 23, 2008

THANKS SO MUCH!!!

I am instantly in love with jQuery!!!!

WOW!

rhodesa · October 23, 2008

it makes life so much simpler

Sign In

[SOLVED] Priniting PHP variables into Javascript without page refresh

Recommended Posts

mikemessiah

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

mikemessiah

Link to comment

Share on other sites

rhodesa

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information