使用条件或在cdbcriteria中

Question

Currently my code looks like that

    $criteria = new CDbCriteria();
    $criteria->compare('visible', 1);
    $criteria->compare('branch_id', $this->id);

What I want is to do something like that

`branch_id`='$this->id' OR `branch_id` is NULL

How to do it with compare function?

Answer 1

Yii condition <IS NULL>

So maybe you'd like to do

$idCrit = new CDbCriteria();
$idCrit->compare('branch_id', $this->id);
$idCrit->addCondition('branch_id is NULL', 'OR');

$criteria->mergeWith($idCrit);

Where $criteria holds all the other stuff?

Some further reading;

• http://www.yiiframework.com/doc/api/1.1/CDbCriteria#addCondition-detail
• http://www.yiiframework.com/doc/api/1.1/CDbCriteria#mergeWith-detail

(Look specifically at the $operator argument.)