Return json with data from three tables in Laravel

Question

//CartController
$itens = CartItem::where('id_cart', $cart->id)->with('product')->get();
return response()->json($itens);

This code returns a JSON with the data of the cart item and the relative product. But I also want to return the images of the product, which is in the ProductImages table.

In my model CartItem.php I have

 public function product(){
    return $this->belongsTo('App\Product', 'id_product');
}

In my model Product.php I have

  public function images(){
    return $this->hasMany('App\ProductImages', 'id_product');
}

But, if I do

 $itens = CartItem::where('id_cart', $carrinho->id)->with('product')->with('image')->get();

I get the error

Call to undefined relationship [images] on model [App\CartItem]

Amit Gupta · Accepted Answer · 2016-12-20 17:28:06Z

6

You can try it as:

CartItem::where('id_cart', $carrinho->id)->with('product.images')->get();

To eager load nested relationships, you may use "dot" syntax.

Docs

edited Dec 20, 2016 at 17:28

answered Dec 20, 2016 at 17:22

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexey Mezenin · Accepted Answer · 2016-12-20 17:23:44Z

2

You should load two tables by using with():

CartItem::where('id_cart', $cart->id)
        ->with('product', 'product.images')
        ->get();

You can read an explanation here (see Nested Eager Loading section).

answered Dec 20, 2016 at 17:23

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Comments

Sylvain Attoumani · Accepted Answer · 2016-12-20 17:24:06Z

2

you should make use of the nested eager load function:

$books = App\Book::with('author.contacts')->get();

https://laravel.com/docs/5.3/eloquent-relationships#eager-loading

answered Dec 20, 2016 at 17:24

Sylvain Attoumani

1,2041 gold badge16 silver badges36 bronze badges

Comments

Naresh Suman · Accepted Answer · 2016-12-21 09:17:57Z

0

Just use like this

$itens = CartItem::where('id_cart', $carrinho->id)->with('product','images')->get();

answered Dec 21, 2016 at 9:17

Naresh Suman

474 bronze badges

Collectives™ on Stack Overflow

Return json with data from three tables in Laravel

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related