Laravel 4:一个模型可以服务多个数据库表吗?

2021-12-26 00:00:00 php laravel laravel-4 eloquent

在我的应用程序中,我有几个 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() );

相关文章