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.
Recent Comments