如何更改Laravel Dynamic中的数据库?假设我们有以下变量:
- $ host(mysql主机名/ip)
- $ user(mysql用户名)
- $ name(mysql数据库名称)
- $ pass(mysql用户密码)
如何在laravel 5中连接到此MySQL Server,而无需每次在配置中设置它?
问候
假设一个模型Book
use Book;
use IlluminateSupportFacadesDB;
use IlluminateSupportFacadesConfig;
public function configureDatabase($database){
Config::set("database.connections.$database", array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => "$database",
'username' => 'root',//User name here
'password' => '***', //Password here
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
));
}
public function getBooks($database){
$this->configureDatabase($database)
return Book::on($database)->all();
}