問題描述
在我的應(yīng)用程序中，我有幾個 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:
創(chuàng)建一個 City 模型，在其構(gòu)造函數(shù)中要求提供表名:
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() );
這篇關(guān)于Laravel 4:一個模型可以服務(wù)多個數(shù)據(jù)庫表嗎?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！