摘要:信息列表循環賦值分頁信息部分這一步是實現無刷新分頁的重點,用到了的通信,通過與數據庫的交互,將獲取到的數據寫到模板中,替換掉之前的數據集,達到分頁的目的。
前言
thinkphp框架自帶的分頁類是每次翻頁都要刷新一下整個頁面,這種翻頁的用戶體驗顯然是不太理想的,我們希望每次翻頁只刷新我們想要的數據集部分的數據,這樣我們很容易想到ajax異步通信,用ajax與數據庫(本人在開發過程中使用的是mysql數據庫)異步交互,將從數據庫查詢的數據返回,用jquery替換原有的數據,從而在不刷新這個頁面的情況下進行局部刷新,從而達到我們預期的效果。
thinkphp ajax 分頁類這個分頁類是網上找到的資源,大家可以直接在自己的thinkphp里創建這么一個類,我這里類名是 AjaxPage.class.php
// +---------------------------------------------------------------------- // $Id: Page.class.php 2712 2012-02-06 10:12:49Z liu21st $ namespace CommonCommon; class AjaxPage { // 分頁欄每頁顯示的頁數 public $rollPage = 5; // 頁數跳轉時要帶的參數 public $parameter ; // 默認列表每頁顯示行數 public $listRows = 20; // 起始行數 public $firstRow ; // 分頁總頁面數 protected $totalPages ; // 總行數 protected $totalRows ; // 當前頁數 protected $nowPage ; // 分頁的欄的總頁數 protected $coolPages ; // 分頁顯示定制 protected $config = array("header"=>"條記錄","prev"=>"上一頁","next"=>"下一頁","first"=>"第一頁","last"=>"最后一頁","theme"=>" %totalRow% %header% %nowPage%/%totalPage% 頁 %upPage% %downPage% %first% %prePage% %linkPage% %nextPage% %end%"); // 默認分頁變量名 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); //總頁數 $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); //總頁數 $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); } //上下翻頁字符串 $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."頁"; $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."頁"; $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; } } ?>具體步驟
接下來,我們從控制器開始一步一步地實現thinkphp無刷新分頁這個效果。
1.控制器部分這只是控制器的一部分比較核心的代碼。
//實例化數據模型 $info=M("info"); //統計要查詢數據的數量 $count=$info->where("ID="$id"")->count(); //實例化分頁類,傳入三個參數,分別是數據總數、每頁顯示的數據條數、要調用的jQuery ajax方法名 $p=new HostCommonAjaxPage($count,10,"server"); //產生分頁信息 $page=$p->show(); //要查詢的數據,limit表示每頁查詢的數量,這里為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")
因為前端用的bootstrap框架,所以這個模板里的好多class是bootstrap里的,大家也不必過分糾結這個,看整個過程的重點就好。
//分頁信息
//循環賦值 a b c d {$info.a} {$info.b} {$info.c} {$info.d} {$page}