laravel / lumen 使用多个数据库连接

1、配置.env文件

DB_CONNECTION=db_a
DB_TIMEZONE=+08:00
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_general_ci

DB_A_HOST=dev
DB_A_PORT=3306
DB_A_DATABASE=db_a_name
DB_A_USERNAME=root
DB_A_PASSWORD=root
DB_A_PREFIX=h_

DB_B_HOST=dev
DB_B_PORT=3306
DB_B_DATABASE=db_b_name
DB_B_USERNAME=root
DB_B_PASSWORD=root

DB_C_HOST=dev
DB_C_PORT=3306
DB_C_DATABASE=db_c_name
DB_C_USERNAME=root
DB_C_PASSWORD=root
DB_C_PREFIX=h_

2、配置config/database.php

        'db_a' => [
            'driver'    => 'mysql',
            'host'      => env('DB_A_HOST', 'localhost'),
            'port'      => env('DB_A_PORT', 3306),
            'database'  => env('DB_A_DATABASE', 'forge'),
            'username'  => env('DB_A_USERNAME', 'forge'),
            'password'  => env('DB_A_PASSWORD', ''),
            'prefix'    => env('DB_A_PREFIX', ''),
            'charset'   => env('DB_CHARSET', 'utf8mb4'),
            'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
            'timezone'  => env('DB_TIMEZONE', '+00:00'),
            'strict'    => env('DB_STRICT_MODE', false),
        ],

        'db_b' => [
            'driver'    => 'mysql',
            'host'      => env('DB_B_HOST', 'localhost'),
            'port'      => env('DB_B_PORT', 3306),
            'database'  => env('DB_B_DATABASE', 'forge'),
            'username'  => env('DB_B_USERNAME', 'forge'),
            'password'  => env('DB_B_PASSWORD', ''),
            'prefix'    => env('DB_B_PREFIX', ''),
            'charset'   => env('DB_CHARSET', 'utf8mb4'),
            'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
            'timezone'  => env('DB_TIMEZONE', '+00:00'),
            'strict'    => env('DB_STRICT_MODE', false),
        ],

        'db_c' => [
            'driver'    => 'mysql',
            'host'      => env('DB_C_HOST', 'localhost'),
            'port'      => env('DB_C_PORT', 3306),
            'database'  => env('DB_C_DATABASE', 'forge'),
            'username'  => env('DB_C_USERNAME', 'forge'),
            'password'  => env('DB_C_PASSWORD', ''),
            'prefix'    => env('DB_C_PREFIX', ''),
            'charset'   => env('DB_CHARSET', 'utf8mb4'),
            'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
            'timezone'  => env('DB_TIMEZONE', '+00:00'),
            'strict'    => env('DB_STRICT_MODE', false),
        ],

 

3、创建model

class TestModel extends Model
{
    /**
     * 定义链接数据库
     * @var string
     */
    protected $connection = 'db_a';