laravel order 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 6 orderby

$inquiries = Inquiry::all()->sortByDesc('created_at')->sortByDesc('Status')->values();

Example 5: laravel 8 orderby

$flights = App\Models\Flight::where('active', 1)
               ->orderBy('name', 'desc')
               ->take(10)
               ->get();

Example 6: query builder laravel

use Illuminate\Database\Eloquent\Builder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}

Tags:

Sql Example