控制器中方法：
user;
$id = $user->id;
$connection=Yii::app()->db;
$sql= "SQL查询语句";
$command = $connection->createCommand($sql)->queryAll();
$pages = new CPagination(count($command));
$list = $connection->createCommand($sql." limit ".$pages->limit." offset ".$pages->offset."")->queryAll();
$this->render('index',array(
'bonus' => $list,'pages' => $pages,));
}
视图中显示为：
PHP;">
| 标题 | $ad): ?> |
|---|
