A. Method – 1
$users = DB::table('users')->get();
return view('user.index',['users'=>$users]);
B. Method – 2
$users = DB::table('users')->get();
foreach ($users as $user) {
echo $user->name;
}
C. Method – 3
$user = DB::table('users')->where('name', 'John')->first();
return $user->email; // fetch only first matching column
D. Method – 4
DB::table('users')->where('id', 1)->where('name', 'suraj')->orderBy('id', 'asce/dsc')->get();
DB::table('users')->where('id', 1)->orWhere('name', 'suraj')->orderBy('id', 'asce/dsc')->get();
$users = DB::table('users')->distinct()->get();
