Laravel

Easy way to use transaction in laravel

Easy way to use transaction in laravel

Laravel
151Views

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 full stack developer. I love coding. I know Wordpress, Core php, Angularjs, Angular 2, Angular 6, laravel, Codeigniter, Shopify, Squarespace, Jquery, Google Map Api, Vuejs, Reactjs, Bigcommerce etc.

Leave a Reply