Passing an array of condition to query where method in Yii2

Question

How can I pass two conditions to the method of query which is where? I tried using $query->where($cond[0]), it worked but on $query->where($cond[1]) it gives an error of undefined offset.

public function search($params, $cond)
{
    $query = ServiceStatuses::find();

    $dataProvider = new ActiveDataProvider([
        'query' => $query,
        'sort' => ['defaultOrder' => ['last_hard_state' => SORT_DESC]],
    ]);

    $this->load($params);

    .
    .
    .

    $query->where($cond[0]);      //<<<<----- This works
    $query->where($cond[1]);      //<<<<----- Undefined offset: 1

    return $dataProvider;
}

public function searchIncidents($params)
{
    $cond = array (['last_hard_state' => 0, 'last_hard_state' => 2]);
    $dataProvider = $this->search($params, $cond);
    return $dataProvider;
}

Michael Walton · Accepted Answer · 2015-12-23 01:35:21Z

2

Your $cond variable is creating an array within an array; you're using both array() and shorthand syntax [] (added in PHP 5.4). If you only intend $cond to be a single level array, remove one of the array calls. Either

$cond = ['last_hard_state' => 0, 'last_hard_state' => 2];

or

$cond = array('last_hard_state' => 0, 'last_hard_state' => 2);

edited Dec 23, 2015 at 1:35

answered Dec 23, 2015 at 1:29

Michael Walton

1361 silver badge8 bronze badges

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

6 Comments

Gibs Over a year ago

Hi! thanks, this fixed the undefined offset but I noticed that the last condition is only evaluated. How can I query both conditions?

Michael Walton Over a year ago

Try changing $query->where($cond[0]); to $query->where($cond); and remove the second where call. since you want to query both. $cond[0] or $cond[1] will only pick one of those out of the array.

Gibs Over a year ago

I tried using $query->where($cond); but it only evaluates the last part, which is on your example is 'last_hard_state' => 2 only

Michael Walton Over a year ago

Oh duh, I didnt even see that the keys in the array were the same. The second key is overwriting the first since they're the same, which is only evaluating the last one. Can you tell me what the where clause is supposed to do? WHERE last_hard_state = 0 OR last_hard_state = 2 maybe?

Michael Walton Over a year ago

Sure, I'm looking at github.com/yiisoft/yii2/blob/master/docs/guide/… Looks like you can change the array to something like ['or', 'last_hard_state=0', 'last_hard_state=2'] and that should generate last_hard_state = 0 OR last_hard_state = 2

|

Collectives™ on Stack Overflow

Passing an array of condition to query where method in Yii2

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related