$users = DB::table(‘users’)->get()
\n$user = DB::table(‘users’)->where(‘name’, ‘John’)->first();
\n$name = DB::table(‘users’)->where(‘name’, ‘John’)->pluck(‘name’);
\n$roles = DB::table(‘roles’)->lists(‘title’);
\n$roles = DB::table(‘roles’)->lists(‘title’, ‘name’);
\n$users = DB::table(‘users’)->select(‘name’, ’email’)->get();
\n$users = DB::table(‘users’)->distinct()->get();
\n$users = DB::table(‘users’)->select(‘name as user_name’)->get();
\n$query = DB::table(‘users’)->select(‘name’);
\n$users = $query->addSelect(‘age’)->get();
\n$users = DB::table(‘users’)->where(‘votes’, ‘>’, 100)->get();
\n$users = DB::table(‘users’)->where(‘votes’, ‘>’, 100)->orWhere(‘name’, ‘John’)->get();
\n$users = DB::table(‘users’)->whereBetween(‘votes’, array(1, 100))->get();
\n$users = DB::table(‘users’)->whereNotBetween(‘votes’, array(1, 100))->get();
\n$users = DB::table(‘users’)->whereIn(‘id’, array(1, 2, 3))->get();
\n$users = DB::table(‘users’)->whereNotIn(‘id’, array(1, 2, 3))->get();
\n$users = DB::table(‘users’)->whereNull(‘updated_at’)->get();
\n$users = DB::table(‘users’)->orderBy(‘name’, ‘desc’)->groupBy(‘count’)->having(‘count’, ‘>’, 100)->get();
\n$users = DB::table(‘users’)->skip(10)->take(5)->get();
\nDB::table(‘users’)->join(‘contacts’, ‘users.id’, ‘=’, ‘contacts.user_id’)
\n->join(‘orders’, ‘users.id’, ‘=’, ‘orders.user_id’)
\n->select(‘users.id’, ‘contacts.phone’, ‘orders.price’)
\n->get();
\nDB::table(‘users’)->leftJoin(‘posts’, ‘users.id’, ‘=’, ‘posts.user_id’)->get();
\nDB::table(‘users’)
\n->join(‘contacts’, function($join)
\n{
\n$join->on(‘users.id’, ‘=’, ‘contacts.user_id’)->orOn(…);
\n})
\n->get();<\/p>\n
DB::table(‘users’)
\n->join(‘contacts’, function($join)
\n{
\n$join->on(‘users.id’, ‘=’, ‘contacts.user_id’)
\n->where(‘contacts.user_id’, ‘>’, 5);
\n})
\n->get();<\/p>\n
select * from users where name = ‘John’ or (votes > 100 and title <> ‘Admin’)
\nDB::table(‘users’)
\n->where(‘name’, ‘=’, ‘John’)
\n->orWhere(function($query)
\n{
\n$query->where(‘votes’, ‘>’, 100)
\n->where(‘title’, ‘<>’, ‘Admin’);
\n})
\n->get();<\/p>\n
select * from users
\nwhere exists (
\nselect 1 from orders where orders.user_id = users.id
\n)
\nDB::table(‘users’)
\n->whereExists(function($query)
\n{
\n$query->select(DB::raw(1))
\n->from(‘orders’)
\n->whereRaw(‘orders.user_id = users.id’);
\n})
\n->get();
\n$users = DB::table(‘users’)->count();
\n$price = DB::table(‘orders’)->max(‘price’);
\n$price = DB::table(‘orders’)->min(‘price’);
\n$price = DB::table(‘orders’)->avg(‘price’);
\n$total = DB::table(‘users’)->sum(‘votes’);<\/p>\n
$first = DB::table(‘users’)->whereNull(‘first_name’);<\/p>\n
$users = DB::table(‘users’)->whereNull(‘last_name’)->union($first)->get();
\nDB::table(‘users’)->where(‘votes’, ‘>’, 100)->lockForUpdate()->get();
\n$users = DB::table(‘users’)
\n->select(DB::raw(‘count(*) as user_count, status’))
\n->where(‘status’, ‘<>’, 1)
\n->groupBy(‘status’)
\n->get();
\nDB::table(‘users’)->insert(
\narray(’email’ => ‘john@example.com’, ‘votes’ => 0)
\n);
\n$id = DB::table(‘users’)->insertGetId(
\narray(’email’ => ‘john@example.com’, ‘votes’ => 0)
\n);<\/p>\n
DB::table(‘users’)->insert(array(
\narray(’email’ => ‘taylor@example.com’, ‘votes’ => 0),
\narray(’email’ => ‘dayle@example.com’, ‘votes’ => 0),
\n));
\nDB::table(‘users’)->insert(array(
\narray(’email’ => ‘taylor@example.com’, ‘votes’ => 0),
\narray(’email’ => ‘dayle@example.com’, ‘votes’ => 0),
\n));<\/p>\n
DB::table(‘users’)->increment(‘votes’);<\/p>\n
DB::table(‘users’)->increment(‘votes’, 5);<\/p>\n
DB::table(‘users’)->decrement(‘votes’);<\/p>\n
DB::table(‘users’)->decrement(‘votes’, 5);
\nDB::table(‘users’)->increment(‘votes’, 1, array(‘name’ => ‘John’));
\nDB::table(‘users’)->where(‘votes’, ‘<‘, 100)->delete();
\nDB::table(‘users’)->delete();
\nDB::table(‘users’)->truncate();<\/p>\n
$first = DB::table(‘users’)->whereNull(‘first_name’);<\/p>\n
$users = DB::table(‘users’)->whereNull(‘last_name’)->union($first)->get();<\/p>\n
DB::table(‘users’)->where(‘votes’, ‘>’, 100)->sharedLock()->get();<\/p>\n
DB::table(‘users’)->where(‘votes’, ‘>’, 100)->lockForUpdate()->get();<\/p>\n
$users = DB::table(‘users’)->remember(10)->get();<\/p>\n
$users = DB::table(‘users’)->cacheTags(array(‘people’, ‘authors’))->remember(10)->get();<\/p>\n
Reference: Laravel online Documentation From: http:\/\/sitestree.com\/?p=4666
Categories:Laravel
Tags:
Post Data:2016-12-07 21:38:15<\/p>\n
\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a> $users = DB::table(‘users’)->get() $user = DB::table(‘users’)->where(‘name’, ‘John’)->first(); $name = DB::table(‘users’)->where(‘name’, ‘John’)->pluck(‘name’); $roles = DB::table(‘roles’)->lists(‘title’); $roles = DB::table(‘roles’)->lists(‘title’, ‘name’); $users = DB::table(‘users’)->select(‘name’, ’email’)->get(); $users = DB::table(‘users’)->distinct()->get(); $users = DB::table(‘users’)->select(‘name as user_name’)->get(); $query = DB::table(‘users’)->select(‘name’); $users = $query->addSelect(‘age’)->get(); $users = DB::table(‘users’)->where(‘votes’, ‘>’, 100)->get(); $users = DB::table(‘users’)->where(‘votes’, ‘>’, 100)->orWhere(‘name’, ‘John’)->get(); $users = DB::table(‘users’)->whereBetween(‘votes’, array(1, 100))->get(); $users = DB::table(‘users’)->whereNotBetween(‘votes’, … <\/p>\n
\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com<\/a>
\n\t\tIn Bengali: http:\/\/Bangla.SaLearningSchool.com<\/a>
\n\t\thttp:\/\/SitesTree.com<\/a>
\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>
\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"