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
- Method Illuminate\Events\Dispatcher::fire does not exist
- How to get user information using hootlex/laravel-friendships package in laravel
- Get last week data in Laravel
- How to disable timestamps in laravel
- Credit card validation in laravel
- How to create event and listener in laravel ?
- How to remove package from laravel
- Get 30 days older records from table in laravel
- How to add script on specific view file in laravel while extending layout
- Page loader in laravel
- Comment .env file in laravel
- How to fetch single row data from database in laravel
- How to create belongstomany relation using custom name on custom pivot table
- How to return a column with different name in Laravel
- Get last year created records in Laravel
- Create project table with model and migration
- How to insert value to additional columns in pivot table in laravel
- How to change default timestamp fields name in Laravel
- How to restore multiple records after soft-deletes in Laravel
- How to create and run user seeder in laravel
- Get previous date data in laravel
- Where to use whereNotNull eloquent in laravel
- Laravel csrf token mismatch for ajax POST Request
- How to get last record from object collection in laravel
- Redirect to another view from controller in laravel