Change the Database Connection Dynamically in Laravel

php mysql database laravel multi-tenant
tyro picture tyro · Oct 16, 2017 · Viewed 11.7k times · Source

I have the master database with login table and corresponding database settings for each user. On login I should dynamically change the db settings fetching from the table. I can change the db connection but this is not persisting.

Config::set("database.connections.mysql", [
'driver' => 'mysql',
"host" => $usr_host,
"database" => $usr_database,
"username" => $usr_username,
"password" => $usr_password,
...
]);

edit: New database is created for each user when he/she registers with the app and thus i dont have the database connection for each user defined in the config/database.php

Answer

Adam Kozlowski picture Adam Kozlowski · Sep 25, 2018

This way you can set new parameter when it comes to database: 

 \Config::set('database.connections.mysql.database', $schemaName);

Remember about PURGE to persist this settings

 DB::purge('mysql');

Cheers!

Related questions

How to use multiple databases in Laravel

I want to combine multiple databases in my system. Most of the time the database is MySQL; but it may differ in future i.e. Admin can generate such a reports which is use source of heterogeneous database system. So …

Read More
How can I rename column in laravel using migration?

I have columns as mentioned bellow: public function up() { Schema::create('stnk', function(Blueprint $table) { $table->increments('id'); $table->string('no_reg', 50)->unique(); $table->string('no_bpkb', 50)->unique(); $table->string('nama_pemilik', 100); $…

Read More
Laravel Query Builder - sum() method issue

Ehi there, I'm new in laravel and I have some issues with laravel query builder. The query I would like to build is this one: SELECT SUM(transactions.amount) FROM transactions JOIN categories ON transactions.category_id == categories.id WHERE …

Read More