时间:2021-07-01 10:21:17 帮助过:3人阅读
该案例使用时,分页类在yii框架中以组件的形式存在于components中。
action代码如下:
public function actionIndex(){ $user=User::model(); //分页的使用 $count=$user->count(); //获取总页数 $pagesize=3; //每一页显示的记录条数 $page=new Page($count,$pagesize); $sql="select * from {{user}} $page->limit"; $info=$user->findAllBySql($sql); $show_page=$page->fpage(); $this->renderPartial("index",array("info"=>$info,'show_page'=>$show_page)); }
在view页面,遍历info即可获取信息,输出show_page即可显示分页列表等信息。
现附上page.php代码如下:
<?php /** * 分页类,以组件形式存在于componnets文件中 */ class Page { private $total; //数据表中总记录数 private $listRows; //每页显示行数 private $limit; private $uri; private $pageNum; //页数 private $config=array('header'=>"个记录", "prev"=>"", "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.=" 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; } }
希望本文所述对大家基于yii框架的PHP程序设计有所帮助。