使用CodeIgniter 3中的Illuminate/database Eloquent ORM进行多数据库连接 - Multiple database connection using Illuminate/Database Eloquent ORM in CodeIgniter 3

Multiple database connection using Illuminate/Database Eloquent ORM in CodeIgniter 3

我刚刚将Laravel的数据库层Eloquent包含在我的CodeIgniter3项目中。然而，我的问题是，我无法使用Eloquent模型连接到多个数据库。

对于默认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();

以上操作效果良好。但我有一个来自另一个数据库的员工表。我可以使用查询生成器来使用它，但在Eloquent模型中失败了。

我试过这个：

$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();

尝试建立Eloquent模型并使用类似的连接

protected $connection = "employees";

是否可以使用Laravel之外的Illuminate''Database Eloquent ORM连接到多个数据库？如果是，如何？

Eloquent 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";