这是一种方法.
在.env中创建新的数据库配置
DB_CONNECTION_PRODUCERS=mysql
DB_HOST_PRODUCERS=127.0.0.1
DB_PORT_PRODUCERS=3306
DB_DATABASE_PRODUCERS=producers
DB_USERNAME_PRODUCERS=root
DB_PASSWORD_PRODUCERS=****
在配置/数据库.php中创建一个新的数据库连接:
'producers' => [
'driver' => 'mysql',
'host' => env('DB_HOST_PRODUCERS', '127.0.0.1'),
'port' => env('DB_PORT_PRODUCERS', '3306'),
'database' => env('DB_DATABASE_PRODUCERS', 'producers'),
'username' => env('DB_USERNAME_PRODUCERS', 'root'),
'password' => env('DB_PASSWORD_PRODUCERS', ''),
],
在代码中连接到它,如下所示:
$producers = DB::connection('producers')->table('table_name')->get();