Laravel 7 Eloquent relationships not working

Question

Im am using laravel 7. I have 2 tables, products and testimonials. Each testimonial is related to a product. So i made an 2 relationships:

Product: hasMany('App\Models\OM\Testimonial');
Testimonial: belongsTo('App\Models\OM\Product', 'product_id')

But when i dd(Testimonial->with('product)) i get this

array:1 [▼ "testimonials" => Illuminate\Database\Eloquent\Builder {#347 ▼ #query: Illuminate\Database\Query\Builder {#358 ▶} #model: App\Models\OM\Testimonial {#359 ▼ #table: "om_testimonials" #fillable: array:4 [▶] #connection: null #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: false +wasRecentlyCreated: false #attributes: [] #original: [] #changes: [] #casts: [] #classCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #guarded: array:1 [▶] } #eagerLoad: array:1 [▶] #localMacros: [] #onDelete: null #passthru: array:19 [▶] #scopes: [] #removedScopes: [] } ]

Testimonial::with('product')->get(); this would work

Akhtar Munir
– Akhtar Munir

2020-05-12 07:36:20 +00:00
Commented May 12, 2020 at 7:36 — Akhtar Munir
– Akhtar Munir, Commented May 12, 2020 at 7:36

Shizzen83 · Accepted Answer · 2020-05-12 07:28:58Z

3

It's normal, with asks Eloquent for eager-loading your relationship but it does not retrieve it yet because it allows you to add constraints on your "query". You need to do this to retrieve your models and their relationship

Testimonial::with('product')->get();

You should also check the documentation, every detail is here: https://laravel.com/docs/7.x/eloquent-relationships#eager-loading

answered May 12, 2020 at 7:28

Shizzen83

3,5593 gold badges14 silver badges35 bronze badges

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

1 Comment

Radu Adrian Over a year ago

Well that's so stupid of me :))). I was missing de ->get(). Thank you!

DarkBee · Accepted Answer · 2025-02-06 10:48:42Z

0

The issue is that Testimonial::with('product') only prepares the query but does not execute it.
You need to actually retrieve the data.

Use the get() method to execute the query:

$testimonials = Testimonial::with('product')->get();
dd($testimonials);

edited Feb 6 at 10:48

DarkBee

14.4k9 gold badges84 silver badges133 bronze badges

answered Feb 5 at 6:49

Urvisha Mehta

92 bronze badges

Collectives™ on Stack Overflow

Laravel 7 Eloquent relationships not working

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related