how to query record with multiple condition using yii framework

Question

I want to get all the results satisfy (age=20, name=jim) or (age=30, name=allen) or (age=40, name=sam), how to write the query code with yii?

call $query->orWhere('age' => xx, 'name' => yy) in a foreach block, it works but not graceful enough — fireboy
– fireboy, Commented Jun 14, 2016 at 10:10

Andrey · Accepted Answer · 2016-06-14 11:34:04Z

2

if you use yii 1:

$criteria = new CdbCriteria();
$criteria->addCondition('age = :age1 AND name = :name1', 'OR');
$criteria->addCondition('age = :age2 AND name = :name2', 'OR');
$criteria->addCondition('age = :age3 AND name = :name3', 'OR');
$criteria->params = [
    ':age1' => 20,
    ':age2' => 30,
    ':age3' => 40,
    ':name1' => 'jim',
    ':name2' => 'allen',
    ':name3' => 'sam',
];
$result = YourModelName::model()->findAll($criteria);

answered Jun 14, 2016 at 11:34

Andrey

4412 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fireboy Over a year ago

what if I add a constrain sex=male

Insane Skull · Accepted Answer · 2016-06-14 12:53:24Z

1

If you use yii2

$query->orWhere(['AND',
                  ['age' => 20],
                  ['name' => 'jim']
                ])
      ->orWhere(['AND',
                  ['age' => 30],
                  ['name' => 'allen']
                ])
      ->orWhere(['AND',
                  ['age' => 40],
                  ['name' => 'sam']
                ])
     ->all();

answered Jun 14, 2016 at 12:53

Insane Skull

9,3619 gold badges49 silver badges66 bronze badges

Collectives™ on Stack Overflow

how to query record with multiple condition using yii framework

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related