
Database transactions in laravel
Created at 19-Mar-2021 ,
By samar
Database transactions in laravel
Through the use of the programming language, we will work together to solve the "Database transactions in laravel" puzzle in this lesson.
-
--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(); });
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(); });
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; }
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.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- Class App\Http\Controllers\Admin\UserController Does Not Exist
- Validation errors for multiple forms on same page Laravel
- Delete records with relationship in laravel
- Laravel specific table Migration
- How to insert multiple rows in mysql using loop in laravel?
- How to generate .env file for laravel?
- How to add foreign key in laravel using migration
- Symlink(): No such file or directory
- Link storage folder in laravel 8
- How to get IP address in laravel
- Redirect from www to non www in laravel using htaccess
- How to return a column with different name in Laravel
- Where to use whereNotNull eloquent in laravel
- Update email with unique validation in laravel
- Delete file from amazon s3 bucket using Laravel
- How to display a specific word from a string in laravel
- How to pass two variables in HREF in laravel
- How to get all posts which contains comments in laravel
- How to get random string in Laravel
- Array to string conversion laravel blade
- Print query in laravel
- SQLSTATE[42000]: Syntax error or access violation: 1055
- Call to a member function pluck() on null
- How to get column names from table in Laravel
- Composer create project laravel/laravel example app