How to add condition with And as well as OR operator

Yii 1.1 General Discussion
1

I want to add conditions like that -

(Condition A) AND (Condition B OR Condition C)

How can I do this using addCondition??

2

use two CDbCriteria and mergeWith():




$criteria = new CDbCriteria();

$criteria->addCondition('condition A');


$criteria2 = new CDbCriteria();

$criteria2->addCondition('condition B');

$criteria2->addCondition('condition C', 'OR');


$criteria->mergeWith($criteria2);


echo $criteria->condition; // (condition A) AND ((condition <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='B)' /> OR (condition C))
3

I didn’t know that. Interesting… Is the only way to do this using mergeWith?

4

You could simply just add both conditions inside the 2nd addCondition() call




$criteria = new CDbCriteria();

$criteria->addCondition('condition A');

$criteria->addCondition('condition B OR condition C');
5

Thanks a lot @georaldc

It’s too easy way to handle such types of conditions…