Determine selected options based on many-to-many relationship

Question

I have three tables: products, categories and category_product.

In my edit form page I'm displaying the categories and subcategories values in a select box. The chosen category options are saved in the pivot table category_product. This table has product_id and category_id.

Here's my code.

Product model

public function category() {
  return $this->belongsToMany('App\Models\Category');
}

Category model:

public function products()
{
    return $this->belongsToMany(Product::class);
}

edit product page view:

<select name="category_id[]" class="form-control" multiple size = 10>
   @foreach ($parentCategories as $parentCategory)
       <option value="{{ $parentCategory->id }}">{{ $parentCategory->name }}</option>
       @if(count($parentCategory->subcategory))
         @include('includes.subcats-select',['subcategories' => $parentCategory->subcategory])
       @endif
   @endforeach
</select>

subcats-select view

@foreach($subcategories as $subcategory)
  <option value="{{ $subcategory->id }}">---{{ $subcategory->name }}</option>
    @if(count($subcategory->subcategory))
      @include('includes.subcats-select',['subcategories' => $subcategory->subcategory])
    @endif
  </div>
@endforeach

How can I put "selected" attribute to the chosen category options, so when I edit the page to apply the changes properly?

shaedrich · Accepted Answer · 2021-05-25T12:30:13.447

2

You can get pivot table columns the following way:

Product model

public function category() {
  return $this->belongsToMany('App\Models\Category')->withPivot('selected');
}

edit product page View:

<select name="category_id[]" class="form-control" multiple size = 10>
   @foreach ($parentCategories as $parentCategory)
       <option value="{{ $parentCategory->id }}" selected="{{ $parentCategory->pivot->selected }}">
           {{ $parentCategory->name }}
       </option>
       @if(count($parentCategory->subcategory))
         @include('includes.subcats-select',['subcategories' => $parentCategory->subcategory])
       @endif
   @endforeach
</select>

EDIT: While the above answer might be helpful for others, it doesn't answer the question. So here's my second try after some clarification in the chat.

<select name="category_id[]" class="form-control" multiple size = 10>
   @foreach ($parentCategories as $parentCategory)
       <option value="{{ $parentCategory->id }}"{{ $product->category->contains($parentCategory->id) ? 'selected' : '' }}>
           {{ $parentCategory->name }}
       </option>
       @if(count($parentCategory->subcategory))
         @include('includes.subcats-select',['subcategories' => $parentCategory->subcategory])
       @endif
   @endforeach
</select>

edited May 25 '21 at 12:30

answered May 25 '21 at 10:27

shaedrich

5,457
3
26
42

I've updated the product model and tried with your code but I'm getting this error: Trying to get property 'selected' of non-object. – user2519032 May 25 '21 at 10:51
So `$parentCategory` is `$product->category`? – shaedrich May 25 '21 at 10:53
with dd($parentCategories) I'm getting result but with dd($product-category) I'm getting SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category_product.selected' in 'field list' – user2519032 May 25 '21 at 11:13
if I remove ->withPivot('selected') from the model, dd($product->category) works fine – user2519032 May 25 '21 at 11:13
selected="{{ $parentCategory->pivot->selected }}" gives error screen Trying to get property 'selected' of non-object – user2519032 May 25 '21 at 12:06
Don't you have the column `selected` in your `category_product` table? – shaedrich May 25 '21 at 12:06
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/232852/discussion-between-user2519032-and-shaedrich). – user2519032 May 25 '21 at 12:12
No, I don't have "selected" column. Why would I have? I have category_id and product_id – user2519032 May 25 '21 at 12:15

Determine selected options based on many-to-many relationship

1 Answers1