yii2 多条件搜索

最新推荐文章于 2023-12-27 19:33:35 发布

青春已被放纵了

最新推荐文章于 2023-12-27 19:33:35 发布

阅读量2.5k

点赞数

分类专栏： yii2 文章标签： yii yii2

本文链接：https://blog.csdn.net/qq_36373262/article/details/53782516

版权

yii2 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

第一种

$where=\Yii::$app->request->get();
//        print_r($where);die;
        $query=new Query();
        $query->from('title');
        if(!empty($where['descnum'])||!empty($where['title'])){
            $query->Where(['descnum'=>$where['descnum']])
                  ->orWhere(['title'=>$where['title']]);
        }

//        print_r($where);die;
        $arr=$query->from('title')->all();
        $pages = new Pagination(['totalCount' =>$query->count(),'pageSize'=>'3']);
        $arr = $query->offset($pages->offset)->limit($pages->limit)->all();
        return  $this->render('index',['arr'=>$arr,'where'=>$where,'pages'=>$pages]);

第二种

$where= 1 ;
        if(!empty($descnum)){
            $where.=" and descnum like '%$descnum%'";
        }
        if(!empty($name)){
            $where.=" and name like '%$name%'";
        }
//        print_r($where);die;
        $arr=Yii::$app->db->createCommand("select * from title where $where ORDER BY descnum desc ")->queryAll();
//        print_r($arr);die;
        return $this->render("index",['arr'=>$arr,'where'=>$where]);

分页
<?php
echo LinkPager::widget([
        'pagination'=>$pages,
    'nextPageLabel'=>'下一页',
    'prevPageLabel'=>'上一页',
    'firstPageLabel'=>'首页'])
?>

搜索
<?php
$form=ActiveForm::begin([
    'action'=>Url::toRoute(['index']),
    'method'=>'get',
]);
echo '姓名：'.Html::input('text','descnum');
echo "<br/>";
echo "<br/>";
echo '姓名：'.Html::input('text','title');
echo "<br/>";
echo "<br/>";
echo Html::submitButton();

ActiveForm::end();echo "<br/>";
?>