Laravel hasMany() relationship not getting values

Question

I have three tables: customers, orders and books. Orders store customers id and books store orders id.

To list orders item on customer page, I add this method to customer model:

public function customerOrders()
{
    return $this->hasMany('App\Order', 'id_customer');
}

Works fine.

Now I need to grab books for each order. So I add this method to order model:

public function orderBooks()
{
    return $this->hasMany('App\OrderBooks', 'id_order');
}

When I try to get orderBooks info inside a loop:

@foreach($customer->customerOrders as $order)
...
{{ $order->orderBooks->id }}
...

Laravel return

Property [id] does not exist on this collection instance.

How I'm sending data to view:

return view('register.customers.show', compact('customer'));

Migrations:

Schema::create('customers', function (Blueprint $table) {
    $table->increments('id');
    $table->timestamps();
});

Schema::create('orders', function (Blueprint $table) {
    $table->increments('id');
    $table->unsignedInteger('id_customer')->nullable();
    $table->foreign('id_customer')->references('id')->on('customers')->onDelete('set null');
    $table->timestamps();
});

Schema::create('books', function (Blueprint $table) {
    $table->increments('id');
    $table->unsignedInteger('id_order')->nullable();
    $table->foreign('id_order')->references('id')->on('orders')->onDelete('set null');
    $table->timestamps();
});

Can you post your migrations so we can double check this against your database layout? — Michael Miller
– Michael Miller, Commented Feb 5, 2019 at 20:12
See @Pourbahrami's solution below. That would be my recommendation. — Michael Miller
– Michael Miller, Commented Feb 5, 2019 at 20:35

Pourbahrami · Accepted Answer · 2019-02-05 20:30:34Z

3

try this:

@foreach($customer->customerOrders as $order)
    @foreach($order->orderBooks as $book)
        {{ $book->id }}
    @endif
@endif

answered Feb 5, 2019 at 20:30

Pourbahrami

3203 silver badges16 bronze badges

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

Comments

Piazzi · Accepted Answer · 2019-02-05 20:38:14Z

0

This error:

Property [id] does not exist on this collection instance.

is happening because you're trying to get a id from a collection, you want the id from the objects inside the collection

Try this instead:


@foreach($customer->customerOrders->orderBooks as $book)
{{ $book->id }}
@endforeach

answered Feb 5, 2019 at 20:38

Piazzi

2,6563 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

Laravel hasMany() relationship not getting values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related