How to change the default DB connection for a specific controller?

Hello,

Is it possible to set/change the default DB connection on a specific controller to avoid writing DB::connection every time? This controller needs only this connection

thanks

gych

2 years ago

Level 29

You could use middleware for this, group all routes for the default DB connection in a middleware 'defaultDBConnection' or 'DBConnection1' for example and create a separate middleware for the routes that use the specific controller.

Then in those middleware's set the desired DB connection.

Ligonsker

2 years ago

Level 8

Thank you, how can I set the specific connection in this middleware?

gych

2 years ago

Level 29

@Ligonsker

You can either change the database connection from the config

use Illuminate\Support\Facades\Config;

$connection= config('database.connections.yourconnection');
Config::set('database.connections.mysql', $connection);
DB::purge();

or use DB facade to set the connection

use Illuminate\Support\Facades\DB;
DB::setDefaultConnection('yourDBConnection');

1 like

gych

2 years ago

Level 29

I've updated/improved my example in my last reply

amitsolanki24_

2 years ago

Level 8

@ligonsker you can set from config/database.php file

Please or to participate in this conversation.