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

0 vote184 views1 answer
Show function mysql
SQL
0 vote178 views1 answer
Order by with where clause in mysql
SQL
0 vote174 views1 answer
How to to get current date and time in sql
SQL
0 vote212 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote199 views2 answers
Transaction php
SQL
5 votes196 views3 answers
Day of week postgresql
SQL
7 votes221 views1 answer
Sql pagination oracle
SQL
0 vote193 views2 answers
How to save result of sqlite query in a table
SQL
13 votes202 views3 answers
Insert mysql ifile nto database
SQL
0 vote191 views2 answers
How to find sql server agent jobs related to a database
SQL