Connect multiple databases with laravel

Question

I need my system to connect to different databases simultaneously.

I have a general database that stores the user's connection data (db_user, db_name, db_password), these parameters are what I would send to my system so that it connects with its respective database and displays its information. The detail is when several users log in, my configuration information would be changing and I need to keep it in all possible connections. I have not yet implemented any solution so I receive your recommendations. I hope it has been explained in the best way, thank you very much.

Try reading the [documentation](https://laravel.com/docs/5.8/database#configuration) or at least [Google](https://fideloper.com/laravel-multiple-database-connections) it your question before posting it on Stackoverflow. — Thomas Van der Veen, Jun 04 '19 at 17:32

score 0 · Answer 1 · edited Jun 04 '19 at 17:42

0

You can use the following:

DB::connection('database_name')->query

edited Jun 04 '19 at 17:42

Cody Gray - on strike

239,200
50
490
574

answered Jun 04 '19 at 17:35

msbomrel

521
6
19

Ok, I'll try and tell you my results. Thank you – maria cisneros Jun 04 '19 at 17:43

score 0 · Accepted Answer · answered Jun 04 '19 at 17:46

add new database connection to config/database.php

'mysql' => [
    'driver'    => env('DB_CONNECTION'),
    'host'      => env('DB_HOST'),
    'port'      => env('DB_PORT'),
    'database'  => env('DB_DATABASE'),
    'username'  => env('DB_USERNAME'),
    'password'  => env('DB_PASSWORD'),
],

'mysql2' => [
    'driver'    => env('DB_CONNECTION_SECOND'),
    'host'      => env('DB_HOST_SECOND'),
    'port'      => env('DB_PORT_SECOND'),
    'database'  => env('DB_DATABASE_SECOND'),
    'username'  => env('DB_USERNAME_SECOND'),
    'password'  => env('DB_PASSWORD_SECOND'),
],

and you can use the following:

DB::connection('mysql2')->select(...);

Connect multiple databases with laravel

2 Answers2