collection order by laravel code example

Example 1: laravel order by

$users = DB::table('users')
         -> orderBy('name', 'desc')
         -> get();

Example 2: laravel sort collection

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

$sorted = $collection->sortDesc();

$sorted->values()->all();

// [5, 4, 3, 2, 1]

Example 3: laravel sort collection by key

$collection = collect([
    ['name' => 'Desk', 'price' => 200],
    ['name' => 'Chair', 'price' => 100],
    ['name' => 'Bookcase', 'price' => 150],
]);

$sorted = $collection->sortBy('price');

$sorted->values()->all();

/*
    [
        ['name' => 'Chair', 'price' => 100],
        ['name' => 'Bookcase', 'price' => 150],
        ['name' => 'Desk', 'price' => 200],
    ]
*/

Example 4: pluck laravel

$name = DB::table('users')->where('name', 'John')->pluck('name');