laravel使用多个数据库连接

来源：互联网发布：excel怎么将数据分列编辑：程序博客网时间：2024/06/01 23:42

1、配置.env文件

DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=database_nameDB_USERNAME=rootDB_PASSWORD=DB_HOST_CENTER=127.0.0.1DB_PORT_CENTER=3306DB_DATABASE_CENTER=database_centerDB_USERNAME_CENTER=rootDB_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

// 1.这个model将采用默认的'mysql'连接class UserModel extends Model{    // 数据库'database'中的users表    protected $table = "users";}

// 2.这个model将使用mysql_center连接class UserModel extends Model{　　// 数据库'dadtabase_center'中的users表    protected $connection = 'mysql_center';    protected $table = "users";}

0 0