PHP Pagination::fpage方法代码示例

 /**
  * Displays a particular model.
  * @param integer $id the ID of the model to be displayed
  */
 public function actionIndex()
 {
     //通过模型Model实现数据表信息查询
     //产生模型对象
     $article_model = Article::model();
     //1.获得总的记录数目
     $cnt = $article_model->count();
     $per = 16;
     //2. 实例化分页类对象
     $page = new Pagination($cnt, $per);
     //3. 重新按照分页的样式拼装sql语句进行查询,按时间排序order by 时间 desc
     $sql = "select * from {{article}} order by create_time desc {$page->limit}";
     $article_infos = $article_model->findAllBySql($sql);
     //4. 获得分页页面列表(需要传递到视图模板里边显示)
     //$page_list = $page->fpage(array(0,1,2,3,4,5,6,7,8));
     $page_list = $page->fpage(array(2, 3, 4, 5, 6, 7, 8));
     //部分显示
     $numcon = $page->fpage(array(0));
     //全部显示
     //$page_list = $page->fpage();
     //最新的感觉
     //$xin = Article::model()->findAll(array('order'=>'create_time desc','limit'=>10));
     //点击最多排序
     $re = Article::model()->findAll(array('order' => 'click desc', 'limit' => 16));
     //更多相关阅读
     /*$xiangguan=Article::model()->findAll(array("condition" =>"cateId=".$article->cateId." and status = 1","limit"=>5,'order'=>'create_time desc'));
     
     		//seo设置
     		$this->pageKeyword=array(
     			'title'=>$article->title.'-'.$article->CateOne->name.'-'.Helper::siteConfig()->site_name,
     			'keywords'=>$article->keywords,
     			'description'=>Helper::truncate_utf8_string($article->des,100),
     		);*/
     //统计感觉的总数
     $cmodel = Article::model()->findAll();
     $count = count($cmodel);
     $data = array('numcon' => $numcon, 're' => $re, 'article_infos' => $article_infos, 'page_list' => $page_list, 'count' => $count);
     //调用视图模板，给模板传递数据
     $this->render('index', $data);
 }

 public function actionIndex()
 {
     //1.获得总的记录数目
     $cnt = count(User::model()->findAll());
     $per = 10;
     //2. 实例化分页类对象
     $page = new Pagination($cnt, $per);
     //3. 重新按照分页的样式拼装sql语句进行查询
     $sql = "select * from {{user}} order by regtime desc {$page->limit}";
     $users = User::model()->findAllBySql($sql);
     //全部显示
     $page_list = $page->fpage();
     $data = array('users' => $users, 'page_list' => $page_list, 'cnt' => $cnt);
     $this->render('index', $data);
 }

 function actionCategory()
 {
     //渲染视图
     //render() 带布局渲染
     //renderPartial()  部分渲染
     error_reporting(E_ALL || ~E_NOTICE);
     $goods_model = Goods::model();
     $total = $goods_model->count();
     $per = 8;
     $page = new Pagination($total, $per);
     $sql = "select * from {{goods}} {$page->limit}";
     $goods_infos = $goods_model->findAllBySql($sql);
     $page_list = $page->fpage();
     $this->render('category', array('goods_infos' => $goods_infos, 'page_list' => $page_list));
 }

 public function actionIndex()
 {
     $where = '1';
     $limit = 10;
     $criteria = new CDbCriteria();
     $criteria->select = '*';
     $count = $this->userModel->count($where);
     $page = new Pagination($count, $limit);
     $criteria->limit = $limit;
     $criteria->offset = $page->limit;
     $criteria->order = 'userid DESC';
     $list = $this->userModel->findAll($criteria);
     $page_list = $page->fpage();
     $this->render('index', array('userList' => $list, 'page_list' => $page_list));
 }

 protected function displayList($model, $where)
 {
     // 用户列表
     $list = CModel::factory($model)->getList($where);
     $this->assign('list', $list);
     // 分页
     $count = CModel::factory($model)->getCount($where);
     if (!empty($list)) {
         $pageObject = new Pagination($count, CModel::factory($model)->pageRows);
         $pagestr = $pageObject->fpage(array(3, 4, 5, 6, 7));
         $this->assign('page', $pagestr);
     }
     $this->assign('count', $count);
     $this->assign('where', $where);
     $this->display();
 }

 function actionShow1()
 {
     //获得数据模型
     $goods_model = Goods::model();
     //1.获得商品总的记录数目
     $cnt = $goods_model->count();
     $per = 6;
     //2. 实例化分页类对象
     $page = new Pagination($cnt, $per);
     //3. 重新按照分页的样式拼装sql语句进行查询
     $sql = "select * from {{goods}} {$page->limit}";
     $goods_infos = $goods_model->findAllBySql($sql);
     //4. 获得分页页面列表(需要传递到视图模板里边显示)
     $page_list = $page->fpage(array(3, 4, 5, 6, 7));
     //调用视图模板，给模板传递数据
     $this->renderPartial('show', array('goods_infos' => $goods_infos, 'page_list' => $page_list));
 }

 public function actionIndex()
 {
     $model = Msg::model();
     //1.获得总的记录数目
     $cnt = $model->count();
     $per = 10;
     //2. 实例化分页类对象
     $page = new Pagination($cnt, $per);
     //3. 重新按照分页的样式拼装sql语句进行查询
     $sql = "select * from {{msg}} order by time desc {$page->limit}";
     $msgshow = $model->findAllBySql($sql);
     //4. 获得分页页面列表(需要传递到视图模板里边显示)
     //$page_list = $page->fpage(array(3,4,5,6,7));//部分显示
     //全部显示
     $page_list = $page->fpage();
     $data = array('msg' => $msgshow, 'page_list' => $page_list);
     $this->render('index', $data);
 }

 public function actionIndex()
 {
     $article_model = Article::model();
     //1.获得总的记录数目
     $cnt = $article_model->count();
     $per = 10;
     //2. 实例化分页类对象
     $page = new Pagination($cnt, $per);
     //3. 重新按照分页的样式拼装sql语句进行查询
     $sql = "select * from {{article}} order by create_time desc {$page->limit}";
     $article_infos = $article_model->findAllBySql($sql);
     //4. 获得分页页面列表(需要传递到视图模板里边显示)
     //$page_list = $page->fpage(array(3,4,5,6,7));//部分显示
     //全部显示
     $page_list = $page->fpage();
     $data = array('article_infos' => $article_infos, 'page_list' => $page_list);
     //调用视图模板，给模板传递数据
     $this->render('index', $data);
 }