限制yii2中的Listview而不分页

Question

我在yii2中有一个Listview来显示项目，在这种情况下，项目是视频缩略图，我只想显示5，我试图限制查询。。。

$dataProvider = new ActiveDataProvider([
'query' => Video::find()
->select(['video.*', 'COUNT(video_like.video_id) AS countlike'])
->joinWith(['likes'])
->groupBy(['video_like.video_id','video.video_id'])
->limit(5)
->orderBy(['countlike' => SORT_DESC])
]);

但它不起作用。。。我的列表视图是：

<?php echo yiiwidgetsListView::widget([
'dataProvider' => $dataProvider,
'pager' => [
'class' => yiibootstrap4LinkPager::class,
],
'itemView' => '_video_item',
'layout' => '<div class="d-flex flex-wrap">{items}</div>{pager}',
'itemOptions' => [
'tag' => false,
],
]) ?>

Answer 1

检查此文档。

这应该对你有用：

$dataProvider = new ActiveDataProvider([
'query' => Video::find()
->select(['video.*', 'COUNT(video_like.video_id) AS countlike'])
->joinWith(['likes'])
->groupBy(['video_like.video_id','video.video_id'])
->orderBy(['countlike' => SORT_DESC]),
'pagination' => [
'pageSize' => 5,
]
]);