Eloquent Relationship returns multiple arrays

Question

I have set up a relationship between 2 models Route and Booking

a Route has many bookings a Booking belongs too a route

Route Model:

//
public function books()
{
    return $this->hasMany(Booking::class);
}

Booking Model

public function route()
{
    return $this->belongsTo(Route::class);
}

Now in my controller i try to access the route a particular booking belongs to

public function bookFeed(Request $request, Booking $booking)
{
    $bookR = $booking->with('route')->get();

    dd($bookR);
}

or even this

$bookR = $bookRef->route()->get();

dd($bookR);

and i get a collection with multiple Route arrays, now to access a value i have to do

$bookR[0]->value

why is this so, what am i doing wrong?

Try $booking->load('route'); instead of $booking->with('route')->get() This will load the related route of your booking. Your code starts a new query when using like this. — Hilmi Erdem KEREN
– Hilmi Erdem KEREN, Commented Apr 11, 2018 at 10:39

Sohel0415 · Accepted Answer · 2018-04-11 10:55:51Z

2

Use first() in your query

$bookR = $booking->route()->first();

or

$bookR = $booking->route

edited Apr 11, 2018 at 10:55

answered Apr 11, 2018 at 10:36

Sohel0415

9,89124 silver badges32 bronze badges

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

4 Comments

Sohel0415 Over a year ago

you were using ->get() which generates collection

Dapo Michaels Over a year ago

what if i wanted to use say the id of the retrieved route to query the bookings table again, will i write another query or there's an efficient way to do this?

Hilmi Erdem KEREN Over a year ago

If you check your query logs, this solution executes multiple select queries in database. However this is unnecessary. You already have the booking object. The only thing you need to do is to load the relation instead of querying the booking itself.

Sohel0415 Over a year ago

@dapo you already have booking object, you don't need to bother again

Hilmi Erdem KEREN · Accepted Answer · 2018-04-11 10:48:31Z

1

Try this:

public function bookFeed(Request $request, Booking $booking)
{
    $booking->load('route');

    dd($booking); // or $booking->route now.
}

answered Apr 11, 2018 at 10:48

Hilmi Erdem KEREN

2,01922 silver badges29 bronze badges

Collectives™ on Stack Overflow

Eloquent Relationship returns multiple arrays

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related