Categories

Saturday, July 13, 2024
#919814419350 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

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.

 

 

therichpost
the authortherichpost
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 14, Angular 15, Angular 16, Angular 17, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

Leave a Reply

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