01.<?
02.$objConnect = mysql_connect("localhost","root","1111") or die("Error Connect to Database");
03.$objDB = mysql_select_db("atsinfo");
04.$strSQL = "SELECT * FROM realtime where GVin ='70-1116'";
05.mysql_query("SET NAMES UTF8");
06.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
07.$totalrecord = mysql_num_rows($objQuery);
08.?>
09.<?
10.while($objResult = mysql_fetch_array($objQuery))
11.{
12.?>
13.<?
14.
15.
16.
17.
18.
19.$lat.=$objResult["GLat"];
20.$lon.=$objResult["GLon"];
21.$time.=$objResult["GTime"];
22.$head.=$objResult["GHead"];
23.
24.?>
25.<?
26.}
27.?>
28.
29.<html>
30.<body>
31.<?php
32.
33.
34. echo '<script type="text/javascript">';
35. echo "var latt = '$lat';";
36. echo "var lonn = '$lon';";
37. echo "var timee = '$time';";
38. echo "var headd = '$head';";
39. echo '</script>';
40.?>
41.
42.
43.<script type="text/javascript">
44.for(i=0; i <<?=$totalrecord?>; i++){
45. document.write(latt[i] +"<br>");
46. document.write(lonn[i]+"<br>");
47. document.write(timee[i]+"<br>");
48. document.write(headd[i]+"<br>");
49. document.write("<br>");
50. }
51.</script>
52.</body>
53.</html>
54.<?
55.mysql_close($objConnect);
56.?>
