我刚刚使用分页类和 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,
从分页数组中,这将使用框架的默认页面选项进行分页。