資訊專欄INFORMATION COLUMN
摘要：信息列表循環(huán)賦值分頁(yè)信息部分這一步是實(shí)現(xiàn)無(wú)刷新分頁(yè)的重點(diǎn)，用到了的通信，通過(guò)與數(shù)據(jù)庫(kù)的交互，將獲取到的數(shù)據(jù)寫(xiě)到模板中，替換掉之前的數(shù)據(jù)集，達(dá)到分頁(yè)的目的。
前言
thinkphp框架自帶的分頁(yè)類是每次翻頁(yè)都要刷新一下整個(gè)頁(yè)面，這種翻頁(yè)的用戶體驗(yàn)顯然是不太理想的，我們希望每次翻頁(yè)只刷新我們想要的數(shù)據(jù)集部分的數(shù)據(jù)，這樣我們很容易想到ajax異步通信，用ajax與數(shù)據(jù)庫(kù)（本人在開(kāi)發(fā)過(guò)程中使用的是mysql數(shù)據(jù)庫(kù)）異步交互，將從數(shù)據(jù)庫(kù)查詢的數(shù)據(jù)返回，用jquery替換原有的數(shù)據(jù),從而在不刷新這個(gè)頁(yè)面的情況下進(jìn)行局部刷新，從而達(dá)到我們預(yù)期的效果。
thinkphp ajax 分頁(yè)類這個(gè)分頁(yè)類是網(wǎng)上找到的資源，大家可以直接在自己的thinkphp里創(chuàng)建這么一個(gè)類，我這里類名是 AjaxPage.class.php
// +----------------------------------------------------------------------
// $Id: Page.class.php 2712 2012-02-06 10:12:49Z liu21st $
namespace CommonCommon;
class AjaxPage {
// 分頁(yè)欄每頁(yè)顯示的頁(yè)數(shù)
public $rollPage = 5;
// 頁(yè)數(shù)跳轉(zhuǎn)時(shí)要帶的參數(shù)
public $parameter ;
// 默認(rèn)列表每頁(yè)顯示行數(shù)
public $listRows = 20;
// 起始行數(shù)
public $firstRow ;
// 分頁(yè)總頁(yè)面數(shù)
protected $totalPages ;
// 總行數(shù)
protected $totalRows ;
// 當(dāng)前頁(yè)數(shù)
protected $nowPage ;
// 分頁(yè)的欄的總頁(yè)數(shù)
protected $coolPages ;
// 分頁(yè)顯示定制
protected $config = array("header"=>"條記錄","prev"=>"上一頁(yè)","next"=>"下一頁(yè)","first"=>"第一頁(yè)","last"=>"最后一頁(yè)","theme"=>" %totalRow% %header% %nowPage%/%totalPage% 頁(yè) %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%");
// 默認(rèn)分頁(yè)變量名
protected $varPage;
public function __construct($totalRows,$listRows="",$ajax_func,$parameter="") {
$this->totalRows = $totalRows;
$this->ajax_func = $ajax_func;
$this->parameter = $parameter;
$this->varPage = C("VAR_PAGE") ? C("VAR_PAGE") : "p" ;
if(!empty($listRows)) {
$this->listRows = intval($listRows);
}
$this->totalPages = ceil($this->totalRows/$this->listRows); //總頁(yè)數(shù)
$this->coolPages = ceil($this->totalPages/$this->rollPage);
$this->nowPage = !empty($_GET[$this->varPage])?intval($_GET[$this->varPage]):1;
if(!empty($this->totalPages) && $this->nowPage>$this->totalPages) {
$this->nowPage = $this->totalPages;
}
$this->firstRow = $this->listRows*($this->nowPage-1);
}
public function nowpage($totalRows,$listRows="",$ajax_func,$parameter="") {
$this->totalRows = $totalRows;
$this->ajax_func = $ajax_func;
$this->parameter = $parameter;
$this->varPage = C("VAR_PAGE") ? C("VAR_PAGE") : "p" ;
if(!empty($listRows)) {
$this->listRows = intval($listRows);
}
$this->totalPages = ceil($this->totalRows/$this->listRows); //總頁(yè)數(shù)
$this->coolPages = ceil($this->totalPages/$this->rollPage);
$this->nowPage = !empty($_GET[$this->varPage])?intval($_GET[$this->varPage]):1;
if(!empty($this->totalPages) && $this->nowPage>$this->totalPages) {
$this->nowPage = $this->totalPages;
}
$this->firstRow = $this->listRows*($this->nowPage-1);
return $this->nowPage;
}
public function setConfig($name,$value) {
if(isset($this->config[$name])) {
$this->config[$name] = $value;
}
}
public function show() {
if(0 == $this->totalRows) return "";
$p = $this->varPage;
$nowCoolPage = ceil($this->nowPage/$this->rollPage);
$url = $_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"],"?")?"":"?").$this->parameter;
$parse = parse_url($url);
if(isset($parse["query"])) {
parse_str($parse["query"],$params);
unset($params[$p]);
$url = $parse["path"]."?".http_build_query($params);
}
//上下翻頁(yè)字符串
$upRow = $this->nowPage-1;
$downRow = $this->nowPage+1;
if ($upRow>0){
$upPage="ajax_func."(".$upRow.")">".$this->config["prev"]."";
}else{
$upPage="";
}
if ($downRow <= $this->totalPages){
$downPage="ajax_func."(".$downRow.")">".$this->config["next"]."";
}else{
$downPage="";
}
// << < > >>
if($nowCoolPage == 1){
$theFirst = "";
$prePage = "";
}else{
$preRow = $this->nowPage-$this->rollPage;
$prePage = "ajax_func."(".$preRow.")">上".$this->rollPage."頁(yè)";
$theFirst = "ajax_func."(1)" >".$this->config["first"]."";
}
if($nowCoolPage == $this->coolPages){
$nextPage = "";
$theEnd="";
}else{
$nextRow = $this->nowPage+$this->rollPage;
$theEndRow = $this->totalPages;
$nextPage = "ajax_func."(".$nextRow.")" >下".$this->rollPage."頁(yè)";
$theEnd = "ajax_func."(".$theEndRow.")" >".$this->config["last"]."";
}
// 1 2 3 4 5
$linkPage = "";
for($i=1;$i<=$this->rollPage;$i++){
$page=($nowCoolPage-1)*$this->rollPage+$i;
if($page!=$this->nowPage){
if($page<=$this->totalPages){
$linkPage .= " ajax_func."(".$page.")"> ".$page." ";
}else{
break;
}
}else{
if($this->totalPages != 1){
$linkPage .= " ".$page."";
}
}
}
$pageStr = str_replace(
array("%header%","%nowPage%","%totalRow%","%totalPage%","%upPage%","%downPage%","%first%","%prePage%","%linkPage%","%nextPage%","%end%"),
array($this->config["header"],$this->nowPage,$this->totalRows,$this->totalPages,$upPage,$downPage,$theFirst,$prePage,$linkPage,$nextPage,$theEnd),$this->config["theme"]);
return $pageStr;
}
}
?>
具體步驟
接下來(lái)，我們從控制器開(kāi)始一步一步地實(shí)現(xiàn)thinkphp無(wú)刷新分頁(yè)這個(gè)效果。
1.控制器部分這只是控制器的一部分比較核心的代碼。
//實(shí)例化數(shù)據(jù)模型
$info=M("info");
//統(tǒng)計(jì)要查詢數(shù)據(jù)的數(shù)量
$count=$info->where("ID="$id"")->count();
//實(shí)例化分頁(yè)類，傳入三個(gè)參數(shù)，分別是數(shù)據(jù)總數(shù)、每頁(yè)顯示的數(shù)據(jù)條數(shù)、要調(diào)用的jQuery ajax方法名
$p=new HostCommonAjaxPage($count,10,"server");
//產(chǎn)生分頁(yè)信息
$page=$p->show();
//要查詢的數(shù)據(jù),limit表示每頁(yè)查詢的數(shù)量，這里為10條
$data = $server_info->where("ID="$id"")->limit($p->firstRow.",".$p->listRows)->select();
//assign方法往模板賦值
$this->assign("list",$data);
$this->assign("page",$page);
//ajax返回信息
$res["content"] = $this->fetch("Index/myinfolist")
$this->ajaxReturn($res);
2.模板部分
模板名：myinfolist.html與上面控制器中渲染的模板一致。
$res["content"] = $this->fetch("Index/myinfolist")
因?yàn)榍岸擞玫腷ootstrap框架，所以這個(gè)模板里的好多class是bootstrap里的，大家也不必過(guò)分糾結(jié)這個(gè)，看整個(gè)過(guò)程的重點(diǎn)就好。
信息列表
a
b
c
d
//循環(huán)賦值
{$info.a}
{$info.b}
{$info.c}
{$info.d}
//分頁(yè)信息
{$page}