Yii2 Array sorting

Question

In my Yii2 Project I have an array for example

$array = [];    
$array [] = 8 , 3, 6

So when I print out the array is

[8,3,6]

So when I use the same in a where statement it jumbles up.

$class = ModelClass::find()->where(['array_no' => $array])->all

So when I print out class I get the output in asc order sorted.. I get the information of

3 in the first
6 in the second place
8 in the third place.

How can i stop this from happening. I want them to return my output in the same order as array

but can you use orderBy like this stackoverflow.com/questions/28856562/order-by-field-in-yii2. Just create an expression with your array and pass it to order by statement. — Andrii Mishchenko
– Andrii Mishchenko, Commented Sep 7, 2016 at 9:34

soju · Accepted Answer · 2016-09-07 10:12:37Z

4

You should use ORDER BY FIELD(), e.g. :

$models = ModelClass::find()
  ->where(['array_no' => $array])
  ->orderBy(new \yii\db\Expression('FIELD (array_no, '.implode(',', $array).')'))
  ->all();

edited Sep 7, 2016 at 10:12

answered Sep 7, 2016 at 9:35

soju

25.4k3 gold badges70 silver badges71 bronze badges

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

1 Comment

Mohan Prasad Over a year ago

Yea but it throws me a undefine function call when I use yii/db/expression

Collectives™ on Stack Overflow

Yii2 Array sorting

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related