laravel order by code example

Example 1: laravel order by desc

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

Example 2: order By Asc in laravbel

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

Example 3: laravel order by

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

Example 4: 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 5: laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Example 6: laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();