Level 73
You can use distinct in your query and only pull the ones you want instead of handling that in php.
https://laravel.com/docs/8.x/queries#specifying-a-select-clause
Dec 1, 2021
9
Level 2
How to show only Unique values from a foreach loop
hello guys, I have 3 tables Products - Stocks - Colors
Relationships are as follows :
1- Products belongs to many stocks and vice versa with a pivot table [ Product-Stock ]
2- Stock belongs to color
3- Color has many stocks
to access the data in show.blade.php
@foreach($product->stocks as $stock)
<option value="{{$stock->color->color_name}}">{{$stock->color->color_name}}</option>
@endforeach
Product.php
public function getRouteKeyName(){
return 'slug';
}
ProductsController.php
public function show(Product $product)
{
return view('products.show', ['product' => $product]);
}
It works fine, but the loop shows all the colors which shows multiple lines for the same color if the product has many stocks that has the same color. How can I get only unique values from the loop .. so that I avoid having the color repeated. I know that there is a Unique or Distinct function, but not really familiar with how to use them in the controller or blade.
Level 2
Hello @Tray2 .. thanks for your reply, can you please tell me how can i implement it in my case. because I read the docs and I'm familiar with what needs to be done, but not sure how to do it.
Level 73
@MahmoudMonem Show your query and someone here should be able to help with that,
1 like
Level 2
@Tray2 I added the ProductsController content to the original post ..
Level 102
@MahmoudMonem Wow thats alot of n+1
Be sure to load your relations!
$product->load('stocks.color');
return view('products.show', ['product' => $product]);
Level 102
Anyways. Instead try setting up a hasManyThrough, so you can just do $product->colors
https://laravel.com/docs/8.x/eloquent-relationships#has-many-through
Level 2
Hello @Sinnbeck thanks so much for this tip, really never knew there is has manythrough :D will definitely apply it more often. However, I actually had no problem retrieving the data. I just wanted to retrieve without repetition. an show values one time if same stock has multiple color.
Level 2
@mahmoudmonem , hi, this could be useful: @foreach($product->stocks->unique('color') as $attr) . . . @endforeach
Level 2
Hello @Umid82 .. this worked just perfectly :D thank you so much.. is there a way to do it cleaner in the controller ? but this is actually exactly what I was looking for, appreciate ur help <3
Please or to participate in this conversation.