Yii2 realizes the method of searching multiple fields at the same time-PHP Tutorial-php.cn

Yii2 realizes the method of searching multiple fields at the same time

不言

Release： 2023-03-25 16:46:01

Original

1591 people have browsed it

This article mainly introduces the method of Yii2 to realize simultaneous search of multiple fields. It analyzes the functions and specific usage methods used in Yii2 to search multiple fields at the same time in the form of examples. Friends in need can refer to the following

The example in this article describes how Yii2 implements simultaneous search of multiple fields. Share it with everyone for your reference, the details are as follows:

The search field in Yii2 uses the andFilterWhere method, which can be used to search for a paragraph.

If you are searching for multiple fields, for example, searching whether the article title and article content contain the keywords you need to search for, because the relationship between them is or, so you need to use orFilterWhereThis method

The following is all the code

public function actionIndex()
{
  $key =Yii::$app->request->post("key");
  $query = Post::find()->joinWith(&#39;cate&#39;);
  $post = $query->orderBy([&#39;post.id&#39; => SORT_DESC])->asArray()->where([&#39;post.status&#39; => 1]);
  if($key){
    $post->andFilterWhere([&#39;like&#39;, &#39;post.title&#39;, $key])
      ->orFilterWhere([&#39;like&#39;, &#39;post.content&#39;, $key]);
  }
  $pages = new Pagination([
    &#39;totalCount&#39; => $post->count(),
    &#39;defaultPageSize&#39; => 10
  ]);
  $model = $post->offset($pages->offset)->limit($pages->limit)->all();
  return $this->render(&#39;index&#39;, [
    &#39;model&#39; => $model,
    &#39;pages&#39; => $pages,
  ]);
}

Copy after login

You can see the sql statement as follows:

Copy code The code is as follows:

select count(*) from `post` left join `category` on `post`.`cate_id`=`category`.`id` where ((`post`.`status`=1) and (`post`.`title` like &#39;%key%&#39;)) or (`post`.`content` like &#39;%key%&#39;) 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 &#39;%key%&#39;)) or (`post`.`content` like &#39;%key%&#39;) order by `post`.`id` desc limit 10

Copy after login

Related recommendations:

Yii implements two methods of adding default values to models

The above is the detailed content of Yii2 realizes the method of searching multiple fields at the same time. For more information, please follow other related articles on the PHP Chinese website!