Laravel: Using try…catch with DB::transaction()

by

In the case you need to manually ‘exit’ a transaction through code (be it through an exception or simply checking an error state) you shouldn’t use DB::transaction() but instead wrap your code in DB::beginTransaction and DB::commit/DB::rollback():

DB::beginTransaction();

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

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

See the transaction docs.

More Related Contents:

  1. How to store laravel log file data into database(5.5) [closed]
  2. How to hide config files from direct access?
  3. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  4. MVC (Laravel) where to add logic
  5. Laravel 4 – logging SQL queries
  6. Laravel catch TokenMismatchException
  7. How Follow the Don’t Repeat Yourself Principle When Consuming My Own Laravel API?
  8. Laravel 5.4 field doesn’t have a default value
  9. How to select all column name from a table in laravel?
  10. Laravel – Model Class not found
  11. Call to undefined method Maatwebsite\Excel\Excel::load()
  12. Laravel Livewire component not refreshing/reloading automatically after refreshing it
  13. Installing specific laravel version with composer create-project
  14. Laravel nested relationships
  15. ErrorBag is always empty in Laravel 5.2
  16. Laravel error: Missing required parameters for route
  17. Laravel 5.2 not reading env file
  18. getting the value of an extra pivot table column laravel
  19. Laravel pluck fields from relations
  20. Laravel 3 : Looking for explanation how to use the model
  21. How to login using Github, Facebook, Gmail and Twitter in Laravel 5.1?
  22. Composer: file_put_contents(./composer.json): failed to open stream: Permission denied
  23. Laravel Eloquent: How to get only certain columns from joined tables
  24. Mysql InnoDB engine in Laravel
  25. How do I make a Catch-All Route in Laravel
  26. How should I serve an image with Laravel?
  27. Expected response code 250 but got code “”, with message “”
  28. How to use Laravel Passport with Password Grant Tokens?
  29. How to remove /public/ from a Laravel URL
  30. How Can I Remove “public/index.php” in the Laravel Url generated? [duplicate]

Leave a Comment