Select from three tables using eloquent

@johnef_sh Could you not just grab your products, and eager load the sub-category and category relations?

$products = Product::with('subCategory.category')->get();

<ul>
  @foreach($products as $product)
    <li>{{ $product->name }} is in {{ $product->subCategory->name}} sub-category and {{ $product->subCategory->category->name }} category</li>
  @endforeach
</ul>

Try with this ...

public function serviceSubCat()
    {
        return $this->hasMany('ServiceSubCat', 'cat_id');
    }

public function ssContent()
    {
        return $this->hasMany('SubCatContent', 'sub_cat_id');
    }

@tomi I just tried this part but got

Undefined property: Illuminate\Database\Eloquent\Collection::$title

can you post your view code where you call title property

@martinbean sorry didn't get this

you mean that I cloud do something like this

$serCat = ServiceCat::where('id', $id)->with('serviceSubCat.ssContent')->first();

I try this and no luck

@tomi yes of course here you are

@foreach($serCat->serviceSubCat as $ser)
            {{ $ser->sub_cat_name }}
            {{ $ser->ssContent->title }}
        @endforeach

try

@foreach($serCat->serviceSubCat as $ser)
    {{ $ser->sub_cat_name }}
    @foreach( $ser->ssContent as $ssContent)
        {{ $ssContent->title }}
    @endforeach
@endforeach

@tomi yes I did something like this and worked thanks guys so much

@johnef_sh Be careful with @tomi’s solution: it suffers from N+1 problem, so if you have a lot of categories with a lot of sub-categories with a lot of products, that’s going to generate a lot of SQL statements.

@martinbean

i think that he uses relationship, bellow is code from firt post

$subCats = ServiceSubCat::with('ssContent')->where('cat_id', $id)->get();

Can anyone describe more about this N+1 issue and how to avoid this? thanks @martinbean for informing me about that

Check this post for answer

https://laracasts.com/discuss/channels/general-discussion/what-is-the-meaning-of-the-n-1-problem/replies/47286

@johnef_sh It’s basically doing a query in a loop.

If you have one query that returns 10 results, and then loop over the 10 loops and do a query in each iteration to get some other data, then that’s a total of 11 queries executed. So N is the number of iterations, plus the original query, ergo N+1.

You’ll actually have a worse problem as you’ll have two levels of looping (one loop to get sub-categories, and then a loop inside that one to get a sub-category’s products).

I understand the issue Thanks for @martinbean and @tomi but any solution for this issue I saw Eager Loading and I am reviewing it now if you guys can suggest any solution, thanks again

I edit my code now dose this solves the issue

public function show($id)
    {
        $serCat = ServiceCat::where('id', $id)->with('serviceSubCat.ssContent')->first();
        $getId = $serCat->sub_status;
        if ($getId == 1) {
            return View::make('portal.services.servicesDetailsList', compact('serCat'));
        } else {
            return View::make('portal.services.servicesDetails');
        }
    }

thanks