yii2 active record find column not equal

php yii2
Sarvar Nishonboev picture Sarvar Nishonboev · Apr 9, 2014 · Viewed 47k times · Source

I have this code to find a user from db which status is active and role is user

public static function findByUsername($username)
{
 return static::find(['username' => $username, 'status' => static::STATUS_ACTIVE, 'role'=>'user']);
}

I need to find a user that role is not equal to "user". How can I do this?

P.S: I'm using YII2

Answer

Alex picture Alex · Apr 9, 2014

I want to offer another solution, it's more elegant for me. I usually use this approach since Yii 1 when i need check not equal operation.

$models = Book::find()->where('id != :id and type != :type', ['id'=>1, 'type'=>1])->all();

Related questions

How to make a drop down list in yii2?

How to make a dropdown in yii2 using an activeform and a model? Since all the methods has changed in yii2,how it is done in the new one?

Read More
How to get root directory in yii2

yii2 Question My yii2 install in d:\wamp\www\yii2store I want to get above path to save images which will be uploaded by me or users. I have pass all available arguments in Yii::getAlias('@webroot') (below …

Read More
Yii2 data provider default sorting

In Yii 1.1 this code works for default sorting: $dataProvider = new CActiveDataProvider('article',array( 'sort'=>array( 'defaultOrder'=>'id DESC', ), )); How default sorting can be set in Yii2? Tried below code, but no result: $dataProvider = new ActiveDataProvider([ 'query' => $query, …

Read More