Database transactions in laravel

Answers 3
  • --PATH app\Http\Controllers\<YourController.php>
    use Illuminate\Support\Facades\DB;
    
    DB::transaction(function () {
        DB::table('employee')->where('id',  1)->delete();
        DB::table('employeedetails')->where('EmpID', 1)->delete();
    });
    
    0
    Database transactions method is useful in laravel when some queries executed successfully and anyone or someone of them fails for some reason or because of any error. If some action fails everything will be rolled back automatically. You don't need to worry about manually rolling back or committing while using the transaction method. Lets you have multiple queries to run which are related to each other like on deleting a record from employee table you have to delete a record from emoployeedetails table. If any error occurs in execution of the second statement, the first statement will be rolled back automatically. So that is the case how you use database transactions.
  • --PATH app\Http\Controllers\<YourController.php>
    $id = 2;
    DB::transaction(function () use ($id)  {
        DB::table('employee')->where('id',  $id)->delete();
        DB::table('employeedetails')->where('EmpID', $id)->delete();
    });
    
    0
    You can use the use() method to access variables which are outside of the DB::transaction() method. You have to pass every variables inside use() method which you want to use inside your queries. You can use multiple comma separated variable values in your use method.
  • --PATH app\Http\Controllers\<YourController.php>
    DB::beginTransaction();
    try {
        DB::table('employee')->where('id',  1)->delete();
        DB::table('employeedetails')->where('EmpID', 1)->delete();
        DB::commit();
    } catch (\Exception $e) {
        DB::rollback();
        //throw $e;
    }
    
    0
    You can use the transaction method manually and you have complete control over DB::commit() and DB::rollback() methods which are used to execute the queries and rollback the executed queries. A transaction gives you the ability to safely perform a set of data-modifying SQL queries. If any one of the queries is not executed successfully then you can rollback all executed queries using DB::rollback() method.
  • Back to code snippet queries related laravel