如何更改 laravel 的连接表单控制器,但连接信息存储在数据库中,如数据库管理器,我的示例:
我的数据库中有数据库信息:
id, driver, database_name, username, password, host
所以在我的控制器上只需调用:
$connection = Database::find( 1 );
$users = new Users();
$users->setConnection( [
'driver' => $connection->driver,
'host' => $connection->host,
'username' => $connection->username,
'password' => $connection->password
] );
$users = $users->get();
我要去这里找一个帮手。让我们创建一个app/Helpers/DatabaseConnection.php
.
namespace App\Helpers;
use Config;
use DB;
class DatabaseConnection
{
public static function setConnection($params)
{
config(['database.connections.onthefly' => [
'driver' => $params->driver,
'host' => $params->host,
'username' => $params->username,
'password' => $params->password
]]);
return DB::connection('onthefly');
}
}
现在在控制器的某个地方我们尝试
use App\Helpers\DatabaseConnection;
...
$params = Database::find( 1 );
$connection = DatabaseConnection::setConnection($params);
$users = $connection->select(...);
注:未测试。我希望它有效或只是指导你
更多信息:
使用多数据库:https://laravel.com/docs/5.3/database#read-and-write-connections https://laravel.com/docs/5.3/database#read-and-write-connections
即时设置配置:https://laravel.com/docs/5.3/configuration#accessing-configuration-values https://laravel.com/docs/5.3/configuration#accessing-configuration-values
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)