Level 102
How are they related? A user HasMany bookings? A booking belongsTo a user (hint hint) :)
Oct 21, 2022
5
Level 1
How to create relationship 😞
Between: Users, Booking, and Pay
Level 73
I suggest giving this a read. It container a technique on how to find out the relationstips you need.
Level 1
If the User has many Bookings, you can use $this->hasMany(), or use $this->hasOne() if the user just have only 1 Booking. It depends on how your table and relation works.
Level 6
Hello my friend If I get it right, you have established the many-to-many-relationships between every two of the three models (User, Booking & pay). Instead, you should establish the many-to-many between any two models of your choice and treat the third model as a pivot. For example:
User.php
class User extends Model
{
public function Bookings()
{
return $this->belongsToMany(Booking::class)->withPivot('pay');
}}
Booking.php
class Booking extends Model
{
public function Users()
{
return $this->belongsToMany(User::class)->withPivot('pay');
} }
view.blade.php
@foreach($Users as $User)
@foreach($User->Bookings as $book)
{{ $book->name }} {{ $book->pivot->pay }}
@endforeach
@endforeach
Level 73
@LoverCode This is a bad advice
@foreach($Users as $User)
@foreach($User->Bookings as $book)
{{ $book->name }} {{ $book->pivot->pay }}
@endforeach
@endforeach
This will introduce a n+1 issue, the bookings should be eager loaded in the controller. Another problem is that a vairable always should start with a lower case letter, not an upper case letter. Classes should start with a upper case letter.
Please or to participate in this conversation.