本文介绍了在laravel模型中更改数据库连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
所以我使用 Laravel 4.2 ,我想要的一个模型是使用外部数据库,这是我的模型代码:
So i work with Laravel 4.2, what i want is in one of my models use an external database, this is my model code :
<?php
class McibModel extends Eloquent {
/**
* The database table used by the model.
*
* @var string
*/
//here i should call the external database table
protected $table = 'agencies';
}
因此,如果有人有任何想法,我将非常感激.
So please if someone has any idea i will be very appreciative.
推荐答案
不同的模型可以具有不同的数据库连接.因此,您的模型使用普通的默认连接-但您的"McibModel"模型可以使用其他连接:
Different models can have different database connections. So your models use the normal default connection - but your 'McibModel' model can use another connection:
class McibModel extends Model {
protected $connection= 'second_db_connection';
protected $table = 'agencies';
}
然后在您的数据库连接文件中-您将获得以下内容:
Then in your DB connection file - you would have something like this:
return array(
'connections' => array(
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'database1',
'username' => 'user1',
'password' => 'pass1'
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
'second_db_connection' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'database2',
'username' => 'user2',
'password' => 'pass2'
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
),
这篇关于在laravel模型中更改数据库连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!