yii2 ActiveRecord multiple where

Question

I want to make multiple where query, with both < and = operators.

With multiple = operators it goes like:

Model::find()->where([
    'param1' => 0,
    'param2' => 0,
])->all();

With one < operator

Model::find()->where([
    '<', 'param1', 0
])->all();

How can I apply both these conditions in one where array?

ScaisEdge · Accepted Answer · 2016-11-24 12:23:47Z

8

You can use a combination of where andWhere

   Model::find()->where([param1' => 0 ])
          ->andWhere(['>','param2' , 0])->all();

adding the operator to you clause see operator format

answered Nov 24, 2016 at 12:23

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bizley · Accepted Answer · 2016-11-24 12:22:15Z

4

Model::find()->where([
    'and',
    [
        'param1' => 0,
        'param2' => 0,
    ],
    ['<', 'param1', 0]
])->all();

answered Nov 24, 2016 at 12:22

Bizley

18.1k6 gold badges53 silver badges62 bronze badges