Sunday, July 12, 2020
therichposts@gmail.com
Laravel

Easy way to use transaction in laravel

Laravel 7.2 routing with route group auth guard check with prefix

Easy way to use transaction in laravel

Views

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.

 

 

Ajay Malhotra
the authorAjay Malhotra
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know Wordpress, Core php, Angularjs, Angular 2, Angular 6, Angular 7, Angular 8, Angular 9, Angular 10 Nodejs, laravel, Codeigniter, Shopify, Squarespace, Jquery, Google Map Api, Vuejs, Reactjs, Bigcommerce etc.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.