fetch & display category and its products

You can use the Collection chunk method to group your categories into chunks of 4:

$categories = Category::with('products')->get() // returns an Eloquent collection
	->chunk(4); // returns a collection of collections

In the view:

@foreach ($categories as $chunk)
	
	<div class="row">
	
	@foreach ($chunk as $category)
		
		<div class="col-3">
		
		@foreach ($category->products as $product)

			// display product

		@endforeach
		</div> <!-- /col-3 -->
	@endforeach
	</div> <!-- /row -->
@endforeach

@tykus Thanks,

in the most inner loop where we have

@foreach ($category->products as $product)

we get

Illuminate\Database\Eloquent\Collection Object
(
    [items:protected] => Array
        (
            [0] => App\Product Object
                (

display correct but loop disturb i need to get only 8 items if available so if i use array_chunk it will give error

thank for your help

There is no native Eloquent way to fetch only 8 products for each category, but there is a package by Staudenmeir which allows you to limit the products returned per category. You could chunk the products in each category in a similar way to the categories collection

on my blade i write

@foreach ($categories as $chunk)
					<div class="row mb-4">
						@foreach ($chunk as $category)

							@if($category->products->count() > 0)

								<div class="col-md-3">
			                        <div class="silder-item">
										@foreach($category->products as $product)

											{{$product->product_name }}

										@endforeach
									</div>
									
								</div>

							@endif

						@endforeach
					</div>
				@endforeach
						

this works fine how ever the issue is row and column breaks like below in html image i don't know.

https://ibb.co/nnQ6djF

first row have 4 columns then empty row ? why this ?

Do you have any idea ?

Is it possible that you have categories that have no products? Debug it.

You can guard against getting these categories at all by modifying the query:

$categories = Category::with('products')
	->has('products') // only returns categories that have some products
	->get()
	->chunk(4); 

I guess this will worked.

And who i use paginate with this above query ?

@tykus Instead of whereHas it's better has in that case.

@michaloravec correct

Thanks for help it woks the only remaining part is how i get previous nest pagination link with our above query

so did we get pagination with chunk ?