CODE EXAMPLE FOR PHP

avoid data insertion if an error occurs in laravel

try {
        //start the transaction
        DB::beginTransaction();

        DB::table('XYZ')->update(['abc'=>'ABC']);
        DB::table('EG')->delete();

        //commit the transaction
        DB::commit();
} catch (Exception $e) {
        DB::rollBack();
        return response;
}