 |
เกี่ยวกับ getJson ไม่ยอมทำงานทังที่ที่ยังมีข้อมูล ช่วยดูให้หน่อยนะคะ |
| |
 |
|
|
 |
 |
|
ลองเรียกตัวที่เป็น php ครับ มี error หรือเปล่าครับ
|
 |
 |
 |
 |
| Date :
2012-04-26 11:41:38 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ไม่มีค่ะ file ที่เป็น PHP ทำงานปกติ ลองecho ค่าออกมาปล้ว แสดงได้
|
| |
|
|
| |
| Date :
2012-04-26 12:28:26 |
By :
tai_kook |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ได้โหลด jquery library หรือยังครับ
เอาโค้ดหน้าแรกเต็มๆ มาดูหน่อยครับ
|
| |
|
|
| |
| Date :
2012-04-26 12:45:14 |
By :
nautilus |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<title>Surinrobot Point</title>
<link href="../css/stylesheet.css" rel="stylesheet" type="text/css">
<link href="../css/font.css" rel="stylesheet" type="text/css">
<link href="../images/logo_surinrobot_v2_final_trans.ico" rel="Shortcut Icon">
<script src="script/jquery.js" type="text/javascript"></script>
<script src="script/cookie.js" type="text/javascript"></script>
<script src="script/jquery.color.js" type="text/javascript"></script>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAj30QKHG_gXSN14-Yk9IujhT0LRfzerdCJ0Gp1m6-rUhe2MMxqBSJjX0Gc3OARCNervkd35Ek0YOLKg" type="text/javascript"></script>
<?
// more about Session -> http://www.php.net/manual/en/book.session.php
if ( $_POST['txtUsername'] != "" && $_POST['txtPassword'] != "" ) {
$_SESSION["g_ownerusername"] = $_POST['txtUsername'];
$_SESSION["g_ownerpassword"] = $_POST['txtPassword'];
$bInsertLastLogin = true;
}
else $bInsertLastLogin = false;
if ( $_SESSION["g_ownerusername"] != "" ) {
$g_ownerusername = $_SESSION["g_ownerusername"];
$g_ownerpassword = $_SESSION["g_ownerpassword"];
}
else header("Location: /point/");
session_write_close();
include("serverside/gbvar.php");
$ip_post = $_SERVER['REMOTE_ADDR'];
$con = mysql_connect($db_host, $db_user, $db_pass) or die('Could not connect: ' . mysql_error());
mysql_select_db($db_name, $con) or die('Could not select database');
mysql_query("SET NAMES 'utf8'"); // เพื่อให้แสดงข้อมูลภาษาไทยจาก db ได้บนเวบ , ถ้าไม่ทำคำสั่งนี้ก่อน ตัวหนังสือไทยจะกลายเป็น ?????? ( ชัวร์ )
//---------------------- Check username & password then get ownerid
$query = "SELECT * FROM users WHERE username = '$g_ownerusername' && password = '$g_ownerpassword' LIMIT 1 ";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
if ( mysql_num_rows($result) != 0 ) {
while($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$g_ownerid = $row['id']; // 3 = surininspire
$g_com_name = $row['com_name'];
$sql="select * from users where id='$g_ownerid'";
$querycheck=mysql_query($sql) or die ("cannot query".mysql_error());
$result1=mysql_fetch_array($querycheck);
if($g_ownerid==0)
{
$lon = 103.50409;
$lat = 14.88278;
}
else
{
$lon=$result1['last_lon'];
$lat=$result1['last_lat'];
}
}
}
else {
?>
<SCRIPT LANGUAGE="JavaScript">
alert("ชื่อผู้ใช้และรหัสผ่านไม่ถูกต้อง กรุณากรอกใหม่อีกครั้ง")
</script>
<?
echo"<meta http-equiv='refresh' content='0;url=index.php'>";
return;
}
//-------------------- Get Cars detail
if ( $g_ownerid == 0) $query = "SELECT * FROM cars"; // ถ้าเป็น admin ให้แสดงรถทุกคัน
else $query = "SELECT * FROM cars WHERE user_id = '$g_ownerid'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$arr = array();
if ( mysql_num_rows($result) != 0 ) {
$arr_users = array ();
while($row = mysql_fetch_array($result, MYSQL_BOTH)) { // http://php.net/manual/en/function.mysql-fetch-array.php
array_push($arr_users, array("id" => $row['id'], "username" => $row['username'], "device_id" => $row['device_id'], "product_build_update" => $row['product_build_update'], "car_name" => $row['car_name'], "car_picture_filename" => $row['car_picture_filename'], "detail" => $row['detail'])); // http://www.php.net/manual/en/function.array-push.php
}
}
else {
?>
<SCRIPT LANGUAGE="JavaScript">
alert("ท่านยังไม่มี GPS ติดตั้งในรถ กรุณาติดต่อบริษัท")
</script>
<?
echo"<meta http-equiv='refresh' content='0;url=index.php'>";
return;
}
$query1 = "SELECT * FROM mark WHERE user_id = '$g_ownerid'";
$result1= mysql_query($query1) or die('Query failed: ' . mysql_error());
$arr_mark = array ();
while($row1 = mysql_fetch_array($result1, MYSQL_BOTH)) {
array_push($arr_mark, array("m_id" => $row1['id'], "m_user_id" => $row1['user_id'], "m_date" => $row1['m_date'], "m_lon" => $row1['lon'], "m_lat" => $row1['lat'], "m_detail" => $row1['detail']));
}
if ( $bInsertLastLogin == true ) {
//---------------------- update count_login + 1
mysql_query("UPDATE users SET count_login = count_login + 1 WHERE id = '$g_ownerid' ") or die('Query failed: ' . mysql_error());
//---------------------- insert users_log
$query = "INSERT INTO users_log(dt_log, username, doing, value, ip ) VALUES (now(), '$g_ownerusername', 'login_web', 'success', '$ip_post')";
mysql_query($query) or die('Query failed: ' . mysql_error());
}
//-----showmark-----
$sql1="select * from mark where user_id='$g_ownerid'";
$query1=mysql_query($sql1)or die ("can not select".mysql_error());
$num1=mysql_num_rows($query1);
mysql_free_result($result);
mysql_close($con);
?>
<script src="http://openlayers.org/api/OpenLayers.js" type="text/javascript"></script>
<link rel="stylesheet" href="http://openlayers.org/dev/theme/default/style.css" type="text/css">
<link rel="stylesheet" href="http://openlayers.org/dev/examples/style.css" type="text/css">
<script type="text/javascript">
var a;
var g_lonStart=<?=$lon?>;
var g_latStart =<?=$lat?>;
var g_zoomStart = 14;
var g_map, g_markers, g_layer_trace , g_point_car , g_line_car, g_marker_get;
var g_cookie_fbid = "";
var g_line_oldpoint; // keep last position for draw line
// http://dev.openlayers.org/apidocs/files/OpenLayers/Feature/Vector-js.html
var g_style_blue = OpenLayers.Util.extend({}, OpenLayers.Feature.Vector.style['default']);
g_style_blue.strokeColor = "#C1C2FF";
g_style_blue.fillColor = "#C1C2FF";
g_style_blue.fillOpacity = 0;
g_style_blue.strokeOpacity = 0.4;
var g_style_green = {
strokeColor: "#339933",
strokeOpacity: 1,
strokeWidth: 3,
pointRadius: 6,
pointerEvents: "visiblePainted"
};
var g_style_red1 = {
strokeColor: "#FF0000",
strokeOpacity: 1,
strokeWidth: 3,
pointRadius: 6,
pointerEvents: "visiblePainted"
};
var g_style_red = {
strokeColor: "#ff0000",
strokeOpacity: 50,
strokeWidth: 3,
pointRadius: 6,
};
function init() {
g_map = new OpenLayers.Map( 'g_map' );
var gmap = new OpenLayers.Layer.Google("Google Streets",{numZoomLevels: 22});
var gsat = new OpenLayers.Layer.Google("Google Satellite",{type: G_SATELLITE_MAP, numZoomLevels: 22});
var ghyb = new OpenLayers.Layer.Google("Google Hybrid",{type: G_HYBRID_MAP, numZoomLevels: 22});
g_layer_trace = new OpenLayers.Layer.Vector("เส้นทางเดินรถ");
g_markers = new OpenLayers.Layer.Markers("รถ");
g_map.addLayers([gmap, gsat, ghyb, g_layer_trace, g_markers]);
g_map.setCenter(new OpenLayers.LonLat(g_lonStart, g_latStart), g_zoomStart);
g_map.addControl(new OpenLayers.Control.PanZoomBar());
g_map.addControl(new OpenLayers.Control.LayerSwitcher());
g_map.addControl(new OpenLayers.Control.Permalink());
g_map.addControl(new OpenLayers.Control.MousePosition());
g_map.addControl(new OpenLayers.Control.KeyboardDefaults());
g_map.events.register("mouseup", g_map, function(e) {
var pixel = this.events.getMousePosition(e);
var lonlat = g_map.getLonLatFromPixel(pixel);
lonlatGCS = lonlat.transform(new OpenLayers.Projection("EPSG:31258"),new OpenLayers.Projection("EPSG:4326"));
OpenLayers.Util.getElement("coords").innerHTML = lonlatGCS;
document.getElementById("lon").value = lonlatGCS.lon;
document.getElementById("lat").value = lonlatGCS.lat;
});
var markers = new OpenLayers.Layer.Markers( "บริษัท สุรินทร์อินสไปร์ จำกัด" );
g_map.addLayer(markers);
var size = new OpenLayers.Size(21,25);
var offset = new OpenLayers.Pixel(-(size.w/2), -size.h);
var icon = new OpenLayers.Icon('./images/tata.png',size,offset);
markers.addMarker(new OpenLayers.Marker(new OpenLayers.LonLat(103.47423277795,14.889803999976),icon));
markers.id = "บริษัท สุรินทร์อินสไปร์ จำกัด ตัวแทนจำหน่ายรถยนต์ ทาทา มอเตอร์ส จ.สุรินทร์";
markers.events.register("mousedown", markers, function() {
alert(this.id);
});
var markers1 = new OpenLayers.Layer.Markers( "Markers" );
g_map.addLayer(markers1);
var markdetail = new OpenLayers.Layer.Markers( "รายละเอียด" );
g_map.addLayer(markdetail);
markdetail.setVisibility(false);
<?
for($i=0;$i<$num1;$i++)
{
$result1=mysql_fetch_array($query1);
$mark_id=$result1['id'];
$lon=$result1['lon'];
$lat=$result1['lat'];
$detail=$result1['detail'];
echo "var i = '$i';";
echo "var mark_id = '$mark_id';";
?>
var lon=<?=$lon?>;
var lat=<?=$lat?>;
var size = new OpenLayers.Size(21,25);
var size1 = new OpenLayers.Size(100,50);
var offset = new OpenLayers.Pixel(-(size.w/2), -size.h);
var icon = new OpenLayers.Icon('./images/talk.png',size,offset);
var icon1 = new OpenLayers.Icon('./images/mark/'+mark_id+'.png',size1,offset);
markdetail.addMarker(new OpenLayers.Marker(new OpenLayers.LonLat(lon,lat),icon1));
markers1.addMarker(new OpenLayers.Marker(new OpenLayers.LonLat(lon,lat),icon));
<?
}
?>
g_map.events.register("mousemove", g_map, function(e1) {
var pixel1 = this.events.getMousePosition(e1);
var lonlat1 = g_map.getLonLatFromPixel(pixel1);
lonlatGCS1 = lonlat1.transform(new OpenLayers.Projection("EPSG:31258"),new OpenLayers.Projection("EPSG:4326"));
OpenLayers.Util.getElement("coords1").innerHTML = lonlatGCS1;
document.getElementById("lon1").value = lonlatGCS1.lon;
document.getElementById("lat1").value = lonlatGCS1.lat;
});
markers1.events.register("mousedown", markers1, function() {
var user=<?=$g_ownerid?>;
var sent='selectmark.php?user_id='+ user +'&lon='+lonlatGCS1.lon+'&lat='+lonlatGCS1.lat+jQuery.now();
$(function(){
$.getJSON(sent,function(data){
alert("Hello");
});
});
alert("HELLO");
});
}
window.onload = function() {
init();
}
$(document).ready(function() {
<?
for ($i = 0; $i < sizeof($arr_users) ; $i++) {
?>
g_line_oldpoint = new Array() ;
g_line_oldpoint[<? echo($arr_users[$i]['id']); ?>] = null;
g_marker_get = new Array();
g_marker_get[<? echo($arr_users[$i]['id']); ?>] = null;
setInterval(function(){refreshMarkers( <? echo($arr_users[$i]['id']); ?>);}, 5000);
<?
}
?>
});
function addMarkers(intCarID) {
var strGetInfoPage = './serverside/point_avr_get.php?qtype=realtime&car_id=' + intCarID + '&' + jQuery.now();
$.getJSON( strGetInfoPage, function(data) {
try {
var lon_last, lat_last, car_picture_last;
//วนลูปแสดงข้อมูล
$.each(data.cars, function(i, item) {
$('#lblastupdate'+intCarID).html(item.point_dt_post);
$('#lbspeed'+intCarID).html(item.point_gps_speed);
var newpoint = new OpenLayers.Geometry.Point(item.point_gps_lon, item.point_gps_lat);
var point_gps_speed=parseFloat(item.point_gps_speed);
var car_limit_speed=parseFloat(item.car_limit_speed);
if(point_gps_speed=='0')
{
g_style=g_style_red;
g_style_line=g_style_green;
$('#images'+intCarID).html("<img src='images/zero.gif' width='12' height='12'>")
}
else if(point_gps_speed==999)
{
$('#images'+intCarID).html("<img src='images/over.gif' width='12' height='12'>")
g_style=g_style_blue;
g_style_line=g_style_green;
}
else if(((car_limit_speed)<(point_gps_speed))&&(point_gps_speed!=999))
{
$('#images'+intCarID).html("<img src='images/fast.gif' width='12' height='12'>")
g_style=g_style_blue;
g_style_line=g_style_red1;
}
else
{
g_style=g_style_blue;
g_style_line=g_style_green;
$('#images'+intCarID).html("<img src='images/low.gif' width='12' height='12'>")
}
g_point_car = new OpenLayers.Feature.Vector(newpoint, null, g_style,"http://www.surinrobot.com");
var newPointList = [];
if ( g_line_oldpoint[intCarID] != null ) newPointList.push(g_line_oldpoint[intCarID]);
newPointList.push(newpoint);
g_line_oldpoint[intCarID] = newpoint;
g_line_car = new OpenLayers.Feature.Vector(new OpenLayers.Geometry.LineString(newPointList),null,g_style_line);
g_layer_trace.addFeatures([g_point_car, g_line_car]);
lon_last = item.point_gps_lon;
lat_last = item.point_gps_lat;
car_picture_last = item.car_picture_filename;
car_platnumber = item.id;
});
if ( g_marker_get[intCarID] != null ) g_markers.removeMarker(g_marker_get[intCarID]);
var lonlat_get = new OpenLayers.LonLat(lon_last , lat_last);
if(document.form1.hdshow.value=='plat'){
var pic_get = './images/car_plat/' + car_platnumber +'.png';
var sz = new OpenLayers.Size(65, 40);
}
else{
var pic_get = './images/car_picture/' + car_picture_last;
var sz = new OpenLayers.Size(34, 25);
}
var calculateOffset = function(size) { return new OpenLayers.Pixel(-(size.w/2), -size.h); };
var icon_get = new OpenLayers.Icon(pic_get, sz, null, calculateOffset);
g_marker_get[intCarID] = new OpenLayers.Marker(lonlat_get, icon_get);
g_markers.addMarker(g_marker_get[intCarID]);
//check(intCarID);
if ( $('input[value=followcar'+intCarID+']').is(':checked') ) g_map.setCenter(new OpenLayers.LonLat(lon_last, lat_last));
}
catch(err) {
//alert("not found"+ err);
}
});
}
function delMarkers(intCarID) {
}
function refreshMarkers(intCarID) {
delMarkers(intCarID);
addMarkers(intCarID);
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div id="stage"></div>
<form id="frmPost" action="logout.php" method="POST" name="frmPost">
<input type=hidden id='fb_id' name='fb_id' value=''>
<input type=hidden id='latclick' name='latclick' value=''>
<input type=hidden id='lonclick' name='lonclick' value=''>
<input type="text" name="lon" id="lon">
<input type="text" name="lat" id="lat">
<input type="text" name="lon1" id="lon1">
<input type="text" name="lat1" id="lat1">
<input type="hidden" name="latnew" id="latnew" value="<? echo $lat ?>">
<input type="hidden" name="lonnew" id="lonnew" value="<? echo $lon ?>">
<input type="hidden" name="id" id="id" value="<? echo $g_ownerid ?>">
</form>
<div align=center><img src=../images/logo_surinrobot_point_w150.png border=0></div>
<div align=center class='font_TH13'><b><a class=nounderline href=./map.php>Realtime tracking</a> | <a class=nounderline href=map_history.php>History tracking</a></b></div><br>
<table width="100%" height="10" border="1" align="center"><tr><td width="20%"></td><td width="72%">
</td><td width="8%" align="right"
</td></tr></table>
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="2" border="1">
<td width="20%" height="100%" align="left" valign="top">
<table width="100%" border="1" cellspacing="2" cellpadding="4">
<tr>
<td class='font_TH13' valign="top">
<?
$con = mysql_connect($db_host, $db_user, $db_pass) or die('Could not connect: ' . mysql_error());
mysql_select_db($db_name, $con) or die('Could not select database');
mysql_query("SET NAMES 'utf8'"); // เพื่อให้แสดงข้อมูลภาษาไทยจาก db ได้บนเวบ , ถ้าไม่ทำคำสั่งนี้ก่อน ตัวหนังสือไทยจะกลายเป็น ?????? ( ชัวร์ )
//-------------------- Get Last Login
$query = "SELECT * FROM users_log WHERE username = '$g_ownerusername' ORDER BY roworder DESC LIMIT 1,1"; // LIMIT 1,1 คือการเลือก 1 ตัว โดยข้ามตัวแรกไป ( เริ่มที่ตัวที่ 2 )
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
if ( mysql_num_rows($result) != 0 ) {
$row = mysql_fetch_array($result, MYSQL_BOTH); // http://php.net/manual/en/function.mysql-fetch-array.php
$strLastLogin = $row['dt_log'];
}
mysql_free_result($result);
mysql_close($con);
?>
ชื่อ : <? echo($g_com_name); ?>
<?
echo "<a href='edit_information.php?id=$g_ownerid'><font size='2' color='2a61db'>[แก้ไข]</font></a>";
?>
<br>ติดตามรถ : <? echo(sizeof($arr_users)); ?> คัน
<br>ล็อคอินครั้งล่าสุด : <? echo("$strLastLogin"); ?>
<?
//print_r($arr_users);
for ($i = 0; $i < sizeof($arr_users); $i++) {
?>
<br><br><a id='images'></a><input type=radio id=followcar<?echo($arr_users[$i]["id"]);?> name=followcar value=followcar<? echo($arr_users[$i]["id"]); ?>>
<?
if ($g_ownerid == 0) { // ถ้าเป็น admin login เข้ามาดู ให้แสดงข้อมูลรถแต่ละคันเพิ่มเติม
echo('[ ' . $arr_users[$i]["username"] . ' - ' . $arr_users[$i]["device_id"] . ' - Build ' . $arr_users[$i]["product_build_update"] . ' - <font color=#32B749>' . $arr_users[$i]["detail"] . '</font> ]<br>');
}
$new=($arr_users[$i]["id"] );
?>
<font color=blue><?echo($arr_users[$i]["car_name"]);?></font>
<?
echo "<a href='edit_cars.php?id=$new'><font size='2' color='2a61db'>[แก้ไข]</font></a>";
?>
<br>ส่งพิกัดล่าสุด <font color=#32B749><span id=lblastupdate<? echo ($arr_users[$i]["id"]);?>></span></font>
<br>ความเร็ว <font color=#32B749><span id=lbspeed<? echo($arr_users[$i]["id"]);?>></span></font> กม./ชม.
<script language="javascript">
</script>
<span id=images<? echo($arr_users[$i]["id"]);?>></span>
<?
}
?>
<br><br>
<table width="200">
<tr><td><img src="images/fast.gif" width="12" height="12">=>ความเร็วเกินกำหนด</td></tr>
<tr><td><img src="images/low.gif" width="12" height="12">=>ความเร็วปกติ</td></tr>
<tr><td><img src="images/over.gif" width="12" height="12">=>อยู่ในเขตอับสัญญาน</td></tr>
</table>
</td>
</tr>
</table>
</td>
<td width="80%" height="100%" align="right"><table width="100%" border="1"><tr><td width="88%">
<form action="map.php" method="POST" name="form1" id="form1" >
<b>มุมมอง</b>
<input type="hidden" id='hdshow' naem='hdshow' value="">
<select name='show' id='show' onChange="document.form1.hdshow.value=document.form1.show.value">
<option value="picture">รูปรถ</option>
<option value="plat" >ป้ายทะเบียน</option>
</select>
</td><td align="right" width="12%">
</form>
<img src="images/logout.png" width="100" height="30" OnClick="javascript:if(confirm('คูณต้องการออกจากระบบใช่หรอไม่')==true){document.frmPost.submit();}" title="ออกจากระบบ" >
</td></tr></table>
<div style="width:100%; height:100%" id="g_map"></div>
<div id="coords"></div>
<font color="#FFFFFF"><span id="coords1"></span></font>
</td>
</tr>
</table>
<br>
<!--</div>-->
</body>
</html>
นี่นะคะ โค๊ดทั้งหมด ตัวที่มีปัญหาคือ GetJson ตัวแรกค่ะ
|
| |
|
|
| |
| Date :
2012-04-26 14:18:16 |
By :
tai_kook |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
markers1.events.register("mousedown", markers1, function() {
var user=<?=$g_ownerid?>;
var sent='selectmark.php?user_id='+ user +'&lon='+lonlatGCS1.lon+'&lat='+lonlatGCS1.lat+jQuery.now();
$(function(){
$.getJSON(sent,function(data){
alert("Hello");
});
});
alert("HELLO");
});
ตัวที่มีปัญหานะคะ กลัวหาไม่เจอ โค๊ดเยอะมาก
|
| |
|
|
| |
| Date :
2012-04-26 14:19:21 |
By :
tai_kook |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
