Change Database of existing Database Connection - Laravel

Question

I recently got to know about the Laravel Framework which is awesome but just want to know one query which is still a mystery for me.

I know we can easily change the "Database Connection" using

      $users = DB::connection('mysql2')->select(...);

but I'm working on such a project where Multiple Databases are created as per user request and need to access these databases dynamically as per user request.

Its nearly impossible to enter every database entry as new database connection entry in Database config file.

Hence I need a way to change the Database dynamically in the same connection we are using.

eg.

If we are using "DB1" connection with Database "test1" as defined in config file,

I need a way to change the "test1" database to "test2" DYNAMICALLY

I'm working over single framework for multiple organizations, hence the data for each organization needs to be stored in distinct database. — Vaishnav Mhetre
– Vaishnav Mhetre, Commented Mar 2, 2017 at 9:13

Moppo · Accepted Answer · 2016-07-08 12:36:28Z

3

Probably you can do that by simply changing the value of the database configuration at runtime:

Config::set('database.connections.DB1.test1', 'test2');

answered Jul 8, 2016 at 12:36

Moppo

19.4k5 gold badges68 silver badges66 bronze badges

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

1 Comment

Vaishnav Mhetre Over a year ago

Thanks. That may help though.

JasonK · Accepted Answer · 2016-07-08 12:40:54Z

1

You could save database connection(s) for each user in a "central" database. Query that database, find the matching connection parameters and use them to query the user's database.

Multi-tenant applications use a similar approach. I've created a package to craft multi-tenant applications with Laravel. This package requires 'tenants' to be defined in a config file... which you do not want. Take a look at the source code tho. It might help you bring up new ideas.

answered Jul 8, 2016 at 12:40

JasonK

5,2949 gold badges36 silver badges62 bronze badges

Collectives™ on Stack Overflow

Change Database of existing Database Connection - Laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related