How to Declare a Different Database Connection in laravel Controller

Question

I have a Controller and I need to set the Database for my Query Builder, all is working but when I create new function I need to redeclare a connection, What I need is to declare the connection so that the whole controller will be connecting with that database.

class CompanyInformationController extends Controller
{



    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function firstFunction()
    {

     $connection = DB::connection('fdis_1');

      return  $connection->getDatabaseName();

    }

    public function secondFunction()
    {
     // This is redundant
     $connection = DB::connection('fdis_1');

      return  $connection->getDatabaseName();

    }
}

Declare connection in constructure and use into whole controller — Ravindra Bhanderi
– Ravindra Bhanderi, Commented Apr 3, 2018 at 8:42

Ravindra Bhanderi · Accepted Answer · 2018-04-03 08:46:17Z

4

in a class on controller

 private $connection;

 public function __construct()
    {
        $this->connection = DB::connection('fdis_1');

    }

now use into your method like

  $this->connection->getDatabaseName();

answered Apr 3, 2018 at 8:46

Ravindra Bhanderi

2,9765 gold badges20 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ravindra Bhanderi Over a year ago

@MartneyAcha Welcome

Collectives™ on Stack Overflow

How to Declare a Different Database Connection in laravel Controller

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related