Yii分页用法实例详解

下面我总结了在yii常用的一些yii分页方式与实例代码，这里有普通分页与ajax实现分页，希望此文章对大家会有所帮助。

第一种：clistview分页  针对对象形式的数据分页

controller:

public function actionajax() {
        $criteria = new cdbcriteria();
        //$criteria->order = 'news_id desc';
        $criteria->condition = 'user_id = 1';
 
        $dataprovider = new cactivedataprovider('news', array(
                    'pagination' => array(
                        'pagesize' => yii::app()->params['pagesize'],
                        'pagevar' => yii::app()->params['pagevar'],
                    ),
                    'criteria' => $criteria,
                ));
 
 
        $this->render('view', array(
            'dataprovider' => $dataprovider,
        ));
}

view:

<?php
$this->widget('zii.widgets.clistview', array(
    'dataprovider' => $dataprovider, //数据
    'itemview' => '_view', //显示的模版
    'id' => yii::app()->controller->id,
    'itemstagname' => 'ul',
    'ajaxvar' => '', //默认为page或ajax 去掉后url更简洁
    'htmloptions' => array('class' => yii::app()->controller->id),
    'loadingcssclass' => 'loading', //默认为list-view-loading
    //'template' => '{summary}{sorter}{items}{pager}',//显示的顺序
    //'ajaxupdate' => false, //是否ajax分页  false或分页显示的容器id
    //'beforeajaxupdate' => 'before_ajax_update',   //回调函数 在common.js里完成
    //'afterajaxupdate' => 'after_ajax_update',  
    'emptytext' => '
<div class="alert alert-waning">
    暂无数据！
</div>
', //无数据时显示内容
                    'pagercssclass' => 'pagination', //分页的class
                    'pager' => array(
                        'selectedpagecssclass' => 'active', //当前页的class
                        'hiddenpagecssclass' => 'disabled', //禁用页的class
                        'header' => '', //分页前显示的内容
                        'maxbuttoncount' => 10, //显示分页数量
                        'htmloptions' => array('class' => ''),
                        'firstpagelabel' => '首页',
                        'nextpagelabel' => '下一页',
                        'prevpagelabel' => '上一页',
                        'lastpagelabel' => '末页',
                    ),
                ));
?>

第二种：clinkpager  针对数组形式的数据分页

controller:

public function actionindex() {
 
        $criteria = new cdbcriteria();
        $criteria->order = 'news_id desc';
        $criteria->condition = 'user_id = 1';
 
        $count = news::model()->count($criteria);
        $pages = new cpagination($count);
 
        $pages->pagesize = 10;
        $pages->applylimit($criteria);
        $list = news::model()->findall($criteria);
 
        $this->render('index', array('list' => $list, 'pages' => $pages));
}

view:

<ul>
    <?php foreach ($list as $item): ?>
    <li>
         
        <div class=page-header>
            <?php echo $item--->news_title; ?>
        </div>
 
        <div class=content>
            <?php echo $item--->news_intro; ?>
        </div>
 
    </li>
<?php endforeach; ?>
</ul>
 
<div class=pagination>
    <?php
    $this--->widget('clinkpager', array(
        'pages' => $pages,
        'selectedpagecssclass' => 'active', //当前页的class
        'hiddenpagecssclass' => 'disabled', //禁用页的class
        'header' => '', //分页前显示的内容
        'maxbuttoncount' => 10, //显示分页数量
        'htmloptions' => array('class' => ''),
        'firstpagelabel' => '首页',
        'nextpagelabel' => '下一页',
        'prevpagelabel' => '上一页',
        'lastpagelabel' => '末页',
            )
    );
    ?>
</div>

第三种： dao实现分页.

controller层:

public function actionreport()
{
$sql = "select remitdate, sum(rate) sumrate from td_delivery
group by remitdate
order by remitdate desc";
$criteria=new cdbcriteria();
$result = yii::app()->db->createcommand($sql)->query();
$pages=new cpagination($result->rowcount);
$pages->pagesize=2;
$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('report',array(
'posts'=>$posts,
'pages'=>$pages,
));
}

