Cdbcommand binding array for SQL IN clause

Archives Feature Requests
1

I want to have something like




$some_values = array(1,2,3,4,5);

Yii::app()->getDb()->createCommand('SELECT x FROM y WHERE z in (:p1)')->bindValuesForInClause(':p1'=>$some_values)->queryAll();
2

use findAll()

3

Not an answer.

I have some really huge queries with some IN clauses written on pure pl/sql.AR not a solution here.

4

If you can use the query builder, http://www.yiiframework.com/doc/api/1.1/CDbCommand#where()-detail

5

Maybe idea from Stackoverflow will be helpful.

6

Thanks for replies.

BUT is this will not be useful if yii will do it automatically?

7

This functionallity included in Yii2

https://github.com/yiisoft/yii2/blob/master/docs/guide/query-builder.md

8

Having come across this problem a few times in my projects I have come-up with the following Yii work-around using CDbCriteria which is a little hacky, but gives the security of param count matching.

When applied to your example my code would be:


$some_values = array(1,2,3,4,5);

$criteria = new CDbCriteria();

$criteria->addInCondition('z',$some_values);


$sql = 'SELECT x FROM y WHERE '.$criteria->condition;

$command = Yii::app()->db->createCommand($sql);

$results = $command->queryAll(true, $criteria->params);