yii2多表联查分页

最新推荐文章于 2024-08-18 03:29:38 发布

刘奶奶喝牛奶2333

最新推荐文章于 2024-08-18 03:29:38 发布

阅读量3.5k

点赞数 1

文章标签： yii 分页 pagination 数据数据库

本文链接：https://blog.csdn.net/qq_34018847/article/details/51013092

版权

加载分页类

use yii\data\Pagination;

控制器层

public function actionPage()
    {
      $data = Add::find()->select('*')->innerJoin('zss_gift','zss_add.gift_id=zss_gift.gift_id'); //联查
       $pages = new Pagination(['totalCount' =>$data->count(), 'pageSize' => '2']);
       $model = $data->offset($pages->offset)->limit($pages->limit)->asArray()->all(); //分页

       return $this->render('page',[
             'model' => $model,
             'pages' => $pages,
       ]);
    }

视图层

<?php
use yii\widgets\LinkPager;
use yii\helpers\Html;
?>

<?php foreach ($model as $key => $value) : ?>
  <?= Html::encode($value['gift_name']) ?><br> //遍历
<?php endforeach; ?>

<!-- 显示分页 -->
<?php
  echo LinkPager::widget([
      'pagination' => $pages,
  ]);
?>