limit连贯查询怎么分页麻烦了 - 问答

蛋蛋的蛋 2018-05-15 13:01:19 2871次浏览 4条回答 0 悬赏 10 金钱

$count=10
$page=2

            $pagination = new \yii\data\Pagination([
                'totalCount' => $count,
                'defaultPageSize' => $page,
                ]);
            $list=$this->sql->from($this->aaa)
            ->where('a=1')
            ->limit($pagination->limit)
            ->select('id')
            ->all();

SELECT * from AAA where a=1 LIMIT 10` 结果始终是这样的

我要的是 LIMIT 2,10

蛋蛋的蛋补充于 2018-05-15 13:20

 $pagination = new \yii\data\Pagination([
                'totalCount' => $count,
                'defaultPageSize' => $page,
                ]);
            $list=$this->sql->from($this->aaa)
            ->where('a=1')
            ->offset($pagination->offset)
            ->limit($pagination->limit)
            ->select('id')
            ->all();

我又加了 ->offset($pagination->offset)
进去了。还是limit 10

蛋蛋的蛋补充于 2018-05-16 11:42

自己解决了.
new Expression

->orderBy(new Expression($orddr.' limit '.($tiaoshu * ($zoshu - 1)).','.$tiaoshu.';'))

或者

->offset($tiaoshu * ($zoshu - 1))
            ->limit($tiaoshu)

wsd15321 回答于 2018-05-15 15:40 举报

offset是指从第几行开始，比如一页10行，那第一页offset是0，第二页offset就是10

回复 0 0

sexushuai 回答于 2018-05-15 15:52 举报

// $pagination = new Pagination(['defaultPageSize' => 10]);
$pagination = new Pagination(['defaultPageSize' => 2]);
$unit = Unit::find()->limit($pagination->limit);
echo $unit->createCommand()->getRawSql();die;

SELECT * FROM mall_unit LIMIT 2
测试过了 limit 是2 你再确认下你的代码

你打印下 $pagination

yii\data\Pagination Object
(
    [pageParam] => page
    [pageSizeParam] => per-page
    [forcePageParam] => 1
    [route] => 
    [params] => 
    [urlManager] => 
    [validatePage] => 1
    [totalCount] => 0
    [defaultPageSize] => 2
    [pageSizeLimit] => Array
        (
            [0] => 1
            [1] => 50
        )

    [_pageSize:yii\data\Pagination:private] => 
    [_page:yii\data\Pagination:private] => 
)