view层:

<?php foreach($posts as $row):?>
 <?php echo chtml::link($row["remitdate"],array('delivery/view','remitdate'=>$row["sumrate"]));?>
 <?php echo $row["sumrate"]."<br />" ?>
 <?php endforeach;?>
 <?php
 //分页widget代码:
 $this->widget('clinkpager',array('pages'=>$pages));
?>

优点: dao效率高; 缺点: view层需要自己写一些样式,稍显麻烦一点

第四种：widget实现分页

model层:

/**
* @var string attribute : 日运费 (统计用)
* 需要对新增加的字段做个声明
*/
public $dayrate;

/*
* 统计功能: 统计每日的运费
*/
public function statistics()
{
$criteria = new cdbcriteria;
$criteria->select = 'remitdate, sum(rate) as dayrate';
$criteria->group = 'remitdate';
return new cactivedataprovider(get_class($this), array(
'criteria'=>$criteria,
'sort'=>array(
// 表头设置点击排序的字段
'attributes'=>array(
'remitdate',
'dayrate'=>array(
'asc'=>'dayrate',
'desc'=>'dayrate desc',
)
),
'defaultorder'=>'remitdate desc',
),
));
}

controller层:

/**
* 运单统计功能:
* 按日期统计
*/
public function actionreport()
{
$model=new delivery('statistics');
$model->unsetattributes(); // clear any default values
 
$this->render('report',array(
'model'=>$model,
));
}

view层:

<?php $this->widget('zii.widgets.grid.cgridview', array(
'id'=>'delivery-grid',
'dataprovider'=>$model->statistics(),
'filter'=>$model,
'columns'=>array(
'remitdate',
'dayrate',
array(
'class'=>'cbuttoncolumn',
),
),
));
?>

优点: 可以使用自带的样式; 缺点: 效率略低.

第五种：ajax分页

yii中ajax分页有多种实现方法，比较传统的就是在view中写js来实现，大概的就是这样:
在view中js大概逻辑是这样

$('#listview .yiipager a').live('click',function(){
        $.ajax({
            url:$(this).attr('href'),
            success:function(html){
                $('#listview').html(html);
            }
        });
        return false;//阻止a标签
});

然后在controller中判断ajax请求，再使用renderpartial方法渲染局部list视图，然后局部视图会被view中的ajax方法填充到局部刷新的div中。controller的大概逻辑是:

if (yii::app()->request->isajaxrequest) {
$this->renderpartial('_comments',array(
    'model' => $model,
    'comments' => $comments,//在局部视图中foreach得到每条数据
    'pages' => $pages,
   ));
    yii::app()->end();
}

后来发现yii中的clistview更方便，封装了分页，foreach显示list，还支持数据排序。具体的可以在yii的api手册中发掘。使用clistview是默认ajax分页的，使用方法如下：

controller中：

$criteria = new cdbcriteria();
$criteria->order = '`create_time` desc';
$dataprovider = new cactivedataprovider('comments', array(
    'pagination'=>array(
      'pagesize'=>yii::app()->params['commentsperpage'],//设置分页条数以确定取出数据的条数
  ),
  'criteria'=>$criteria,
  ));
$this->render('comments',array(
         'model' => $model,
         'dataprovider' => $dataprovider,
));

然后在view中：

<?php $this->widget('zii.widgets.clistview', array(
  'dataprovider'=>$dataprovider,
  'itemview'=>'_comments',
  //'ajaxupdate'=> false,//这样就不会ajax翻页
  'pager' => array(//pager 的配置信息。默认为<code>array('class'=>'clinkpager')</code>.也可以自己配置
   'nextpagelabel' => '下一页 »',
   'prevpagelabel' => '« 上一页'
  ),
//在这里还可以配置一些排序规则，具体可以查阅手册
));
?>

这样就实现了ajax分页，很方便。

希望本文所述对大家基于yii框架的php程序设计有所帮助。