Yii: Using MySQL\'s IN condition with Active Record

Revision: 57976

at June 19, 2012 00:42 by drock

Updated Code

$criteria = new CDbCriteria();
$criteria->condition = 'start=:startID AND end=:endID';
$criteria->params = array(':startID'=>$activeProfileID,':endID'=>$pageID);
$criteria->addInCondition('status',array(6,7));		
$results = GraphEdge::model()->findAll($criteria);

//OR

$theEdge = new GraphEdge();
$results = $theEdge->findAllByAttributes(array('start'=>$activeProfileID,'end'=>$pageID,'status'=>array(6,7)));

Revision: 57975

at June 19, 2012 00:40 by drock

Updated Code

$criteria = new CDbCriteria();
$criteria->condition = 'start=:startID AND end=:endID';
$criteria->params = array(':startID'=>$activeProfileID,':endID'=>$pageID);
$criteria->addInCondition('status',array(6,7));		
$currentVerifies = GraphEdge::model()->findAll($criteria);

//OR
$theEdge = new GraphEdge();
$currentVerifies = $theEdge->findAllByAttributes(array('start'=>$activeProfileID,'end'=>$pageID,'status'=>array(6,7)));

Revision: 57974

at June 19, 2012 00:13 by drock

Initial Code

$criteria = new CDbCriteria();
$criteria->condition = 'start=:startID AND end=:endID';
$criteria->params = array(':startID'=>$activeProfileID,':endID'=>$pageID);
$criteria->addInCondition('status',array(6,7));		
$currentVerifies = GraphEdge::model()->findAll($criteria);

Initial URL

Initial Description

When working with your model's search function or just grabbing some data with findAll, you can't add an IN condition to your condition clause. Fail:
<code>$criteria->condition = 'start=:startID AND end=:endID AND status IN (1,2,3)';</code> 

Instead, use addInCondition:

Initial Title

Yii: Using MySQL\'s IN condition with Active Record

Initial Tags

Initial Language

PHP

Choose a language for easy browsing: