How to use multiple databases in Laravel

Using multiple databases in Laravel is quite easy. First, you will need to configure your database connections in the config/database.php file. You can add as many connections as you like to this file.

Once you have configured your database connections, you can use the DB::connection() method to specify which connection you want to use. For example, if you have a connection named "mysql" and you want to run a query on that connection, you can use the following code:

$users = DB::connection('mysql')->select('select * from users');

Watch a course Learn object oriented PHP

You can alsoExample of setting the default connection that Laravel should usen the config/database.php file by setting the value of the default option.

'default' => 'mysql',

Once you have set the default connection, you can use the DB facade as usual to run queries without having to specify the connection each time.

$users = DB::select('select * from users');

I hope that helps! Let me know if you have any other questions.