php分页类用法(摘自yii框架)

2. php;toolbar:false">/*public function actionReport()
3. {
4. $sql = "select * from {{goods}}";
5. $criteria=new CDbCriteria();
6. $result = Yii::app()->db->createCommand($sql)->query();
7. $pages=new CPagination($result->rowCount);
8. $pages->pageSize=2;
9. $pages->applyLimit($criteria);
10. $result=Yii::app()->db->createCommand($sql." LIMIT :offset,:limit");
11. $result->bindValue(':offset', $pages->currentPage*$pages->pageSize);
12. $result->bindValue(':limit', $pages->pageSize);
13. $goodsInfo=$result->query();
14. $this->render('index',array(
15. 'goodsInfo'=>$goodsInfo,
16. 'pages'=>$pages,
17. ));
18. }*/

2. foreach($goodsInfo as $v){
   ?>
   }
   ?>
   //分页widget代码:
   $this->widget('CLinkPager',array('pages'=>$pages));
   ?>

   商品name	价格	更新时间

方式二，使用自己的分页类来完成分页 1，控制器代码:

3. public function actionIndex(){

4. $goods_m=goods::model();

5. //1.获得商品总的记录数目

6. $cnt = $goods_m -> count();

7. //2. 实例化分页类对象

8. $page = new Page($cnt, 2);

9. //3. 重新按照分页的样式拼装sql语句进行查询

10. $sql = "select * from {{goods}} $page->limit";
11. $goodsInfo = $goods_m -> findAllBySql($sql);

12. //4. 获得分页页面列表(需要传递到视图模板里边显示)

13. $pageList = $page->fpage();

14. $this->renderPartial('index',array('goodsInfo'=>$goodsInfo,'pageList'=>$pageList));

15. }

2，视图代码:

2. foreach($goodsInfo as $v){
   ?>
   }
   ?>
   echo $pageList;
   ?>

   商品name	price	create_time

分页类要放到能自动加载到的目录下就行;