Laravel动态更改数据库连接

一、修改Config目录中database.php

（1）在connections下模仿mysql新加一个，值自己根据自己的配置改

'mysql_test' => [
    'driver' => 'mysql',
    'host' => '127.0.0.1',
    'port' => '3306',
    'database' => 'db_database',
    'username' => 'db_username',
    'password' => 'db_password',
],

（2）也可以直接在接口了设置

DB::disconnect();

\Config::set("database.connections.mysql", [
    'driver' => 'mysql',
    "host" => "127.0.0.1",
    'port' => '3306',
    "database" => "db_database",
    "username" => "db_username",
    "password" => "db_password"
]);

二、操作数据库

$users = DB::connection("mysql_test")->table('users')->select(['id', 'name'])->first();

三、如果要根据某条件随意切换

在laravel公共控制器Controller.php加一个构造方法__construct()

逻辑自己写，思路懂就好

class Controller extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;

    public function __construct() {

        if () {
            DB::disconnect();
            $databases = app()['config']['database']['connections']['mysql'];
            \Config::set("database.connections.mysql", $databases);
        } else {
            DB::disconnect();
            $databases = app()['config']['database']['connections']['mysql_test'];
            \Config::set("database.connections.mysql", $databases);
        }
    }
}