Multiple Condition In Dataprovider()

Yii 1.1 General Discussion
1

$dataProvider->criteria->addcondition(‘company_code= :id’)->params[’:id’] = $company;

I want to add another ‘AND’ condition; where ‘function_code’= ‘abc’.

how to do it?

i tried adding

$dataProvider->criteria->addcondition(‘function_code= :id’)->params[’:id’] = ‘abc’;

But it doesnt show any record from database

I am new to yii. need help please.

2

Hello, welcome to the forum.

Try this:




$dataProvider->criteria->addcondition('company_code= :id')->params[':id'] = $company;

$dataProvider->criteria->addcondition('function_code= :id2')->params[':id2'] = 'abc';

Or, I’d rather do it like this:




$dataProvider->criteria->compare('company_code', $company);

$dataProvider->criteria->compare('function_code', 'abc');

http://www.yiiframework.com/doc/api/1.1/CDbCriteria#compare-detail