Laravel - Access subcategory from product (belongsTo) in ajax response data.

Question

One products has one subcategory. In my products table I have subcategory_id field. I have also set-up a belongsTo relationship between Product and Subcategory models. So I have a method which returns all products with a certain tag id. Here is my code:

public function getProductsByTag($tag_id)
{
    $tag = Tag::find($tag_id);
    $products = $tag->products; //belongsTo relationship

    return json_encode(['products' => $products]);
}

Then on success in my ajax request I need to access the subcategory of the product like I accessed the products of the tag $tag->products. So in Laravel it would be:

$subcategory = $product->subcategory;

I thought that product.subcategory would do the trick but I get undefined. Here is my ajax success function:

success: function (data) {
    $.each(data.products, function (i, product) {
    console.log(product.subcategory);  
   });
},

I get undefined in my console. How can I access relationships in ajax response data?

in your controller method try this one $products = $tag->products()->with('subcategory')->get(); //belongsTo relationship — zorx
Try this $.each(data, function (i, product) { console.log(product.subcategory); }); — Marko Milivojevic
@zorx This works. However I have a product which has a subcategory which has a category. Now how can I access the category? Post your comment as question so I can approve it. — Codearts

zorx zorx · Accepted Answer · 2016-07-28T11:32:54

As I said in my comment, laravel doesn't load automatically all the relations so you have to do that.

if you would like to load every time subcategories into your products so you have to update you model and add a with attribute like so :

//Product model
protected $with = ['subcategory'];

Or if you just want to do this just once, so you have to do something like :

$products = $tag->products()->with('subcategory')->get();

Laravel - Access subcategory from product (belongsTo) in ajax response data.

2 Answers