Build Yii2 Search Query

Question

I am trying to build the query for search, here it is

        $searchResult = Candidate::find()
        ->select('HRMS_candidateID, HRMS_candidateFirstName','HRMS_candidateMiddleName')
        ->where(['LIKE', 'HRMS_candidatePrimarySkills', $keywordsArrayTrimed[$i]])

        ->all();

As I have $keywordsArrayTrimed[$i] which contains keywords, the number count of keywords is different on each request how to achieve this.

I have tried using for loop, it throes an error Unexpected for loop.

I tired using filter Like this

 $searchResult->andFilterWhere([
            'or',
            ['like', 'HRMS_candidatePrimarySkills', $keywordsArrayTrimed[$i]],

        ]);

It didn't work. Please Help.

Show us your loop, and add details about $keywordsArrayTrimed — soju, Feb 18 '16 at 09:18
@soju Thanks and I will take care next time before post any question. — Piyush, Feb 18 '16 at 10:04

score 1 · Accepted Answer · answered Feb 18 '16 at 09:37

You should simply try this :

// build condition
$condition = ['or'];
foreach ($keywordsArrayTrimed as $keyword) {
    $condition[] = ['like', 'HRMS_candidatePrimarySkills', $keyword];
}

// fetch results
$searchResult = Candidate::find()->where($condition)->all();

Build Yii2 Search Query

1 Answers1