1 多数据库配置
config/database.php 中 新增
'zsql' => [
'driver' => 'mysql',
'host' => env('DB_HOST_CENTER', 'localhost'),
'port' => env('DB_PORT_CENTER', '3306'),
'database' => env('DB_DATABASE_CENTER', 'yy'),
'username' => env('DB_USERNAME_CENTER', 'yyadmin'),
'password' => env('DB_PASSWORD_CENTER', 'yyadmin'),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
'engine' => null,
],
.env 中新增
DB_HOST_CENTER=localhost
DB_PORT_CENTER=3306
DB_DATABASE_CENTER=yy
DB_USERNAME_CENTER=yyadmin
DB_PASSWORD_CENTER=yyadmin
控制器中
$sqlQuery = " TRUNCATE sign_up_config"; // 清空数据表
$result = DB :: select(DB :: raw($sqlQuery));
$dd = DB::connection('zsql')->table('sign_up_config')->get()->toArray(); // 链接其他数据库 查询数据
$new = [];
foreach ($dd as $k => $v) {
$n = (array)($v);
$new[] = $n;
}
// $sqlQuery = "INSERT $dd INTO `sign_up_config`";
$res = DB::table('sign_up_config')->insert($new); // 实现插入数据表