Laravel query for select and update delete in database
$users = DB::table('users')->get();
$user = DB::table('users')->where('name', 'shivam')->first();
$user_id = DB::table('users')->where('name', 'shivam')->pluck('id');
$users = DB::table('users')->select('name', 'email')->get();
$users = DB::table('users')->where(id, '<', 10)->get();
$users = DB::table('users')->whereBetween('id', array(10, 20))->get()
DB::select(DB::raw(“SELECT * FROM `users` WHERE name = ‘$name’ ”));
DB::select(DB::raw("SELECT * FROM `users` WHERE `name` = :username"), array('username' => $name));
$model = User::findOrFail(1);
$model = User::where('id', '>', 5)->firstOrFail();
$group = Group::find(1);
$group->name = ‘Group01’;
$group->save();
Group::where('name', '=', ‘Group01’)-date(array('name' => ‘Group1’));
$group = Group::find(1);
$group->delete();
$links = Link::all(['id', 'url', 'description'])->toArray();
$list = LinkList::where('slug', $slug)->first();
