Laravel 4:一个模型可以服务多个数据库表吗? [英] Laravel 4: can one model serve several DB tables?

问题描述

在我的应用程序中，我有几个 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:一个模型可以服务多个数据库表吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！