2014-06-09 23:04
浏览 141

Laravel Eloquent with() - >返回null

I am trying to use Eloquent to get a specific product that has a brand_id column that maps to a brands table, the brand array is coming back empty.

Is there anything obvious here that needs to be changed?

$product = Product::with('images')->with('brand')->select($fields)->where('display', '=', 1)->find($id);

//Product model

class Product extends Eloquent {
    public function brand()
        return $this->belongsTo('Brand');

//Brand model

class Brand extends Eloquent {
public function products()
    return $this->hasMany('Product');
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douhua1890 2014-06-10 00:13

    You have this:

    $product = Product::with('images', 'brand')
                      ->where('display', 1)

    You are getting null for brand and it could be because you have some specific fields and most probably you didn't select the foreing_key from the products table that creates the relationship with Brand, so if your products table contains the foreign_key (probably brand_id) of brand table then you have to select that foreign_key from the products table too. So, just add that foreign_key/brand_id in the $fields variable. Without the relation builder key (FK) the Brand won't be loaded.

    打赏 评论

相关推荐 更多相似问题