Yii2:分页和链接寻呼器 - 从第 0 页开始


Yii2: Pagination and LinkPager - starts at page 0?

我刚刚使用分页类和 LinkPager 构建了一个分页系统,但注意到由于某种原因,页面编号从0开始?

这很烦人,因为分页生成的链接"第 1 页"到第 1 页,实际上是第 2 页。

这是我的通用代码:

$sql = $this->db->createCommand("SELECT COUNT(*) FROM some_table WHERE some_id=:some_id");
$sql->bindValue(':some_id', $this->some_id);
$count = $sql->queryScalar();
$dataProvider = new SqlDataProvider([
    'sql' => 'SELECT t.*, a.image_path, a.upload_date FROM some_table AS t LEFT JOIN other_table AS a ON t.user_id=a.user_id WHERE t.some_id=:some_id',
    'params' => [':some_id' => $this->some_id],
    'totalCount' => $count,
    'sort' => [
        //.............
    ],
    'pagination' => [
        'pageSize' => $this->per_page,
        'page' => $this->page,
        'pageSizeLimit' => [5,100],
        'pageSizeParam' => 'per_page',
        'totalCount' => $count,
    ],
]);

此代码也在类初始化时运行:

$this->page = ($this->page) ? $this->page : 1;

它使用上述代码将以下内容追加到查询中:

LIMIT 25 OFFSET 25

如果我将其更改为:

$this->page = ($this->page) ? $this->page : 0;

然后它只是附加:

LIMIT 25

有没有办法让它开始@页面1?

删除

'page' => $this->page, 

从分页数组中,这将使用框架的默认页面选项进行分页。