Yii Framework使用DAO方式查询分页代码

控制器代码如下:

    $sql = "SELECT * FROM table WHERE cid=2 and status=1";

    $criteria=new CDbCriteria();
    $result = Yii::app()->db->createCommand($sql)->query();
    $pages=new CPagination($result->rowCount);
    $pages->pageSize=22;
    $pages->applyLimit($criteria);
    $result=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");
    $result->bindValue(':offset', $pages->currentPage*$pages->pageSize);
    $result->bindValue(':limit', $pages->pageSize);
    $posts=$result->query();
    $this->render('index',array(
            'posts'=>$posts,
            'pages'=>$pages,

    ));

 

视图代码如下:

    <?php foreach($posts as $model):?>
    <?php echo CHtml::link($model['title'],array('article/view','id'=>$model['id']));?>
    <?php endforeach;?>
    分页widget代码:
    <?php $this->widget('CLinkPager',array('pages'=>$pages));?>