在laravel中进行多个数据库连接
Laravel支持多个数据库系统,您需要在config/database.php文件中提供连接详细信息。
return [ 'default' => env('DB_CONNECTION', 'mysql'), 'connections' => [ 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, ], 'mysqlOne' => [ 'driver' => 'mysql', 'host' => env('DB_HOST_ONE', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE_ONE', 'forge'), 'username' => env('DB_USERNAME_ONE', 'forge'), 'password' => env('DB_PASSWORD_ONE', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, ], ], ];
有了这些,您可以为每个连接创建两个基本模型类,并在这些模型中定义连接名称。
//BaseModel.php protected $connection = 'mysql'; //BaseModelOne.php protected $connection = 'mysqlOne';
您可以扩展这些模型以创建更多用于每个数据库表的模型。