Model.php
<?php
class Vaccine extends Model
{
protected $table = 'vaccine';
protected $connection = 'db2';
}看看 config/database.php
<?php
'connections' => [
'db1' => [
'driver' => 'mysql',
'host' => env('ANHAO_FOUR_DB_HOST', '127.0.0.1'),
'port' => env('ANHAO_FOUR_DB_PORT', '3306'),
'database' => env('ANHAO_FOUR_DB_DATABASE', ''),
'username' => env('ANHAO_FOUR_DB_USERNAME', ''),
'password' => env('ANHAO_FOUR_DB_PASSWORD', ''),
'unix_socket' => env('ANHAO_FOUR_DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => false,
'engine' => null,
'options'=> [
PDO::ATTR_EMULATE_PREPARES => true
],
],
'db2' => [
'driver' => 'mysql',
'host' => env('BHC_USER_DB_HOST', '127.0.0.1'),
'port' => env('BHC_USER_DB_PORT', '3306'),
'database' => env('BHC_USER_DB_DATABASE', ''),
'username' => env('BHC_USER_DB_USERNAME', ''),
'password' => env('BHC_USER_DB_PASSWORD', ''),
'unix_socket' => env('BHC_USER_DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => false,
'engine' => null,
'options'=> [
PDO::ATTR_EMULATE_PREPARES => true
]
],
],