adding both equal and not equal conditions in Yii

php activerecord yii equals-operator
user3894236 picture user3894236 · Aug 27, 2014 · Viewed 9.2k times · Source 
$id = Yii::app()->user->getState("logId");
$name = Yii::app()->user->getState("username"); 

$dataProvider=Disnotification::model->findAllByAttributes(array('logID' => $id,'username'!=$name));

How can I find records which equals to $id but not equals to $name?

Answer

Developerium picture Developerium · Aug 27, 2014 
$criteria = new CDbCriteria();
$criteria->compare('logID' , $id);
$criteria->addCondition('username != :username');
$criteria->params[ ':username' ] = $name;

$dataProvider = Disnotification::model()->findAll( $criteria );

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
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
How to do IS NULL and IS NOT NULL with Yii 2 ActiveRecord?

I have a table which has a field `activated_at` timestamp NULL DEFAULT NULL, which means that it can contain a timestamp or it can be null and it's null by default. I have another [gii-generated] search model with a …

Read More