laravel sortby code example

Example 1: laravel order by

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

Example 2: 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 3: collection laravel filter

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

$filtered = $collection->filter(function ($value, $key) {
    return $value > 2;
});

$filtered->all();

// [3, 4]

Example 4: laravel 6 orderby

// Make sure column names are correct
$inquiries = Inquiry::orderBy('status', 'ASC')
    ->orderBy('created_at', 'DESC')
    ->get();

Example 5: get all sort by laravel

$results = Project::orderBy('name')->get();

Example 6: laravel sort collection

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

$sorted = $collection->sortDesc();

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

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