laravel数据库操作

记录下常用的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();