首先,您必须在app / conifg / database.php中定义secoundary连接,然后在连接中定义例如:
'second_db_conn' => [
'driver' => 'mysql',
'host' => $_SERVER['MYSQL_HOST'],
'database' => $_SERVER['MYSQL_DATABASE'],
'username' => $_SERVER['MYSQL_USERNAME'],
'password' => $_SERVER['MYSQL_PASSWORD'],
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
],
然后在你的模型上设置这个连接 – 保存它 – 并切换回默认值(在我的例子中是一个mysql):
$model->setConnection('second_db_conn')->save();
$model->setConnection('mysql');