php - Issue in building search with like query using QueryBuilder yii2 -
i trying make search query website blogs using yii2 querybuilder , there error when try execute query ->all() . here error : strtr() expects parameter 1 string, object given . , here model , controller . have no idea causing problem .
controller :
public function actionsearchblog() { $model = new blog(); if ($model->load(yii::$app->request->post())) { blog::searchblog($model->search); } else { return $this->render('search',['model' => $model]); } } model :
public static function searchblog($search = null) { $search = new query(); $result = $search->select('id','title','blog','picture') ->from('blog') ->where(['like' , 'title' , $search]) ->orwhere(['like' , 'blog' , $search]) ->all(); echo '<pre>'; var_dump($result); die(); } i tried query without ->all() @ end , var_dump value the query , won't executed . , ->all() error.
public static function searchblog($search = null) { $query = new query(); $result = $query->select('id','title','blog','picture') ->from('blog') ->where(['like' , 'title' , $search]) ->orwhere(['like' , 'blog' , $search]) ->all(); echo '<pre>'; var_dump($result); die(); } this work. start using ide, , watch on variables using.
Comments
Post a Comment