Can laravel connect two databases?

Laravel is a popular PHP framework that provides many powerful features and tools to make developing web applications more efficient and simpler. In actual application scenarios, we often need to connect to multiple databases and interact and transfer data between these databases. Therefore, this article will discuss how to access multiple databases in Laravel.

Generally speaking, Laravel only connects to one database by default. This is set in the 'database' field in config/database.php. In addition, we can also set other configuration items for each database, such as the database connection name, host name, database name, user name, password, etc. But what do we do if we need to connect to multiple databases?

In Laravel, we can use Laravel's Eloquent ORM and the Database Query Builder provided by Laravel to connect to multiple databases. Both tools provide many efficient and flexible methods, making connecting to multiple databases simple and convenient.

1. Configuration file settings

Normally, we can connect to multiple databases by modifying the database connection in the configuration file. Just add a new database connection in config/database.php. For example, we can add a database connection named "mysql2":

'default' => env('DB_CONNECTION', 'mysql'),

'connections' => [

// Main database

'mysql' => [

'driver' => 'mysql',

'host' = > env('DB_HOST', '127.0.0.1'),

// ...

],

// The second database

'mysql2' => [

'driver' => 'mysql',

'host' => env('DB_HOST2', '127.0.0.1'),

// ...

],

],

2. Model Settings

In Laravel , each database connection requires at least one database model to access it. We need to create an Eloquent model for each database connection. For example, we can create a new model to access the "mysql2" connection we just added:

class Mysql2Model extends Model

{

protected $connection = 'mysql2' ;

protected $table = 'users';

// ...

}

This model specifies to use "mysql2" to connect and access A table named "users".

3. Using multiple database connections in a controller

In Laravel controllers, we can connect multiple databases using different models for each database connection. For example, the following code will select user records from two different databases and merge them into the same array:

use AppUser;

use AppMysql2Model;

public function index()

{

// Get user data from the default database

$users1 = User::all()->toArray();

// Get user data from the second database

$users2 = Mysql2Model::all()->toArray();

// Merge the two Result array

$users = array_merge($users1, $users2);

// ...

}

We can use Eloquent to access User model in the first database and then use Mysql2Model to access the related model in the second database. We can then combine the two resulting arrays and perform subsequent data processing.

4. Using multiple connections in the query builder

In Laravel's query builder, we can use the "connection" method to specify which database connection to use. For example, the following code uses a second database connection to select records for all fields from a table named "users":

use IlluminateSupportFacadesDB;

$users = DB::connection( 'mysql2')->table('users')->get();

In this example, we use the DB class to specify the connection using "mysql2", and then use the query builder "table ” method retrieves all records from the table named “users”.

Summary:

Laravel supports multiple database connections. We can use Laravel's Eloquent ORM and Database Query Builder to connect to multiple databases. We can use different database connections and interact with data through configuration files, models, controllers, and query builders. This makes Laravel more powerful and flexible when it comes to data management, which is one of the reasons why this framework is so popular.

The above is the detailed content of Can laravel connect two databases?. For more information, please follow other related articles on the PHP Chinese website!