Laravel get model from ID with belongtoMany

Question

I'm building an application using Laravel 4 but have some problems with the pivot tables. there are 3 tables Categories , Products , products_categories (pivot) Category model ``` public function product() { return $this->belongsToMany('Product', 'products_categories'); } ``` Products Model ``` public function category() { return $this->belongsToMany('Category', 'products_categories'); } ``` `products_categories` table has `product_id` and `category_id` columns. What I want is take all products in this category and list them in views ``` $category = Category::where('id' , '=' , '7')->first(); foreach($category->product as $product){ echo $product->id; } ``` I can see product ids related with particular category but when I want to use it to get all product itself like: ``` $category = Category::where('id' , '=' , '7')->first(); foreach($category->product as $product){ $product = Product::where('id' , '=' , $product->id )->get(); } return View::make('index')->with('product',$product); `…

Accepted Answer

The immediate issue is that you're trying to reuse your iterator variable from the foreach loop. This is leading to your unexpected results.

```
foreach($category->product as $product) {
                              ^^^^^^^^
    $product = Product::where('id' , '=' , $product->id )->get();
    ^^^^^^^^
}
```

However, there is no need to do any of that. `$category->product` is already a Collection of the Eloquent Product models. There is no need to try and retrieve the individual products again; you already have them.

If you're trying to pass this Collection to the view, you could just do:

```
return View::make('index')->with('product', $category->product);
```

Also, as a side note, if you're trying to find a record by the id, you can use the `find()` method:

```
$category = Category::find(7);
```

Laravel get model from ID with belongtoMany

Solution

Problem