我需要在yii2中从单个表的多个表字段中搜索

$data = \app\models\Events::find()->
         where(['event_code''event_name'[] =>$_POST['event_code''event_name'] ])->all();

return $this->render('search',['data'=>$data]);

Here I need to search from both event_code and event_name. How can I do it?

You can use andWhere to add multiple conditions

$data = \app\models\Events::find()->where(['=','event_code',$_POST['event_code']])->andWhere(['=','event_name',$_POST['event_name']])->all();

Try this :

$data = \app\models\Events::find()->where(['event_code' => $_POST['event_code'], 'event_name' => $_POST['event_name']])->all();