Laravel 4:一个模型可以服务多个数据库表吗?
在我的应用程序中,我有几个 mysql 表:Toronto、Vancouver、Montreal 等……我正在使用 DB-class 来处理它们,例如.
In my application I have several mysql tables: Toronto, Vancouver, Montreal, etc... and I am using the DB-class to work with them, eg.
$data = DB::select('select * from toronto where id = ?', array($id));
我想做的是开始使用 Eloquent.我是 Laravel 的新手,只是想知道是否可以将一个模型与多个表一起工作,例如:
What I want to do is to start using Eloquent. I am new to Laravel and was just wondering if its possible to have one model work with several tables, smth like:
class City extends Eloquent {
protected $table_a = 'toronto';
protected $table_b = 'vancouver';
protected $table_c = 'montreal';
}
推荐答案
它不能,但你可以.有很多方法,这里是一种:
It cannot, but you can. There are many ways, here's one:
创建一个 City 模型,在其构造函数中要求提供表名:
Create your a City model that asks for a table name in its constructor:
class City extends Eloquent {
public function __construct($city, array $attributes = array())
{
parent::__construct($attributes);
$this->table = $city;
}
}
要使用它,您必须使用表名实例化您的类:
To use it you'll have to instantiate your class using the table name:
$toronto = new City('toronto');
然后你可以用它做任何你想做的事情:
Then you can do anything you want with it:
var_dump( $toronto->where('id',701057)->get() );
相关文章