Maison >développement back-end >tutoriel php >javascript - js用json调用php并显示返回值
图片1是一个接送记录,图片2是这个记录的一个接口,怎么用js调用这个php然后在网页上显示那些返回值,怎么弄的,php中的代码也附上了。
<code><?php require('../../../incode/user_fns.php'); function __autoload($class_name) { require_once '../../../incode/'.$class_name.'.php'; } if (isset($_COOKIE['userid'])) { $userid = intval(trim($_COOKIE['userid'])); } else { error_exit(ENOPOST); } if (isset($_COOKIE['token'])) { $usertoken = trim($_COOKIE['token']); } else { error_exit(ENOPOST); } if (!$usertoken || !$userid) { error_exit(ENOPOST); } if (isset($_POST['year'])) { $year = intval(trim($_POST['year'])); } else { error_exit(ENOPOST); } if (isset($_POST['month'])) { $month = intval(trim($_POST['month'])); } else { error_exit(ENOPOST); } if (!$year || !$month) { error_exit(ENOPOST); } $page = 0; if (isset($_POST['page'])) { $page = intval(trim($_POST['page'])); } $count = 10; if (isset($_POST['pcount'])) { $count = intval(trim($_POST['pcount'])); } try{ db_connect(); $registry =& Registry::getInstance(); $conn =& $registry->get('dbconn'); if (!check_accesstoken($userid, $usertoken)) { error_exit(EUSERTOKEN); } $result = $conn->query("select bbid from user where userid=$userid"); if (!$result) { error_exit(EDBSELECT); } $row = $result->fetch_row(); if (!$row) { error_exit(EBABYNOTEXIST); } $bbid = $row[0]; $result = $conn->query("select cardid from accesscard where bbid=$bbid"); if (!$result) { error_exit(EDBSELECT); } $resultarray = array(); $starttime = strtotime("$year-$month-1"); $month++; $endtime = strtotime("$year-$month-1"); $pagestart = $page*$count; $result = $conn->query("select checkid,parent,time,status from checkin where bbid=$bbid and time>$starttime and timefetch_row()) { if (connection_aborted() || connection_status()!=CONNECTION_NORMAL) { exit; } $lasttime = $row[2]; $checkin['checkid'] = $row[0]; $checkin['parent'] = $row[1]; if (!$row[1]) { $result1 = $conn->query("select name from user a,checkin b where b.checkid='".$row[0]."' and a.userid=b.cardid"); if (!$result1) { error_exit(EDBSELECT); } $row1 = $result1->fetch_row(); if (!$row1) { continue; } $checkin['teacher'] = $row1[0]; } $checkin['time'] = $lasttime; $checkin['status'] = $row[3]; $resultarray[] = $checkin; } echo json_encode($resultarray); }catch (Exception $e) { error_exit($e->getCode()); } ?> </code>
图片1是一个接送记录,图片2是这个记录的一个接口,怎么用js调用这个php然后在网页上显示那些返回值,怎么弄的,php中的代码也附上了。
<code><?php require('../../../incode/user_fns.php'); function __autoload($class_name) { require_once '../../../incode/'.$class_name.'.php'; } if (isset($_COOKIE['userid'])) { $userid = intval(trim($_COOKIE['userid'])); } else { error_exit(ENOPOST); } if (isset($_COOKIE['token'])) { $usertoken = trim($_COOKIE['token']); } else { error_exit(ENOPOST); } if (!$usertoken || !$userid) { error_exit(ENOPOST); } if (isset($_POST['year'])) { $year = intval(trim($_POST['year'])); } else { error_exit(ENOPOST); } if (isset($_POST['month'])) { $month = intval(trim($_POST['month'])); } else { error_exit(ENOPOST); } if (!$year || !$month) { error_exit(ENOPOST); } $page = 0; if (isset($_POST['page'])) { $page = intval(trim($_POST['page'])); } $count = 10; if (isset($_POST['pcount'])) { $count = intval(trim($_POST['pcount'])); } try{ db_connect(); $registry =& Registry::getInstance(); $conn =& $registry->get('dbconn'); if (!check_accesstoken($userid, $usertoken)) { error_exit(EUSERTOKEN); } $result = $conn->query("select bbid from user where userid=$userid"); if (!$result) { error_exit(EDBSELECT); } $row = $result->fetch_row(); if (!$row) { error_exit(EBABYNOTEXIST); } $bbid = $row[0]; $result = $conn->query("select cardid from accesscard where bbid=$bbid"); if (!$result) { error_exit(EDBSELECT); } $resultarray = array(); $starttime = strtotime("$year-$month-1"); $month++; $endtime = strtotime("$year-$month-1"); $pagestart = $page*$count; $result = $conn->query("select checkid,parent,time,status from checkin where bbid=$bbid and time>$starttime and timefetch_row()) { if (connection_aborted() || connection_status()!=CONNECTION_NORMAL) { exit; } $lasttime = $row[2]; $checkin['checkid'] = $row[0]; $checkin['parent'] = $row[1]; if (!$row[1]) { $result1 = $conn->query("select name from user a,checkin b where b.checkid='".$row[0]."' and a.userid=b.cardid"); if (!$result1) { error_exit(EDBSELECT); } $row1 = $result1->fetch_row(); if (!$row1) { continue; } $checkin['teacher'] = $row1[0]; } $checkin['time'] = $lasttime; $checkin['status'] = $row[3]; $resultarray[] = $checkin; } echo json_encode($resultarray); }catch (Exception $e) { error_exit($e->getCode()); } ?> </code>
建议先看看这篇文章吧 -- json在php和js中的玩转