YII CListView 分页 另一种写法

控制器

//获取此分类下商品$cid$products = Yii::app()->db->createCommand($sql)->queryAll();$dataProvider = new CArrayDataProvider($products, array(    'id' => 'ProductList',    'sort' => array('attributes' => array(    'product_name', 'selling_price', 'views', 'purchases')    ),    'pagination' => array('pageSize' => $this->listPageSize    )));$this->render('index', compact('dataProvider', 'parent_category', 'subCategorys','brands'));

$sql 就是SQL查询语句就可以

页面

<div class="pro_list"><div class="prolist"><?php$this->widget("zii.widgets.CListView", array(    'dataProvider' => $dataProvider,    'itemView' => '_list',    'emptyText' => '您查询的数据不存在',    'summaryText' => '',    'sortableAttributes' => array('selling_price' => '单价','views' => '浏览量','purchases' => '销售数量',    ),    'sorterHeader' => '排序方法：',    'pagerCssClass'=>'clear',//我的商品分页样式有,float:right;因为要一行有5个商品,导致最后商品最后一行,有的不到5个,分页//按钮就跑到那一行一起了,所有加了这个参数,clear就是claa样式.    'pager' => array('class' => "CLinkPager",'header' => '','firstPageLabel' => '第一页','lastPageLabel' => '最后一页','nextPageLabel' => '下一页','prevPageLabel' => '前一页'    )));?></div></div>

_list 页面

<?php $link = Yii::app()->createUrl('product/default/view', array('pid' => $data['id'])); ?><dl class="pic_list"><dt ><a href="<?php echo $link; ?>" target="_blank"><img id="image<?php echo $data['id']; ?>" src="<?php echo $data['image_path']; ?>" /></a></dt><dd><a href="<?php echo $link; ?>" target="_blank"><?php echo $data['product_name']; ?></a></dd><dd><?php if($data['special']) : ?><div class="cu"></div><div class="xj">￥<?php echo $data['special']; ?></div><div class="yj" >￥<?php echo $data['selling_price']; ?></div><?php else : ?><div></div><div class="xj">￥<?php echo $data['selling_price']; ?></div><?php endif; ?></dd><dd id="thisProduct<?php echo $data['id']; ?>" class="showbtn" style="display:none"><div class="tjgwc"><a class="addCartBtn" id="<?php echo $data['id']; ?>" href="javascript:void(0);">加入购物车</a></div><input id="quantity<?php echo $data['id']; ?>" type="hidden" value="1"/>    <input id="goodsId<?php echo $data['id']; ?>" type="hidden" value="<?php echo $data['id']; ?>"/>    <input id="goods_limit_num<?php echo $data['id']; ?>" type="hidden" value="<?php echo $data['limit_num']; ?>"/><?php $sql = 'SELECT id FROM clz_product_options WHERE product_id='.$data['id'].' AND is_default=1';$products = Yii::app()->db->createCommand($sql)->queryAll();?><?php foreach($products as $product) : ?><div class="selected" style="display: none"><span class="option<?php echo $data['id']; ?>" option-id="<?php echo $product['id']; ?>"></span></div><?php endforeach; ?></dd></dl>

.clear {clear: both;float:right;}

如果这个看的不太懂,可以看我另一个文章,比较完整