laravel collection orderby code example

Example 1: laravel order by desc

$posts = Post::orderBy('id', 'DESC')->get();

Example 2: laravel order by

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

Example 3: orderby in laravel

/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Http\Response
 */
public function index()
{
    $messages = Message::select("*")
                            ->where('receiver_id',$id)
                            ->orderBy('created_at', 'desc')
                            ->get();
  
    dd($messages);
}

Example 4: laravel order by raw

$orders = DB::table('orders')
                ->orderByRaw('updated_at - created_at DESC')
                ->get();

Example 5: laravel sort collection

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

$sorted = $collection->sortDesc();

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

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

Example 6: 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],
    ]
*/