How to implement search by site sections in yii2?

Question

Yii

I ask in advance ... do not throw tomatoes in the comments (
I want to do a search on the site, taste how it's done, so to speak. There are 10 sections on the site, I want to do a search for everything directly. only in one category and not looking in others
Here is the code,

class SearchController extends Controller {
    
    public function actionSearch() {
        $q = Yii::$app->request->get('q');
        $query = Extrime::find()->where(['like', 'title', $q]);
        $countQuery = clone $query;
        $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => 2]);
        $models = $query->offset($pages->offset)
            ->limit($pages->limit)
            ->all();
        return $this->render('search',compact('post','models','q','cat','friend'));
        
    }
    
}

How can I transform, or rather, how can I add more search terms? If you add right now as is, then it will overwrite the variable. How can I add more search terms for other sections?

Answer 1

You need some separate storage (a table in the database) that will contain the following data:
1. entity type (essentially the name of the corresponding table or model)
2. entity id
3. text that will be searched for
Entity type and id fields are needed to link the found elements with real pages of your site.
Such a place for searching can be either a separate plate in the database or a separate database of the Elasticsearch type.
You will need to fill this table once and then update it every time you change the data on which you want to search.

Answer 2

it is not necessary to fence a bicycle and to do search by means of a DB project (as far as I understand it at you relational). Take a better ready-made solution such as Sphinx or ElasticSearch