YII2连表分页

weixin_33686714

于 2017-05-02 14:43:00 发布

阅读量128

点赞数

原文链接：http://www.cnblogs.com/hangxing1996/p/6796054.html

版权

控制器(controller)页面

use \yii\data\Pagination;　　//引入这个类

public function actionList(){

$data = Clock::find()->select('*')->innerJoin('user','clock.user_id=user.id'); //联查

$pages = new Pagination(['totalCount'=>$data->count(),'pageSize'=>3]);

$res = $data->offset($pages->offset)->limit($pages->limit)->asArray()->all();

return $this->render('list',['data'=>$res,'pages'=>$pages]);

}

视图（views）层

<?= yii\widgets\LinkPager::widget([

'pagination' => $pages,

'nextPageLabel' => '下一页',

'prevPageLabel' => '上一页',

'firstPageLabel' => '首页',

'lastPageLabel' => '尾页'

]);?>

<div style="float:left;padding-left:400px;"><?= yii\widgets\LinkPager::widget([
        'pagination' => $pages,
        'nextPageLabel' => '下一页',
        'prevPageLabel' => '上一页',
        'firstPageLabel' => '首页',
        'lastPageLabel' => '尾页'
    ]);?></div>

转载于:https://www.cnblogs.com/hangxing1996/p/6796054.html