我刚刚包含了Laravel的数据库层,雄辩地介绍了我的CodeIgniter 3项目。然而,我的问题是,我无法使用雄辩的模型连接到多个数据库。
对于默认DB,我是这样配置DB的:
$capsule = new Capsule;
$capsule->addConnection(array(
'driver' => 'mysql',
'host' => "localhost",
'database' => "employees_db",
'username' => "root",
'password' => "",
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
));
$capsule->setAsGlobal();
$capsule->bootEloquent();上面的效果很好。但我在另一个数据库里有个雇员表。我可以使用query来使用它,但是如果使用雄辩的模型,就会失败。
我试过这个:
$employees = new Capsule;
$employees->addConnection(array(
'driver' => 'mysql',
'host' => "host2",
'database' => "employees_db",
'username' => "user",
'password' => "pass",
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),'employees');
$employees->setAsGlobal();尝试建立一个雄辩的模型,并使用如下的连接:
protected $connection = "employees";是否有可能在Laravel之外使用照明\数据库雄辩的ORM连接多个数据库?如果是,怎么做?
发布于 2016-01-07 08:13:05
雄辩的ORM只需要初始化一次。添加可选的第二个参数作为连接名。
$capsule = new Capsule;
$capsule->addConnection(
array(
'driver' => 'mysql',
'host' => "localhost",
'database' => "employees_db",
'username' => "root",
'password' => "",
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
"default"
);
$capsule->addConnection(
array(
'driver' => 'mysql',
'host' => "192.168.1.1",
'database' => "employees_db2",
'username' => "user",
'password' => "password",
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
"employees"
);
$capsule->setAsGlobal();
$capsule->bootEloquent();设置上述内容后,可以通过编写以下代码,在模型文件中分配要连接到的数据库:
protected $connection = "employees";https://stackoverflow.com/questions/34649181
复制相似问题