记录下常用的laravel数据库操作
多个数据库连接
DB::connection('foo')->select(...);
底层PDO 实例
$pdo = DB::connection()->getPdo();
执行原生SQL
$users = DB::select('select * from users where active = ?', [1]); $users = DB::select('select * from users where id = :id', ['id' => 1]); DB::insert('insert into users (id, name) values (?, ?)', [1, 'Dayle']); DB::update('update users set votes = 100 where name = ?', ['John']); DB::delete('delete from users'); DB::statement('drop table users');
事务
DB::transaction(function () { DB::table('users')->update(['votes' => 1]); DB::table('posts')->delete(); }); //手动使用事务 DB::beginTransaction(); DB::rollBack(); DB::commit();