Yii2同时搜索多个字段

Yii2同时搜索多个字段

Yii2中搜索字段是用的andFilterWhere这个方法，用它可以搜索一个一段。

如果是搜索多个字段的话 ，比如搜索文章标题和文章内容是是否包含需要搜索的关键词，因为他们两个的关系是or，所以就要用到orFilterWhere这个方法

下面就是全部的代码

1. public function actionIndex()
2. {
3. $key =Yii::$app->request->post("key");
4.  
5. $query = Post::find()->joinWith("cate");
6. $post = $query->orderBy(["post.id" => SORT_DESC])->asArray()->where(["post.status" => 1]);
7. if($key){
8. $post->andFilterWhere(["like", "post.title", $key])
9. ->orFilterWhere(["like", "post.content", $key]);
10. }
11.  
12. $pages = new Pagination([
13. "totalCount" => $post->count(),
14. "defaultPageSize" => 10
15. ]);
16. $model = $post->offset($pages->offset)->limit($pages->limit)->all();
17.  
18. return $this->render("index", [
19. "model" => $model,
20. "pages" => $pages,
21. ]);
22. }

可以看到sql语句如下

select count(*) from `post` left join `category` on `post`.`cate_id`=`category`.`id` where ((`post`.`status`=1) and (`post`.`title` like "%key%")) or (`post`.`content` like "%key%") order by `post`.`id` desc

select `post`.* from `post` left join `category` on `post`.`cate_id`=`category`.`id` where ((`post`.`status`=1) and (`post`.`title` like "%key%")) or (`post`.`content` like "%key%") order by `post`.`id` desc limit 10