Hello to all, welcome to therichpost.com. In this post, I will tell you, Easy way to use transaction in laravel. Like I always say that laravel is the best Mvc php framework.
DB::transaction() is used for multiple insert queries. I am using it with try and catch and here is working and tested code:
DB::beginTransaction();
try {
DB::table('rv_sale_appointments')
->select('ids')
//->where()
->get();
// DB::insert(...);
// DB::insert(...);
DB::commit();
echo "all good";
} catch (\Exception $e) {
DB::rollback();
echo "something went wrong";
// something went wrong
}
//or
DB::transaction(function() {
try
{
DB::table('calls')->insert($calls);
}
catch (\Exception $e)
{
//send mail with subject "db import failed" and body of $e->getMessage()
}
});
if you have any query related this post then please do ask.
