How to use 'IN (1,2,3)' with findAll?

activerecord yii
oldwizard picture oldwizard · May 10, 2011 · Viewed 22.2k times · Source

I need to get a couple of Students from the database, and I have their primary keys in a comma-separated string.

Normally using SQL it would be something like:

$cleanedStudentIdStringList = "1,2,3,4";
SELECT * FROM Student WHERE id IN ($cleanedStudentIdStringList)

Yii's ActiveRecord seems to insert a single quote around bound parameters in the resulting SQL statement which cause the query to fail when using parameter binding.

This works, but doesn't use safe parameter binding.

$students = Student::model()->findAll("id IN ({$_POST['studentIds']})");

Is there a way to still use parameter binding and get only a couple of rows in a single query?

Answer

Aleksy Goroszko picture Aleksy Goroszko · May 10, 2011

You can do it also that way:

$criteria = new CDbCriteria();
$criteria->addInCondition("id", array(1,2,3,4));
$result = Student::model()->findAll($criteria);

and use in array any values you need.

Aleksy

Related questions

Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models. SELECT * FROM users AS u WHERE u.user_id IN(1,5,8) AND (u.status = 1 OR u.verified = 1) OR (u.social_account = 1 AND …

Read More
Yii2 : Active Record add Not In condition

What is the active Record way of adding IN condition to an active Query in yii 1.x you could use CDbCriteria like this $cr = new CDbCriteria(); $cr->addNotInCondition('attribute', $array); There seem to be no equivalent API call in …

Read More
Yii selecting only specified attributes in array

I often face this problem.. Lets say ..In blog application, I need to email all the active users.. What I do is write findAll on users with some conditions of their last login being greater than some value..and get …

Read More