Laravel 获取与其属性同名的 Eloquent 关系

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

我有这样的数据库表:

shoot: id, name, programme
programme: id, name

拍摄中的雄辩关系是这样定义的:

The eloquent relationship in the shoot is defined like this:

public function programme() {
    return $this->belongsTo('AppProgramme', 'programme', 'id');
}

使用 dd() 时，我可以看到这是正常工作的:

When using dd(), I can see this is working correctly:

dd(Shoot:where('id','=',1)->with('programme')->first());
// prints the object with programme listed under the relationship

但是，当我急切加载拍摄并尝试获取程序对象时，我反而检索了拍摄属性程序".例如:

However when I eager-load the shoot and attempt to get the programme object, I retrieve the shoot attribute "programme" instead. E.g.:

$shoot = Shoot:where('id','=',1)->with('programme')->first();
echo $shoot->programme; // returns 1, not AppProgramme object.

有没有无需重写大量代码库的解决方案?

Is there a solution to this without having to rewrite masses of the codebase?

推荐答案

relationship 和 column 名称不应使用相同的名称，否则您将将始终收到 column 名称，因此尝试编辑其中之一，我认为这里最简单的是 relationship 名称:

You shouldn't use the same name for the both relationship and column name, else you'll receive always the column name so try to edit one of them, I think the easiest one here is the relationship name :

public function programmeObj() {
    return $this->belongsTo('AppProgramme', 'programme', 'id');
}

然后将其称为:

echo $shoot->programmeObj;

注意:但如果你想遵循约定，你应该用 programme_id 替换 name 属性，所以:

NOTE : But if you want to follow conventions you should replace the name attribute by programme_id so :

public function programme() {
    return $this->belongsTo('AppProgramme', 'programme_id', 'id');
}

希望这会有所帮助.

相关文章