Eloquent - How to use "Has Many Through" relation?

Question

I have three tables - products, features and product_feature - as

products
    - id
    - name
features
    - id
    - key
product_feature
    - product_id
    - feature_id
    - value

I was retrieve all (key, value) pairs for a product. The SQL statement is

SELECT key, value FROM products
JOIN product_feature pf
ON pf.product_id = "Product ID"
JOIN features f
ON f.id = pf.feature_id

How do I established that relationship

// Inside Product model
function features() {
    // Has many through relationship
}

score 0 · Accepted Answer · answered Sep 05 '18 at 03:32

0

This is a BelongsToMany relationship:

public function features() {
    return $this->belongsToMany(Feature::class, 'product_feature')->withPivot('value');
}

foreach($product->features as $feature) {
    // $feature->key
    // $feature->pivot->value
}

answered Sep 05 '18 at 03:32

Jonas Staudenmeir

24,815
6
63
109

Is there any way to access the value attribute without using pivot? Like `$feature->value` – Tushar Bhatt Sep 05 '18 at 11:10
You can replace `->withPivot('value')` with `->select('features.*', 'product_feature.value')`, but that's not recommended. – Jonas Staudenmeir Sep 05 '18 at 14:20

Eloquent - How to use "Has Many Through" relation?

1 Answers1