Changing MySQL database to connect to based on URL parameter in Laravel 8

Question

I have a series of databases named server_1 to server_100. Based on the URL parameter that the users select, I would like to connect to that database. Is there a way to accomplishing this without defining 100 separate connections in .env?

Exposing actual db name in frontend is a major security vulnerability. — ManojKiran
– ManojKiran, Commented Oct 26, 2021 at 5:34
Or you can define all the db connection into databases. And based on url changes. By using middleware you can set the connection dynamically — ManojKiran
– ManojKiran, Commented Oct 26, 2021 at 5:36

Romik Makavana · Accepted Answer · 2021-10-26 06:11:55Z

1

You have to change database connection on fly and also dont forget to purge connection.

Config::set("database.connections.mysql.host", "127.0.0.1");
Config::set("database.connections.mysql.database", "database_name");
Config::set("database.connections.mysql.username", "username");
Config::set("database.connections.mysql.password", "password");
DB::purge('mysql');

answered Oct 26, 2021 at 6:11

Romik Makavana

831 silver badge8 bronze badges

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

2 Comments

timyc Over a year ago

Are the configurations saved until script execution is complete, or is it saved until the DB is purged again?

Romik Makavana Over a year ago

It must require to purge connection, when ever you change.

Collectives™ on Stack Overflow

Changing MySQL database to connect to based on URL parameter in Laravel 8

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related