Hello to all, welcome to therichpost.com. In this post, I will tell you, Tables Relationship in Laravel to get data. Laravel is one of the top php mvc framework and growing very faster.

Here is the working to get data from multiple tables with relationship:

Product-table Model:

public function categories(){
return $this->hasMany('App\Category','product_id');
}

Category-Table Model:

public function attributes(){
return $this->hasMany('App\Attribute','cat_id');
}


In your Controller:

public function index()
{
    $productDetails = Product::with('catgories.attributes')->get();
    if(!empty($productDetails)) {
        $jsonData = json_encode($productDetails->toArray());
    }
}

 There are so many code tricks in laravel and i will let you know all. Please do comment if you any   query related to this post. Thank you. Therichpost.com