从当前数据库创建Laravel多个mysql连接 [英] Creating laravel multiple mysql connection from current database

问题描述

我想在当前的laravel数据库中存储多个数据库连接. 我需要通过下拉列表连接这些文件，并即时生成报告. 最好的配置方式是什么

I want to store multiple database connection in my current laravel db. i need to connect these via dropdown and generate reports on the fly. what is the best way to configure this

推荐答案

您可以在第一个数据库中创建一个表"connection(strings)"，然后为该表创建一个模型.

You can just create a table "connection(strings)" in your 1st db and create a model for that table.

之后，您可以执行以下操作:

After that you can do something like this:

$selected = Connection::query()->where('name', 'fromdropdown')->first();
   $connection = $selected;
                config(['database.connections.data' => array(
                    'driver'    => 'sqlsrv',
                    'host' => $connection['Database_Server'],
                    'database' => $connection['Database_Name'],
                    'username' => $connection['Database_User'],
                    'password' => $connection['Database_Pass']

                )]);

                DB::setDefaultConnection('data');

这篇关于从当前数据库创建Laravel多个mysql连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！