title: "Yii框架- 分页简单使用"
date: 2015-04-20 17:33:13
tags:
- PHP
- Yii framework
---
控制器 curd.php
<?php
class CurdController extends Controller
{
public $layout='column1';
/*
* 获取总记录数,利用mysql limit 实现
*/
public function actionIndex(){
$sql = 'select count(*) as total from tbl_post ';
$total = Yii::app()->db->createCommand($sql)->queryRow();
$limit = 1;
$start = 0;
$page = Yii::app()->request->getQuery('page',1);
$start = ($page -1)* $limit;
$sql = "select * from tbl_post limit $start,$limit";
$posts = Yii::app()->db->createCommand($sql)->queryAll();
$criteria = new CDbCriteria();
$pages=new CPagination($total['total']);
$pages->pageSize= 2 ;
$pages->applyLimit($criteria);
$this->render('index',array(
'pages'=>$pages,
'posts'=>$posts
));
}
}
视图:index.php
<h1>评论列表</h1>
<?php foreach($posts as $item){
echo $item['title'].'----'.date('Y-m-d H:i:s',$item['create_time']);
} ?>
<p>
<?php $this->widget('CLinkPager',array(
'header'=>'sss',
'firstPageLabel' => '首页',
'lastPageLabel' => '末页',
'prevPageLabel' => '上一页',
'nextPageLabel' => '下一页',
'pages' => $pages,
'maxButtonCount'=>8
))
?>
</p>
date: 2015-04-20 17:33:13
tags:
- PHP
- Yii framework
---
控制器 curd.php
<?php
class CurdController extends Controller
{
public $layout='column1';
/*
* 获取总记录数,利用mysql limit 实现
*/
public function actionIndex(){
$sql = 'select count(*) as total from tbl_post ';
$total = Yii::app()->db->createCommand($sql)->queryRow();
$limit = 1;
$start = 0;
$page = Yii::app()->request->getQuery('page',1);
$start = ($page -1)* $limit;
$sql = "select * from tbl_post limit $start,$limit";
$posts = Yii::app()->db->createCommand($sql)->queryAll();
$criteria = new CDbCriteria();
$pages=new CPagination($total['total']);
$pages->pageSize= 2 ;
$pages->applyLimit($criteria);
$this->render('index',array(
'pages'=>$pages,
'posts'=>$posts
));
}
}
视图:index.php
<h1>评论列表</h1>
<?php foreach($posts as $item){
echo $item['title'].'----'.date('Y-m-d H:i:s',$item['create_time']);
} ?>
<p>
<?php $this->widget('CLinkPager',array(
'header'=>'sss',
'firstPageLabel' => '首页',
'lastPageLabel' => '末页',
'prevPageLabel' => '上一页',
'nextPageLabel' => '下一页',
'pages' => $pages,
'maxButtonCount'=>8
))
?>
</p>