Connection to a third-party database not filled in the standard Laravel config

1. Create a descendant class from \Illuminate\Database\DatabaseManager and override its configuration() method in it. For example, I created this class in \App\Database\DatabaseManager . The result should be something like this:

    <?php namespace App\Database; use \Illuminate\Database\DatabaseManager as BaseDatabaseManager; class DatabaseManager extends BaseDatabaseManager { protected function configuration($name) { // аргумент $name содержит название подключения // по названию подключения находим и возвращаем соответствующий конфиг $servers = conf()->get('servers'); if (!empty($servers[$name])) { $server = $servers[$name]; return [ 'driver' => 'mysql', 'host' => $server['ip_database'] ?? '127.0.0.1', 'port' => $server['port_database'] ?? 3306, 'database' => $server['name_database'], 'username' => $server['user_database'], 'password' => $server['pass_database'], 'unix_socket' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, ]; } return parent::configuration($name); } } 

2. To replace the standard DatabaseManager with our modified class, create your DatabaseServiceProvider :

    php artisan make:provider DatabaseServiceProvider 

Laravel will create it along the path \App\Providers\DatabaseServiceProvider . Change its code as follows:

 <?php namespace App\Providers; use App\Database\DatabaseManager; use Illuminate\Database\Connectors\ConnectionFactory; use Illuminate\Database\DatabaseServiceProvider as BaseDatabaseServiceProvider; class DatabaseServiceProvider extends BaseDatabaseServiceProvider { protected function registerConnectionServices() { $this->app->singleton('db.factory', function ($app) { return new ConnectionFactory($app); }); $this->app->singleton('db', function ($app) { // здесь создается объект нашего кастомизированного менеджера вместо стандартного return new DatabaseManager($app, $app['db.factory']); }); $this->app->bind('db.connection', function ($app) { return $app['db']->connection(); }); } } 

3. In the config/app.php in the providers section, replace the standard DatabaseServiceProvider with a new one:

    //Illuminate\Database\DatabaseServiceProvider::class, \App\Providers\DatabaseServiceProvider::class, 

How it should work .

In DatabaseManager :: configuration () you can implement any logic for obtaining configuration for connecting to the database. This input method receives the name of the connection, which is written (or specified dynamically) in the $ connection property of the model or is explicitly specified via DB :: connection (), and returns the required array of parameters for the connection.

In relation to your situation. All settings for connections you get this way:

 $servers = conf()->get('servers'); 

Your $servers should have something like this:

  $servers = [ 'connection_1' => [ 'driver' => 'mysql', 'host' => 'host_1', ... // остальные параметры подключения к первой БД ], 'connection_2' => [ 'driver' => 'mysql', 'host' => 'host_2', ... // остальные параметры подключения ко второй БД ], ]; 

You can use one model on different databases like this:

 $punishment = new Punishment(); $punishment->setConnection('connection_1'); dump($advert->count()); // будет выведено количество моделей в первой БД $punishment->setConnection('connection_2'); dump($advert->count()); // будет выведено количество моделей во второй БД 

Or the same thing through direct access to the tables:

 // получение количества записей таблицы в первой БД dump(\DB::connection('connection_1')->table('punishments')->count()); // получение количества записей таблицы во второй БД dump(\DB::connection('connection_2')->table('punishments')->count());