yii2 多条件搜索

第一种

$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/>";
?>