Setting dynamic database in config during Login - Laravel

All requests are stateless so current request doesn't know that you set new config value in previous request.

You should call Config::set(...) every time when you want to use dynamic database and set database name getting this value from User instance.

Setting above should be done using middleware and service provider.

Create new middleware and register it for web middleware group (You may do this using the $middlewareGroups property of your HTTP kernel):

protected $middlewareGroups = [    'web' => [        //...        \App\Http\Middleware\YourMiddleware::class,    ],    //...];

Then:

<?php namespace App\Http\Middleware;class YourMiddleware{    public function handle($request, Closure $next)    {        if (Auth::check()) {            $database_name = Auth::user()->company;            // Set your config here using $user->company            // ...        }        return $next($request);    }}

If you must to set this value once (during authentication), you should combine above code and sessions to store this information between requests:

session(['db_name' => $dbname]); // Set db_name and store it$db_name = session('db_name'); // Get db_name from session

Read more about HTTP Sessions: https://laravel.com/docs/5.7/session#retrieving-data

First you need create new default db for connection and add to database.php like normal connection

    'dynamicdb' => [        'driver'      => 'mysql',        'host'        => env('DB_HOST', '127.0.0.1'),        'port'        => env('DB_PORT', '3306'),        'database'    => 'default',        //others    ],

next overriding model methods in Stock

   protected $table = 'stocks';     protected $connection = 'dynamicdb'; /** * @return string */public function getTable(){    $table = parent::getTable();    $database = config('database.connections.dynamicdb.database');    return starts_with($table, $database)        ? $table        : $database . '.' . parent::getTable();}/** * Set the table associated with the model. * * @param  string $table * @return $this */public function setTable($table){    $database = config('database.connections.dynamicdb.database');    $this->table = starts_with($table, $database)        ? $table        : $database . '.' . $table;    return $this;}

Usage : \Config::set('database.connections.dynamicdb.database',$user->company); or you can create helper for it Don't forget this method work only one connection and connected user have access all databases

Add Multiple DB in .env

DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=database1DB_USERNAME=rootDB_PASSWORD=ALT_DB_HOST=127.0.0.1ALT_DB_PORT=3306ALT_DB_DATABASE=database2ALT_DB_USERNAME=rootALT_DB_PASSWORD=

Edit config/database.php

'connections' => [    'mysql' => [        ......    ],    'alt_mysql' => [        'driver' => 'mysql',        'host' => env('ALT_DB_HOST', '127.0.0.1'),        'port' => env('ALT_DB_PORT', '3306'),        'database' => env('ALT_DB_DATABASE', 'vibecloud'),        ...    ],

If Whole model used for ALT_MYSQL then

protected $connection = 'alt_mysql';

ELSE

protected function stock_info() {  return \DB::connection('alt_mysql')->select('*')->from('stocks')->get();}