Array variable as parameter in criteria for CActiveDataProvider

Yii 1.1 General Discussion
1

Hi Everyone,

I’d like to ask about passing an array as params for criteria in CActiveDataProvider.

Here’s my code:




		$suggestedPartsDataProvider=new CActiveDataProvider('Parts', array(

				'criteria'=>array(

						'condition'=>'id IN (=:ids)',

						'params'=>array(':ids'=>$suggestedPartsId)

				),

				'pagination'=>array(

						'pageSize'=>15,

				)));

$suggestedPartsId is an array of selected Parts Id based on a mathematical formula. It’s like I have a list of Parts Id and I want to include that on my query for my dataProvider.

Thanks!

2

criteria could be an object too .







$criteria=new CDbCriteria;


$criteria->addInCondition('id', $suggestedPartsId);


 $suggestedPartsDataProvider=new CActiveDataProvider('Parts', array(

                                'criteria'=>$criteria,

                                'pagination'=>array(

                                                'pageSize'=>15,

                                )));

:lol:

3

Thanks! It’s now working.

4

here this should do it




$criteria = new CDbCriteria;

$criteria->addInCondition('id', array(1, 2, 3)); // replace the array with your array


 $suggestedPartsDataProvider=new CActiveDataProvider('Parts', array(

                                'criteria'=>$criteria,

                                'pagination'=>array(

                                                'pageSize'=>15,

                                )));
5

hell i was writing the code and replayed already sorry buddy

6

That’s alright. Thanks too!