How to use not equal to inside a Yii2 query

yii2
Bloodhound picture Bloodhound · Jun 25, 2015 · Viewed 83.3k times · Source

I want to use a yii2 query in which I want to check a not equal to condition. I tried like this but it didn't give the desired results. How do I do it?

$details =  MovieShows::find()
   ->where(['movie_id'=>$id])
   ->andWhere(['location_id'=>$loc_id])
   ->andWhere(['cancel_date'=>!$date])
   ->all();

Answer

Tony picture Tony · Jun 25, 2015

In this case you need to use operator format: [operator, operand1, operand2, ...]. So your code should look like this:

$details = MovieShows::find()
           ->where(['movie_id'=>$id])
           ->andWhere(['location_id'=>$loc_id])
           ->andWhere(['<>','cancel_date', $date])
           ->all();

More about using where method and operator format

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 redirect in controller action does not work?

I am posting a form to /user/save in order to save user data. The problem occurs when i try to redirect the user if the $_SERVER['REQUEST_METHOD'] is NOT 'post'. My user controller code namespace app\controllers; use …

Read More