yii2 分页

基于数据提供者

    public function actionIndex()
    {
        $page = Yii::$app->get('page', 0);
        $modelClass = $this->modelClass;
        return new ActiveDataProvider(
            [
                'query' => $modelClass::find()->asArray(),
                'pagination' => ['pageSize' =>10, 'page' => $page],
            ]
        );
    }

 

基于分页类

public function actionIndex()
{
    $query = Article::find()->where(['status' => 1]);
    $countQuery = clone $query;
    $pages = new Pagination(['totalCount' => $countQuery->count()]);
    $models = $query->offset($pages->offset)
        ->limit($pages->limit)
        ->all();

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

 基于分页类实现接口

        //分页
        $new_pageSize = Yii::$app->request->get('limits');
        $new_page = Yii::$app->request->get('page');

        $query = Train::find()->where(['status' => 1])->orderBy("id desc");
        $pageSize = $new_pageSize ? $new_pageSize : 10;
        $page = $new_page - 1 ? $new_page - 1 : 0;
        $pagination = new Pagination([
            'defaultPageSize' => $pageSize,
            'totalCount' => $query->count(),
            'page' => $page,
        ]);
        $data =$query->offset($pagination->offset)->limit($pagination->limit)->asArray()->all();