How to update database name and set persistent connect for entire session laravel 5.5?

Question

I have secondary connection that comes dynamically and here is it's code

 'userdb' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => DYNAMIC_DATABASE_NAME,
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => false,
        ],

So, once use logged in I want to update update this database dynamically and reconnect to this userdb.

I have used following code but this is not giving persistent DB connection I have to this this everytime manually. Any suggestions ?

DB::purge('userdb');
config(['database.connections.userdb.database' => 'test']);
DB::reconnect('userdb');
DB::connection('userdb');

Possible duplicate of Laravel: connect to databases dynamically — nakov
– nakov, Commented May 13, 2019 at 10:03
Possible duplicate of Laravel - change the default database connection globally — Kyle Wardle
– Kyle Wardle, Commented May 13, 2019 at 10:05
But the issue is every time I have to write code for reconnect database 'userdb' — Ronak Chauhan
– Ronak Chauhan, Commented May 13, 2019 at 10:09

Jignesh Joisar · Accepted Answer · 2019-05-13 10:24:56Z

0

1.first set database name

\Config::set('database.connections.userdb.database','test');

2.after set database name you need to purge the DB cache

\DB::purge('userdb');

3.set default connection after u purge db cache

\DB::setDefaultConnection('userdb');

edited May 13, 2019 at 10:24

answered May 13, 2019 at 10:17

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

3 Comments

Ronak Chauhan Over a year ago

I am getting this error "Class 'App\Http\Controllers\Auth\Config' not found"

Ronak Chauhan Over a year ago

I already know this solution and I also written in my question Please check my question. The issue is when I change my page connection got reverted to old one.

Jignesh Joisar Over a year ago

@RonakChauhan pl join this group chat.stackoverflow.com/rooms/193251/dynamic-connection

Collectives™ on Stack Overflow

How to update database name and set persistent connect for entire session laravel 5.5?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related