yii分页 CDbCriteria

1，AR方式

model文件中

public function getList(){

    $criteria = new CDbCriteria();          

    $count = $this->count($criteria);

    $pager = new CPagination($count);

    $pager->pageSize = 10;

    $pager->pageVar = 'p';//修改分页参数，默认为page

    $pager->params = array('type'=>'msg');//分页中添加其他参数

    $pager->applyLimit($criteria);

    $list = $this->findAll($criteria);

    return array('pages'=>$pager,'list'=>$list);

}

public function getPageList($condition = '',$page = 1,$limit = 10){

    $critieria = new CDbCriteria();

    $critieria->condition = $condition;

    $count = $this->count($critieria);

    $pageCount = ceil($count/$limit);

    $critieria->order = 'FID DESC';

    $critieria->limit = $limit;

    $critieria->offset = ($page-1)*$limit;

    $data = $this->findAll($critieria);

    //$data[] = $count;

    //$data[] = $pageCount;

    return $data;

}

2，DAO方式 queryAll()

$criteria = new CDbCriteria;    

$sql = "SELECT * FROM USER";     

$model= Yii::app()->db->createCommand($sql)->queryAll();     

$pages = new CPagination(count($model));                    

$pages->pageSize = 5;     

$pages->applylimit($criteria);      

$model=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");     

$model->bindValue(':offset', $pages->currentPage*$pages->pageSize);     

$model->bindValue(':limit', $pages->pageSize);     

$model=$model->queryAll();

2，DAO方式 query()

$criteria=new CDbCriteria();             

$result = Yii::app()->db->createCommand($sql)->query();            

$pages=new CPagination($result->rowCount);          

$pages->pageSize=5;            

$pages->applyLimit($criteria);          

$result=Yii::app()->db->createCommand($sql." LIMIT 5");           

$result->bindValue(':offset', $pages->currentPage*$pages->pageSize);          

$result->bindValue(':limit', $pages->pageSize);          

$list=$result->query();

3，view中调用

$this->widget('CLinkPager',array(   

'header'=>'',

'cssFile'=>false,//去除默认的样式

'firstPageLabel' => '首页',  

  'lastPageLabel' => '末页',   

'prevPageLabel' => '上一页',   

'nextPageLabel' => '下一页',   

'pages' => $pages,   

'maxButtonCount'=>13   

)  

);