Laravel Sort Collection By Dynamic ID array [duplicate]

Question

I have the following...

$people = array(5, 2, 9, 6, 11);

$people_collection = People::find($people);

But when I dump and die $people_collection the collection is ordered by the ID ASC, how can I keep the collection, in the same order as the $people array?

This is because find internally calls mysql IN clause which returns the rows in ascending order of the Ids passed. You can manually sort the array or use the method explained by Jannie. — pioneer
– pioneer, Commented Jul 25, 2016 at 18:33

Jannie Theunissen · Accepted Answer · 2016-07-25 18:19:48Z

9

Collections has a sortBy function that takes a custom callback:

$people_collection = People::find($people)
   ->sortBy(function($person, $key) use($people) {
         return array_search($person->id, $people);
      });

See the docs.

answered Jul 25, 2016 at 18:19

Jannie Theunissen

30.3k21 gold badges110 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

Laravel Sort Collection By Dynamic ID array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related