lavarel5.5 配置多数据库连接多数据库问题

首先在.evn文件中的配置：

//默认数据库配置
DB_CONNECTION=mysql
DB_HOST='local.com'
DB_PORT=3306
DB_DATABASE=mysql
DB_USERNAME=forget
DB_PASSWORD=forget


//其他的数据库配置
DB_HOST_CENTER='localhost.com'
DB_PORT_CENTER=3306
DB_DATABASE_CENTER=mysql1
DB_USERNAME_CENTER=forget
DB_PASSWORD_CENTER=forget

在config文件夹下datebase中的配置：

//默认数据库的配置
'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),//要与MySQL中的相同  即默认的
            '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,
        ],



//其他数据库的配置
'mysql_center' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST_CENTER', '127.0.0.1'),//一定要与配置的相同
            'port' => env('DB_PORT_CENTER', '3306'),
            'database' => env('DB_DATABASE_CENTER', 'forge'),
            'username' => env('DB_USERNAME_CENTER', 'forge'),
            'password' => env('DB_PASSWORD_CENTER', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

在文件中的调用：

 $res = DB::connection('mysql');//默认数据库
       
$key = $res->table('key')->select('key')->get()->toArray();//查询所有的字
//默认数据库的操作方式
$key = DB::table('key')->select('key')->get()->toArray();//查询所有的字
$user_num = $res->table('users')->select('num','chou_time')->where('id','=',$yid)->get();




$db = DB::connection("mysql_center");
$res = $db->table("yz_wechat")->where("type_id",3)->first();

除了连接数据库时有所不同，其他均与laravel操作数据库方式相同