$files = FileImport::find()
->where(['type' => 1]);
$pagination = new Pagination(
[
'defaultPageSize' => 6,
'totalCount' => $files->count(),
]
);
$files = $files
->offset($pagination->offset)
->limit($pagination->limit)
->orderBy(['id' => SORT_DESC])
->all();
注意点:where要在最前面呢出现。
更新:在Yii2中可以使用GridView实现更好的效果
use yii\data\ActiveDataProvider;
$dataProvider = new ActiveDataProvider([
'query' => $data, //$data为由Model::find()查询的结果
'pagination' => [
'pageSize' => 10,
],
'sort' => [
'defaultOrder' => [
'createTime' => SORT_DESC,
],
],
]);
然后把$dataProvider传进view即可使用,view中的代码不赘述