Geek Answers Handbook

Using find () in Active Record with multiple where clauses

I want to split (using brackets) after an Active Record query into 3 groups. The first group will be from the first sentence "Where" to the last or "Where." The second and third will use "andWhere".

Please give me tips on how to use parentheses to separate all three sections.

$query = Book::find()
->where('book_name LIKE :book_name', array(':book_name' => 
'%'.$book_name.'%'))
->orWhere('book_category LIKE :book_category', array(':book_category' =>'%'.$category.'%'))
->orWhere('finance_subcategory LIKE :finance', array(':finance' => '%'.$category.'%'))
->orWhere('insurance_subcategory LIKE :insurance', array(':insurance' => '%'.$category.'%'))
->andWhere('address LIKE :address', array(':address' => '%'.$address.'%'))
->andWhere('status =:status', array(':status' => 'Enabled'))
->orderBy('book_id');
+4
source share
1 answer

You can do this:

$query = Book::find()
    ->where([
        'or',
        ['like', 'book_name', $book_name],
        ['like', 'book_category', $category],
        ['like', 'finance_subcategory', $category],
        ['like', 'insurance_subcategory', $category],
    ])
    ->andWhere(['like', 'address', $address])
    ->andWhere(['status' => 'Enabled'])
    ->orderBy('book_id');

I also reorganized it for you to make it look more readable. Do not use such concatenation, this is not good practice.

See white papers .

+13

More articles:


All Articles