yii分页组件的使用
本文使用时,分页类在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"=>"上一页", "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="{$this->uri}&page=1">{$this->config["first"]}</a> "; return $html; } private function prev(){ $html=""; if($this->page==1) $html.=""; else $html.=" <a href="{$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.=" {$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> "; else break; } return $linkPage; } private function next(){ $html=""; if($this->page==$this->pageNum) $html.=""; else $html.=" <a href="{$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="{$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;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。
- 上一篇: php中filter函数用来验证、过滤
- 下一篇:没有了