JSON PHP中返回JSON数据(多个JSON通过一个大的数组组合成一个JSON字符串)，在客户端解析JSON数据减轻服务端压力
data.php（服务端通过一个大的索引数组拼装多个JSON数据成一个大的JSON字符串，只能返回这一个大的JSON字符串）:
<?php
header("content-type:text/html;charset=utf-8");
//实现传统分页效果
//连接数据库、获得数据、分页显示
$link = mysql_connect("localhost","root","123456");
mysql_select_db("shop0811", $link);
mysql_query("set names utf8");
//数据分页实现
//① 引入分页工具类
include("./page.class.php");
//② 获得记录总条数/每页显示条数设置
$sql = "select * from sw_goods";
$qry = mysql_query($sql);
$cnt = mysql_num_rows($qry); //数据总条数
$per = 7;//每页显示7条
//③ 实例化分页类对象
$page_obj = new Page($cnt, $per);
//④ 拼装sql语句，获得每页信息
$sql3 = "select goods_name n,goods_price p,goods_number m,goods_weight w from sw_goods ".$page_obj->limit;
$qry3 = mysql_query($sql3);
//⑤ 获得页码列表
$pagelist = $page_obj -> fpage(array(3,4,5,6,7,8));
$p = isset($_GET["page"])?$_GET["page"]:1;
$i = ($p-1)*$per+1; //(页码-1)*每页条数+1
$info = array();//声明一个数组，最终把全部数据都集中在此数组里边
while($rst3 = mysql_fetch_assoc($qry3)){
$rst3["xu"] = $i++;
$info[] = $rst3; //通过$info[]索引数组拼装JSON数据。
}
$info[] = $pagelist;//页面列表。通过$info[]索引数组拼装多个JSON数据。$info[]是索引数组，在PHP中索引数组会序列化成JavaScript的数组-->[{第一条数据},{第二条数据},{第三条数据},"pageList字符串"]
echo json_encode($info);
//把全部数据通过json格式提供出来
//json_encode()只允许使用一次
//这就要求把提供的信息组织为一个大的数组
index.html（浏览器端解析大的JSON数据，减轻服务端压力）:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>新建网页</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<script type="text/javascript">
//通过ajax获得分页信息
function showpage(url){
var xhr = new XMLHttpRequest();
xhr.onreadystatechange = function(){
if(xhr.readyState==4){
eval("var jn_info="+xhr.responseText); //eval函数将字符串当成代码来执行(去掉两端的引号)（PHP索引数组的JSON字符串-->JavaScript数组(jn_info)）
//遍历二维信息
var s = "<table><tr><td>序号</td><td>名称</td><td>价格</td><td>数量</td><td>重量</td></tr>";
for(var i=0; i<jn_info.length-1; i++){ //length-1是因为大的数组中的最后一个元素是一个pageList字符串。
jn_info[i]
s += "<tr>";
s += "<td>"+jn_info[i].xu+"</td>";
s += "<td>"+jn_info[i].n+"</td>";
s += "<td>"+jn_info[i].p+"</td>";
s += "<td>"+jn_info[i].m+"</td>";
s += "<td>"+jn_info[i].w+"</td>";
s += "</tr>";
}
s += "<tr><td colspan="5">"+jn_info[jn_info.length-1]+"</td></tr>"; //jn_info[jn_info.length-1] 数组中的最后一个元素是pageList字符串。
s += "</table>";
//把获得服务器JSON信息显示到id=result的div里边
document.getElementById("result").innerHTML = s;
}
}
xhr.open("get",url);
xhr.send(null);
}
//页面加载完毕就获得一次分页信息
window.onload = function(){
showpage("./data.php?page=1");
}
</script>
<style type="text/css">
h2 {width:700px;margin:auto;text-align:center;}
table {width:700px; margin:auto;border:1px solid black; border-collapse:collapse;}
td {border:1px solid black;}
</style>
</head>
<body>
<h2>Ajax无刷新分页效果</h2>
<div id="result"></div>
</body>
</html>
<script type="text/javascript">
document.write(new Date()+"<br />");
document.write(new Date()+"<br />");
document.write(new Date()+"<br />");
document.write(new Date()+"<br />");
</script>
page.class.php（Ajax无刷新分页工具类）:<?php
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array("header"=>"个记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首 页", "last"=>"尾 页");
private $listNum=8;
/*
* $total
* $listRows
*/
public function __construct($total, $listRows=10, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
}
private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
}
private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], "?")?"":"?").$pa;
$parse=parse_url($url);
if(isset($parse["query"])){
parse_str($parse["query"],$params);
unset($params["page"]);
$url=$parse["path"]."?".http_build_query($params);
}
return $url;
}
function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
}
private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
}
private function end(){
return min($this->page*$this->listRows,$this->total);
}
private function first(){
$html = "";
if($this->page==1)
$html.="";
else
$html.=" <a href="javascript:showpage("{$this->uri}&page=1")">{$this->config["first"]}</a> ";
return $html;
}
private function prev(){
$html = "";
if($this->page==1)
$html.="";
else
$html.=" <a href="javascript:showpage("{$this->uri}&page=".($this->page-1)."")">{$this->config["prev"]}</a> ";
return $html;
}
private function pageList(){
$linkPage="";
$inum=floor($this->listNum/2);
for($i=$inum; $i>=1; $i--){
$page=$this->page-$i;
if($page<1)
continue;
//$linkPage.=" <a href="{$this->uri}&page={$page}">{$page}</a> ";
$linkPage.=" <a href="javascript:showpage("{$this->uri}&page={$page}")">{$page}</a> ";
}
$linkPage.=" {$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum){
//$linkPage.=" <a href="{$this->uri}&page={$page}">{$page}</a> ";
$linkPage.=" <a href="javascript:showpage("{$this->uri}&page={$page}")">{$page}</a> ";
}else{
break;
}
}
return $linkPage;
}
private function next(){
$html = "";
if($this->page==$this->pageNum)
$html.="";
else
$html.=" <a href="javascript:showpage("{$this->uri}&page=".($this->page+1)."")">{$this->config["next"]}</a> ";
return $html;
}
private function last(){
$html = "";
if($this->page==$this->pageNum)
$html.="";
else
$html.=" <a href="javascript:showpage("{$this->uri}&page=".($this->pageNum)."")">{$this->config["last"]}</a> ";
return $html;
}
private function goPage(){
return " <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>".$this->pageNum.")?".$this->pageNum.":this.value;showpage("".$this->uri."&page="+page+"")}" value="".$this->page."" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>".$this->pageNum.")?".$this->pageNum.":this.previousSibling.value;showpage("".$this->uri."&page="+page+"")"> ";
//return " <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>".$this->pageNum.")?".$this->pageNum.":this.value;location="".$this->uri."&page="+page+""}" value="".$this->page."" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>".$this->pageNum.")?".$this->pageNum.":this.previousSibling.value;location="".$this->uri."&page="+page+"""> ";
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]=" 共有<b>{$this->total}</b>{$this->config["header"]} ";
$html[1]=" 每页显示<b>".($this->end()-$this->start()+1)."</b>条，本页<b>{$this->start()}-{$this->end()}</b>条 ";
$html[2]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage="";
foreach($display as $index){
$fpage.=$html[$index];
}
return $fpage;
}
}
声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。
