How to organize a search?

Question

Yii

there is a table lookup that gii has generated.

public function search($params)
    {
        $query = FaqCategory::find();

        // add conditions that should always apply here

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        $this->load($params);

        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }

        // grid filtering conditions
        $query->andFilterWhere([
            'id' => $this->id,
        ]);

        $query->andFilterWhere(['like', 'name', $this->name]);

        return $dataProvider;
    }

Thus, if the database contains the word "personnel" and the user writes the word "frame", then everything is fine, but if you enter "frames", it no longer finds it. please tell me how to implement this

Answer 1

Use elasticksearch or sphinx

Answer 2

If it’s simple, then you can hang fulltext index on name, but I don’t remember how it is with lems.