Yii框架搜索分页

最新推荐文章于 2024-08-11 19:27:09 发布

橡皮擦Mid

最新推荐文章于 2024-08-11 19:27:09 发布

阅读量197

点赞数

分类专栏：框架学习文章标签： php Yii 搜索分页

本文链接：https://blog.csdn.net/listen_for/article/details/52926128

版权

框架学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

这篇博客介绍了如何在Yii框架下实现搜索和分页功能。在控制器中设置了搜索参数，视图部分展示了使用ActiveForm创建搜索表单，并通过LinkPager显示分页链接。用户可以输入姓名和ID进行搜索，搜索结果以表格形式展示，同时提供分页导航。

摘要由CSDN通过智能技术生成

controller:

//搜索分页

    public function actionList()
    {
        $where = Yii::$app->request->get();
//        var_dump($where);
        $query = new Query();//刚写成 $query = new\yii\db\Query();报错，所以以后报错的时候多看看上面的use...
        $query->from("user");
        if (!empty($where['name'])){
        $query->andWhere(["name"=>$where['name']]);
        }

         if (!empty($where['id1'])&&$where['id1']!==""){
             $query->andWhere([">=","id",$where['id1']]);
         }

         if (!empty($where['id2'])&&$where['id2']!==""){
             $query->andWhere(["<=","id",$where['id2']]);
         }
         //$user = $query->all();//执行上面所有的语句
        //$count = count($user);
        /*分页*/
//        $pagination = new Pagination(['totalCount' => $count,'pageSize'=>2]);
        $pagination = new Pagination(['totalCount' => $query->count()]);
        $pagination->setPageSize(2);
        $user = $query->offset($pagination->offset)->limit($pagination->limit)->all();

        return $this->render("list",['user'=>$user,'where'=>$where,'pagination'=>$pagination]);

    }

view：<?php
use yii\widgets\ActiveForm;
use yii\helpers\Url;
use yii\helpers\Html;

?>
<?php
   $form = ActiveForm::begin([
           'action'=> Url::toRoute(['show/list']),
           'method'=>'get',
       ]);
   echo "姓名:",Html::input('text','name');
   echo "ID:",Html::input('text','id1');
   echo "-",Html::input('text','id2');

   echo Html::submitButton("搜索");
   ActiveForm::end();
?>
<!doctype html>
<html lang="en">
<head>
   <meta charset="UTF-8">
   <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
   <meta http-equiv="X-UA-Compatible" content="ie=edge">
   <title>搜索结果展示</title>
</head>
<body>
   <table border="1">
       <tr>
           <td>ID</td>
           <td>用户名</td>

       </tr>
       <?php foreach   ($user as $key => $value) { ?>
           <tr>
               <td><?php echo $value["id"];?></td>
               <td><?php echo $value["name"];?></php></td>

           </tr>
   <?php } ?>

   </table>
</body>
</html>

<?php
use yii\widgets\LinkPager;
   echo LinkPager::widget([
       'pagination'=>$pagination,
       'nextPageLabel'=>'下一页',
       'firstPageLabel'=>'首页',
       ]
   )?>

橡皮擦Mid

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Yii框架搜索分页

controller: //搜索分页 public function actionList() { $where = Yii::$app->request->get();// var_dump($where); $query = new Query();//刚写成 $query = new\yii\db\Query
复制链接

扫一扫

专栏目录