| 1 |
DB::connection('connection_name'); |
| 2 |
$results = DB::select('select * from users where id = ?', [1]); |
| 3 |
$results = DB::select('select * from users where id = :id', ['id' => 1]); |
| 4 |
DB::statement('drop table users'); |
| 5 |
DB::listen(function($sql, $bindings, $time){ code_here; }); |
| 6 |
DB::transaction(function() |
| 7 |
{ |
| 8 |
DB::table('users')->update(['votes' => 1]); |
| 9 |
DB::table('posts')->delete(); |
| 10 |
}); |
| 11 |
DB::beginTransaction(); |
| 12 |
DB::rollback(); |
| 13 |
DB::commit(); |
| 14 |
Query Builder |
| 15 |
DB::table('name')->get(); |
| 16 |
DB::table('users')->chunk(100, function($users) |
| 17 |
{ |
| 18 |
foreach ($users as $user) |
| 19 |
{ |
| 20 |
} |
| 21 |
}); |
| 22 |
$user = DB::table('users')->where('name', 'John')->first(); |
| 23 |
DB::table('name')->first(); |
| 24 |
$name = DB::table('users')->where('name', 'John')->pluck('name'); |
| 25 |
DB::table('name')->pluck('column'); |
| 26 |
$roles = DB::table('roles')->lists('title'); |
| 27 |
$roles = DB::table('roles')->lists('title', 'name'); |
| 28 |
$users = DB::table('users')->select('name', 'email')->get(); |
| 29 |
$users = DB::table('users')->distinct()->get(); |
| 30 |
$users = DB::table('users')->select('name as user_name')->get(); |
| 31 |
$query = DB::table('users')->select('name'); |
| 32 |
$users = $query->addSelect('age')->get(); |
| 33 |
$users = DB::table('users')->where('votes', '>', 100)->get(); |
| 34 |
$users = DB::table('users') |
| 35 |
->where('votes', '>', 100) |
| 36 |
->orWhere('name', 'John') |
| 37 |
->get(); |
| 38 |
$users = DB::table('users') |
| 39 |
->whereBetween('votes', [1, 100])->get(); |
| 40 |
$users = DB::table('users') |
| 41 |
->whereNotBetween('votes', [1, 100])->get(); |
| 42 |
$users = DB::table('users') |
| 43 |
->whereIn('id', [1, 2, 3])->get(); |
| 44 |
$users = DB::table('users') |
| 45 |
->whereNotIn('id', [1, 2, 3])->get(); |
| 46 |
$users = DB::table('users') |
| 47 |
->whereNull('updated_at')->get(); |
| 48 |
DB::table('name')->whereNotNull('column')->get(); |
| 49 |
$admin = DB::table('users')->whereId(1)->first(); |
| 50 |
$john = DB::table('users') |
| 51 |
->whereIdAndEmail(2, 'john@doe.com') |
| 52 |
->first(); |
| 53 |
$jane = DB::table('users') |
| 54 |
->whereNameOrAge('Jane', 22) |
| 55 |
->first(); |
| 56 |
$users = DB::table('users') |
| 57 |
->orderBy('name', 'desc') |
| 58 |
->groupBy('count') |
| 59 |
->having('count', '>', 100) |
| 60 |
->get(); |
| 61 |
DB::table('name')->orderBy('column')->get(); |
| 62 |
DB::table('name')->orderBy('column','desc')->get(); |
| 63 |
DB::table('name')->having('count', '>', 100)->get(); |
| 64 |
$users = DB::table('users')->skip(10)->take(5)->get(); |
| 65 |
Joins |
| 66 |
DB::table('users') |
| 67 |
->join('contacts', 'users.id', '=', 'contacts.user_id') |
| 68 |
->join('orders', 'users.id', '=', 'orders.user_id') |
| 69 |
->select('users.id', 'contacts.phone', 'orders.price') |
| 70 |
->get(); |
| 71 |
DB::table('users') |
| 72 |
->leftJoin('posts', 'users.id', '=', 'posts.user_id') |
| 73 |
->get(); |
| 74 |
DB::table('users') |
| 75 |
->where('name', '=', 'John') |
| 76 |
->orWhere(function($query) |
| 77 |
{ |
| 78 |
$query->where('votes', '>', 100) |
| 79 |
->where('title', '<>', 'Admin'); |
| 80 |
}) |
| 81 |
->get(); |
| 82 |
Aggregates |
| 83 |
$users = DB::table('users')->count(); |
| 84 |
$price = DB::table('orders')->max('price'); |
| 85 |
$price = DB::table('orders')->min('price'); |
| 86 |
$price = DB::table('orders')->avg('price'); |
| 87 |
$total = DB::table('users')->sum('votes'); |
| 88 |
DB::table('name')->remember(5)->get(); |
| 89 |
DB::table('name')->remember(5, 'cache-key-name')->get(); |
| 90 |
DB::table('name')->cacheTags('my-key')->remember(5)->get(); |
| 91 |
DB::table('name')->cacheTags(array('my-first-key','my-second-key'))->remember(5)->get(); |
| 92 |
Raw Expressions |
| 93 |
$users = DB::table('users') |
| 94 |
->select(DB::raw('count(*) as user_count, status')) |
| 95 |
->where('status', '<>', 1) |
| 96 |
->groupBy('status') |
| 97 |
->get(); |
| 98 |
DB::select('select * from users where id = ?', array('value')); |
| 99 |
DB::insert('insert into foo set bar=2'); |
| 100 |
DB::update('update foo set bar=2'); |
| 101 |
DB::delete('delete from bar'); |
| 102 |
DB::statement('update foo set bar=2'); |
| 103 |
DB::table('name')->select(DB::raw('count(*) as count, column2'))->get(); |
| 104 |
Inserts / Updates / Deletes / Unions / Pessimistic Locking |
| 105 |
DB::table('users')->insert( |
| 106 |
['email' => 'john@example.com', 'votes' => 0] |
| 107 |
); |
| 108 |
$id = DB::table('users')->insertGetId( |
| 109 |
['email' => 'john@example.com', 'votes' => 0] |
| 110 |
); |
| 111 |
DB::table('users')->insert([ |
| 112 |
['email' => 'taylor@example.com', 'votes' => 0], |
| 113 |
['email' => 'dayle@example.com', 'votes' => 0] |
| 114 |
]); |
| 115 |
DB::table('users') |
| 116 |
->where('id', 1) |
| 117 |
->update(['votes' => 1]); |
| 118 |
DB::table('users')->increment('votes'); |
| 119 |
DB::table('users')->increment('votes', 5); |
| 120 |
DB::table('users')->decrement('votes'); |
| 121 |
DB::table('users')->decrement('votes', 5); |
| 122 |
DB::table('users')->increment('votes', 1, ['name' => 'John']); |
| 123 |
DB::table('users')->where('votes', '<', 100)->delete(); |
| 124 |
DB::table('users')->delete(); |
| 125 |
DB::table('users')->truncate(); |
| 126 |
$first = DB::table('users')->whereNull('first_name'); |
| 127 |
$users = DB::table('users')->whereNull('last_name')->union($first)->get(); |
| 128 |
DB::table('users')->where('votes', '>', 100)->sharedLock()->get(); |
| 129 |
DB::table('users')->where('votes', '>', 100)->lockForUpdate()->get(); |
Комментарии