Yii2 SqlDataProvider 原生sql 执行sql

最新推荐文章于 2021-03-26 05:02:14 发布

cd ~/Homestead

最新推荐文章于 2021-03-26 05:02:14 发布

阅读量3.3k

点赞数

分类专栏： Yii2

本文链接：https://blog.csdn.net/xiaoyangxiaodong/article/details/45166607

版权

Yii2 专栏收录该内容

26 篇文章 1 订阅

订阅专栏

 $count = Yii::$app->db->createCommand('
      SELECT COUNT() FROM user WHERE status=:status
  ', [':status' => 1])->queryScalar();
 
  $dataProvider = new SqlDataProvider([
      'sql' => 'SELECT  FROM user WHERE status=:status',
      'params' => [':status' => 1],
      'totalCount' => $count,
      'sort' => [
          'attributes' => [
              'age',
              'name' => [
                  'asc' => ['first_name' => SORT_ASC, 'last_name' => SORT_ASC],
                  'desc' => ['first_name' => SORT_DESC, 'last_name' => SORT_DESC],
                  'default' => SORT_DESC,
                  'label' => 'Name',
              ],
          ],
      ],
      'pagination' => [
          'pageSize' => 20,
      ],
  ]);