Laravel transaction

Laravel transactions

DB::beginTransaction();

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

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

Source: stackoverflow.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

Laravel transaction

// Start transaction
beginTransaction();

// Run Queries
$acct = createAccount();
$user = createUser();

// If there's an error
//    or queries don't do their job,
//    rollback!
if( !$acct || !$user )
{
    rollbackTransaction();
} else {
    // Else commit the queries
    commitTransaction();
}

Source: fideloper.com

Laravel transaction

// Start transaction!
DB::beginTransaction();

try {
    // Validate, then create if valid
    $newAcct = Account::create( ['accountname' => Input::get('accountname')] );
} catch(ValidationException $e)
{
    // Rollback and then redirect
    // back to form with errors
    DB::rollback();
    return Redirect::to('/form')
        ->withErrors( $e->getErrors() )
        ->withInput();
} catch(\Exception $e)
{
    DB::rollback();
    throw $e;
}

try {
    // Validate, then create if valid
    $newUser = User::create([
        'username' => Input::get('username'),
        'account_id' => $newAcct->id
    ]);
} catch(ValidationException $e)
{
    // Rollback and then redirect
    // back to form with errors
    DB::rollback();
    return Redirect::to('/form')
        ->withErrors( $e->getErrors() )
        ->withInput();
} catch(\Exception $e)
{
    DB::rollback();
    throw $e;
}

// If we reach here, then
// data is valid and working.
// Commit the queries!
DB::commit();

Source: fideloper.com

Laravel transaction

DB::transaction(function()
{
    $newAcct = Account::create([
        'accountname' => Input::get('accountname')
    ]);

    $newUser = User::create([
        'username' => Input::get('username'),
        'account_id' => $newAcct->id,
    ]);
});

Source: fideloper.com

Laravel transaction

// Start transaction
beginTransaction();

// Run Queries
$acct = createAccount();
$user = createUser();

// If there's an error
//    or queries don't do their job,
//    rollback!
if( !$acct || !$user )
{
    rollbackTransaction();
} else {
    // Else commit the queries
    commitTransaction();
}

Source: fideloper.com

Similar codes

0 vote264 views1 answer
Get record of last 24 hours in laravel
PHP Laravel
44 votes285 views2 answers
Laravel version command
PHP Laravel
7 votes233 views4 answers
With message in laravel
PHP Laravel
0 vote275 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
0 vote267 views1 answer
Skip model accessor laravel8
PHP Laravel
0 vote223 views1 answer
How to login laravel passport with postman
PHP Laravel
0 vote245 views1 answer
Get All dates of a month with laravel carbon
PHP Laravel
1 vote244 views3 answers
Check table exists in db laravel
PHP Laravel
0 vote243 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
8 votes241 views5 answers
Wherebetween laravel
PHP Laravel