Imran Imran - 1 year ago 109
PHP Question

Sort collection by custom order in Eloquent

I have an array of ID's as follows:

$ids = [5,6,0,1]

Using Eloquent I am able to search for these Id's using the
->whereIn('id', $ids)
function. This as expected will return the results in the ascending order by Id, is there a way I can return the results on the order the array is in? alternatively whats the easiest way to convert the collection in the order of the

snh snh
Answer Source

If there's a specific order you'd like the records in, you'd have to use the Collection Methods:

To get your ID's in the very specific order you've specified, you can make use of the sortBy method as follows, where collection is your collection of models:

$ids = [ 5, 6, 0, 1];

$sorted = $collection->sortBy(function($model) use ($ids) {
    return array_search($model->getKey(), $ids);

// [ 5, 6, 0, 1] // (desired order)

To randomize your collection you can make use of the shuffle method.

$collection = collect([1, 2, 3, 4, 5]);

$shuffled = $collection->shuffle();


// [3, 2, 5, 1, 4] // (generated randomly)

See the Laravel Docs on shuffle and/or sortBy for more specific requirements.

If you don't really have a specific order in mind, you can use ->inRandomOrder() in version 5.2 and up, older versions would require the raw query using ->orderBy(DB::raw('RAND()')).

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download