
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
- Add class to body in laravel view
- How to display a specific word from a string in laravel
- How to get only time from created_at in laravel
- How to prevent host header attack in Laravel
- Array to string conversion laravel blade
- Link storage folder in laravel 8
- How to pass external link in laravel blade to anchor tag
- Create model with migration and seeder
- How to get route method name in Laravel
- How to create laravel project using composer
- Syntax error or access violation: 1072 Key column 'role_id' doesn't exist in table (SQL: alter table `users` add constraint `users_role_id_foreign` foreign key (`role_id`) references `roles` (`id`))
- How to insert value to additional columns in pivot table in laravel
- How to get database name in Laravel 9 ?
- How to pass data to route in laravel?
- Illuminate\Database\QueryException could not find driver
- Convert input array to comma-separated string in laravel controller
- Ignore Records where a field has NULL value in Laravel
- How to restore deleted records in laravel
- How to get path from current URL in Laravel
- Insert Comma Separated Values in laravel
- Pass value from controller to model in laravel
- Drop foreign key column in Laravel using migration
- How to get column names from table in Laravel
- Laravel create default admin user
- PhpMyAdmin - Error The mysqli extension is missing