Laravel登录后动态多数据库连接

'db_connections' => [
    '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', ''),
        // 其他配置...
    ],
    'mysql2' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST2', '127.0.0.1'),
        'port' => env('DB_PORT2', '3306'),
        'database' => env('DB_DATABASE2', 'forge2'),
        'username' => env('DB_USERNAME2', 'forge2'),
        'password' => env('DB_PASSWORD2', ''),
        // 其他配置...
    ],
],

use Illuminate\Support\Facades\DB;

// 根据用户角色切换数据库连接
$userRole = auth()->user()->role;

if ($userRole === 'admin') {
    DB::setDefaultConnection('mysql');
} else {
    DB::setDefaultConnection('mysql2');
}

// 执行数据库操作
$users = DB::table('users')->get();

DB::setDefaultConnection('mysql'); // 确保这里的连接名称与配置文件中的一致