laravel使用多个数据库连接
1、配置.env文件
1 DB_CONNECTION=mysql 2 DB_HOST=127.0.0.1 3 DB_PORT=3306 4 DB_DATABASE=database_name 5 DB_USERNAME=root 6 DB_PASSWORD= 7 8 DB_HOST_CENTER=127.0.0.1 9 DB_PORT_CENTER=3306 10 DB_DATABASE_CENTER=database_center 11 DB_USERNAME_CENTER=root 12 DB_PASSWORD_CENTER=
2、配置config/database.php
'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', 'localhost'), '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, ], 'mysql_center' => [ 'driver' => 'mysql', 'host' => env('DB_HOST_CENTER', 'localhost'), 'port' => env('DB_PORT_CENTER', '3306'), 'database' => env('DB_DATABASE_CENTER', 'forge'), 'username' => env('DB_USERNAME_CENTER', 'forge'), 'password' => env('DB_PASSWORD_CENTER', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, ],
3、创建model
// 这个model将采用默认的'mysql'连接 class UserModel extends Model {
// 数据库'database'中的users表 protected $table = "users"; }
// 这个model将使用mysql_center连接 class UserModel extends Model {
// 数据库'dadtabase_center'中的users表 protected $connection = 'mysql_center'; protected $table = "users"; }
