Yii framewoke --- 分页

title: "Yii框架- 分页简单使用"
date: 2015-04-20 17:33:13
tags:
- PHP
- Yii framework
---
控制器 curd.php
<?php
class CurdController extends Controller
{
public $layout='column1';
    
/*
* 获取总记录数，利用mysql  limit 实现
*/
    public function actionIndex(){


        $sql = 'select count(*) as total from tbl_post ';
        $total = Yii::app()->db->createCommand($sql)->queryRow();
        $limit = 1;
        $start  = 0;


        $page = Yii::app()->request->getQuery('page',1);
        $start = ($page -1)* $limit;
        $sql = "select * from tbl_post limit $start,$limit";
        $posts = Yii::app()->db->createCommand($sql)->queryAll();
        $criteria = new CDbCriteria();
        $pages=new CPagination($total['total']);
        $pages->pageSize= 2 ;
        $pages->applyLimit($criteria);


        $this->render('index',array(
            'pages'=>$pages,
            'posts'=>$posts
        ));




    }
}


视图：index.php


<h1>评论列表</h1>


<?php foreach($posts as $item){
   echo $item['title'].'----'.date('Y-m-d H:i:s',$item['create_time']);


} ?>


<p>


    <?php $this->widget('CLinkPager',array(
        'header'=>'sss',
        'firstPageLabel' => '首页',
        'lastPageLabel' => '末页',
        'prevPageLabel' => '上一页',
        'nextPageLabel' => '下一页',
        'pages' => $pages,
        'maxButtonCount'=>8
        ))
    ?>
</p>