php larval数据库配置规则,php-如何在Laravel中划分读写数据库设置？

您可以创建两个连接,然后使用on方法使用Eloquent指定连接：

'mysql' => [

'driver' => 'mysql',

'host' => env('DB_HOST', '127.0.0.1'),

'port' => env('DB_PORT', '3306'),

'database' => env('DB_DATABASE', 'forge'),

'username' => env('DB_USERNAME', 'forge'),

'password' => env('DB_PASSWORD', ''),

'unix_socket' => env('DB_SOCKET', ''),

'charset' => 'utf8mb4',

'collation' => 'utf8mb4_unicode_ci',

'prefix' => '',

'strict' => true,

'engine' => null,

],

'mysql2' => [

'driver' => 'mysql',

'host' => env('DB_HOST2', '127.0.0.1'),

'port' => env('DB_PORT2', '3306'),

'database' => env('DB_DATABASE2', 'forge'),

'username' => env('DB_USERNAME2', 'forge'),

'password' => env('DB_PASSWORD2', ''),

'unix_socket' => env('DB_SOCKET2', ''),

'charset' => 'utf8mb4',

'collation' => 'utf8mb4_unicode_ci',

'prefix' => '',

'strict' => true,

'engine' => null,

],

User::on('mysql2')->where('id', $id)->update($data);

或使用查询生成器：

DB::connection('mysql2')->table('users')->where('id', $id)->update($data);