Yii Binding values for In Query

Question

Currently I am Using this query

$presentRecords=  Yii::app()->db
->createCommand()
->select('productId')
->from('exhibitorproducts')
->where(array('and',"exhibitorId=$exhibitorIdentity",
array('in','productId',$productRecords)))
->queryColumn();

But the problem with this query is that I am using $exhibitorIdentity and $productRecords directly. I think that it is dangerous. So how can i bind these values?

naveen goyal · Accepted Answer · 2013-12-27 10:45:45Z

2

Try this... for more http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder

$presentRecords=  Yii::app()->db
->createCommand()
->select('productId')
->from('exhibitorproducts')
->where("exhibitorId=:exhibitorId AND productId IN (:productId)", array(':exhibitorId'=>$exhibitorIdentity, ':productId' => $productRecords))
->queryColumn();

EDIT to

 $presentRecords=  Yii::app()->db
    ->createCommand()
    ->select('productId')
    ->from('exhibitorproducts')
    ->where(array("and","exhibitorId=:exhibitorId", array("in", "productId", ":productId")), array(':exhibitorId'=>$exhibitorIdentity, ':productId' => $productRecords))
    ->queryColumn();

edited Dec 27, 2013 at 10:45

answered Dec 27, 2013 at 10:13

naveen goyal

4,6272 gold badges18 silver badges26 bronze badges

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

2 Comments

Let me see Over a year ago

I tried it but its giving the false result. for IN (2,3) its returning result for only 2 and if i remove 2 from the query then its showing result for 3 :(

Let me see Over a year ago

$productRecords is an array(2,3) and so It throws error Array to string conversion for $productRecords.

Collectives™ on Stack Overflow

Yii Binding values for In Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related