yii框架搜索后分页
控制器里这样写,Shop必须是gii生成的model。
use
appmodelsShop;
use
yiidataPagination;
public function actionShow(){
//$search = Yii::$app->request->get("search");
//$bid = Yii::$app->request->get("bid");
//$tid = Yii::$app->request->get("tid");
//把上面的这三个变量放进去就可以根据传过来的值多条件搜索分页了
$countQuery = clone $query;
$pages = new Pagination(["totalCount" => $countQuery->count(),"pagesize"=>3]);
$models = $query->offset($pages->offset)
->limit($pages->limit)
->all();
// var_dump($models);
return $this->render("show",[
"models" => $models,
"pages" => $pages,
]);
}
视图层show.php里这样写
<?php use yiiwidgetsLinkPager; ?>//一定要将小部件引到视图层
<table>
<?php foreach ($models as $key => $value): ?>
<tr>
<td><?php echo $value["bid"] ?></td>
<td><?php echo $value["tid"] ?></td>
<td><?php echo $value["sname"] ?></td>
</tr>
<?php endforeach ?>
</table>
<?php //显示分页
echo LinkPager::widget([
"pagination" => $pages,
]);?>
- 上一篇: java(jsp)整合discuz同步登录功能详解
- 下一篇: TP中可通过字段映射隐藏数据表的字段名