问题描述
在我的应用程序中，我有几个 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() );
这篇关于Laravel 4:一个模型可以服务多个数据库表吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！