DB::transaction

use Illuminate\Support\Facades\DB;

DB::transaction(function () {
    DB::update('update users set votes = 1');

    DB::delete('delete from posts');
});

Source: laravel.com

DB::transaction

DB::beginTransaction();

try {
    DB::insert(...);
    DB::insert(...);
    DB::insert(...);

    DB::commit();
    // all good
} catch (\Exception $e) {
    DB::rollback();
    // something went wrong
}

Source: stackoverflow.com

Similar codes

2 votes143 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote190 views1 answer
Postgresql find biggest table
SQL
0 vote186 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote168 views1 answer
Replace sqlalchemy
SQL
0 vote147 views2 answers
Mysql multiply
SQL
0 vote217 views1 answer
Sql if clause within where clause
SQL
21 votes139 views3 answers
Sql average
SQL
0 vote152 views2 answers
Postgresql variable in query
SQL
0 vote144 views1 answer
Mysql get longest string in column
SQL
1 vote159 views1 answer
Oracle insert multiple rows into same table
SQL