ThinkPHP实现分页功能

/** $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.="  uri}&page=1'>{$this->config["first"]}  ";

return $html;}

//上一页private function prev(){$html = "";if($this->page==1)$html.='';else$html.="  uri}&page=".($this->page-1)."'>{$this->config["prev"]}  ";

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.=" uri}&page={$page}'>{$page} ";

}

$linkPage.=" {$this->page} ";

for($i=1; $i<=$inum; $i++){$page=$this->page+$i;if($page<=$this->pageNum)$linkPage.=" uri}&page={$page}'>{$page} ";else break;}

return $linkPage;}

//下一页private function next(){$html = "";if($this->page==$this->pageNum)$html.='';else$html.="  uri}&page=".($this->page+1)."'>{$this->config["next"]}  ";

return $html;}

//尾页private function last(){$html = "";if($this->page==$this->pageNum)$html.='';else$html.="  uri}&page=".($this->pageNum)."'>{$this->config["last"]}  ";

return $html;}

//跳转private function goPage(){return '    ';}

//页码列表function fpage($display=array(0,1,2,3,4,5,6,7,8)){$html[0]="  共有{$this->total}{$this->config["header"]}  ";$html[1]="  每页显示".($this->end()-$this->start()+1)."条，本页{$this->start()}-{$this->end()}条  ";$html[2]="  {$this->page}/{$this->pageNum}页  ";

$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;

}

}

//实现分页效果$goods = D('goods');

//① 获得数据的总记录条数$total = $goods -> count(); //select count(*) from sw_goods;$per = 7; //每页显示7条记录

//②实例化分页类$page_obj = new \Tools\Page($total, $per);

//③自定义sql语句，获取每页信息$sql = "select * from sw_goods order by goods_id desc ".$page_obj->limit;$info = $goods->query($sql);

//④获取页码列表$pagelist = $page_obj->fpage(array(3,4,5,6,7,8));

//分配$this->assign('pagelist',$pagelist);$this->assign('info',$info);$this->display();}