Db begintransaction laravel

TRANSACTON LARAVEL QUERY BUILDER

DB::beginTransaction();

try {
    DB::insert(...);    
    DB::commit();
} catch (\Throwable $e) {
    DB::rollback();
    throw $e;
}

Source: stackoverflow.com

Db begintransaction laravel

DB::beginTransaction();

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

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

Source: stackoverflow.com

Transaction commit rollback in laravel

// try...catch
try {
    // Transaction
    $exception = DB::transaction(function() {

        // Do your SQL here

    });

    if(is_null($exception)) {
        return true;
    } else {
        throw new Exception;
    }

}
catch(Exception $e) {
    return false;
}

Source: stackoverflow.com

Similar codes

2 votes280 views2 answers
Sql percentage
SQL
0 vote282 views1 answer
To Create directory
SQL
0 vote292 views1 answer
Mysqli_connect using prepare statement
SQL
2 votes249 views1 answer
Convert series number to date in sql
SQL
0 vote294 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
2 votes279 views1 answer
How to get non distinct values in sql
SQL
2 votes281 views1 answer
Orcale index size
SQL
0 vote258 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote265 views1 answer
Mysql date only no time
SQL
0 vote274 views2 answers
Auto increment column in mysql query results
SQL