php;toolbar:false>/*public function actionreport(){$sql = select * from {{goods}};$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);$goodsinfo=$result->query();$this->render('index',array('goodsinfo'=>$goodsinfo,'pages'=>$pages,));}*/
复制代码
商品name 价格 更新时间
widget('clinkpager',array('pages'=>$pages));?>
复制代码
方式二，使用自己的分页类来完成分页1，控制器代码:
public function actionindex(){
$goods_m=goods::model();//1.获得商品总的记录数目
$cnt = $goods_m -> count();//2. 实例化分页类对象
$page = new page($cnt, 2);//3. 重新按照分页的样式拼装sql语句进行查询
$sql = select * from {{goods}} $page->limit;$goodsinfo = $goods_m -> findallbysql($sql);//4. 获得分页页面列表(需要传递到视图模板里边显示)
$pagelist = $page->fpage();$this->renderpartial('index',array('goodsinfo'=>$goodsinfo,'pagelist'=>$pagelist));
}
复制代码
2，视图代码:
商品name price create_time
复制代码
分页类要放到能自动加载到的目录下就行;