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

9 votes180 views3 answers
Postgres make sql dump
SQL
11 votes134 views4 answers
MYSQL LOGIN
SQL
1 vote128 views1 answer
Rows to comma separated values in mssql
SQL
0 vote139 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
3 votes172 views3 answers
Create table in SQL Server
SQL
0 vote148 views1 answer
Create a sql server database programmatically
SQL
0 vote161 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote142 views1 answer
Postgresql using reserved word as column name
SQL
0 vote136 views2 answers
Temp tables in sql server
SQL
1 vote149 views3 answers
Rows, INSERT INTO
SQL