Dynamic Database change in Laravel

Question

I'm using DB::disconnect and DB::reconnection for connect database for multi tenant system in Laravel 5.2.

The code is as:

DB::disconnect();
Config::set('database.connections.mysql', $config);
DB::reconnect();

Where $config is an array of configurations to be set, this is working fine when I have to change the only database name, but when I want to change the prefix for the database it is not working, every time it takes old database.

I have tried to config:cache from the Middleware where I change the connection but it removes all input variables.

So, What Can I do to change prefix of DB connection? Any help?

user8555937 · Accepted Answer · 2020-03-04 13:13:00Z

3

You'll need to purge the cache of the database object:

// Will disconnect automatically
DB::purge('mysql');

// Register new config
Config::set('database.connections.mysql', $config);

// Will reconnect automatically
DB::table('table')->get();

answered Mar 4, 2020 at 13:13

user8555937

2,4252 gold badges22 silver badges52 bronze badges

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

2 Comments

Arjun Over a year ago

Thanks a lot, is anything in laravel that prevent cache for database?

user8555937 Over a year ago

I don't think there is. "Databse cache" means "sql connection" — that means if you have no DB cache, laravel will connect and disconnect everytime a query is made (which is low performance and stressing proof)

Collectives™ on Stack Overflow

Dynamic Database change in Laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related