一、如何分页

总记录行数 count，

每页显示 per，

分页的总页数 total_page = ceil(count/per)，向上取整

获得具体每页信息：limit 偏移量，条数

                 limit (page-1)*per, per

二、一个分页类，yii组件component 文件名与类名在形式上要统一

compontents/Pagination.php

     "个记录", "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(){            if($this->page==1)                $html.='';            else                $html.="  {$this->config["first"]}  ";            return $html;        }        private function prev(){            if($this->page==1)                $html.='';            else                $html.="  {$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.=" {$page} ";            }                                                                                $linkPage.=" {$this->page} ";                                                                                    for($i=1; $i<=$inum; $i++){                $page=$this->page+$i;                if($page<=$this->pageNum)                    $linkPage.=" {$page} ";                else                    break;            }            return $linkPage;        }        private function next(){            if($this->page==$this->pageNum)                $html.='';            else                $html.="  {$this->config["next"]}  ";            return $html;        }        private function last(){            if($this->page==$this->pageNum)                $html.='';            else                $html.="  {$this->config["last"]}  ";            return $html;        }        private function goPage(){            return '  '.$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]="  共有{$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;        }                                                                    }

三、分页实现

1. 获得总记录数

2. 实例化分页对象

3. 拼装分页sql

4. 获得页码列表

/* * 建立一个测试方法，实现商品数据分页显示 */function actionShow1(){    //获得数据模型    $goods_model = Goods::model();                  //1.获得商品总的记录数目    $cnt = $goods_model -> count();    $per = 6;                  //2. 实例化分页类对象    $page = new Pagination($cnt, $per);                  //3. 重新按照分页的样式拼装sql语句进行查询    $sql = "select * from `goods` $page->limit";    $goods_infos = $goods_model -> findAllBySql($sql);                  //4. 获得分页页面列表(需要传递到视图模板里边显示)    $page_list = $page->fpage(array(3,4,5,6,7));                                //调用视图模板，给模板传递数据    $this ->renderPartial('show',array('goods_infos'=>$goods_infos,'page_list'=>$page_list));}

在 视图中

echo $page_list

输出分页代码