laravel eloquent order by code example

Example 1: order By Asc in laravbel

->orderBy('id', 'DESC');

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: eloquent model sort by ascending order

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

Example 5: laravel create model and migration

# If you would like to generate a database migration when you 
# generate the model, you may use the --migration or -m option:

php artisan make:model Flight --migration
php artisan make:model Flight -m

Example 6: laravel OrderBy on Eloquent whereHas relationship

$counties = County::whereHas('items', function ($query) {
    $query->where('approved', 1);
})->orderBy('name')->get();