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

30 篇文章 1 订阅

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';

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值