How to fetch data using with via object in Laravel eloquent?

Question

Actually, I want to fetch data using Model object not through Model facade like mention below.

$user = $this->getGuard()->user();

Above user is current logged user which is

        "id": 6,
        "name": "kuser",
        "email": "[email protected]",
        "phone": "03345154067",
        "is_subscribed": 0,
        "subscription_date": null

But when I try to fetch same $user object with its related model like cards, by execute $user->with(['cards'])->first(); than it gives first record of user table with cards like mentioned below.

        "id": 1,
        "name": "admin",
        "email": "[email protected]",
        "phone": "03056494616",
        "is_subscribed": 1,
        "subscription_date": "2019-10-08",
        "cards": []

Above mentioned record which is user object. It is first record of my user table.

Actually, I am expecting.

      "id": 6,
        "name": "kuser",
        "email": "[email protected]",
        "phone": "03345154067",
        "is_subscribed": 0,
        "subscription_date": null

with its related model cards like

      "id": 6,
        "name": "kuser",
        "email": "[email protected]",
        "phone": "03345154067",
        "is_subscribed": 0,
        "subscription_date": null
        "cards":[] // array of cards those belongs to it.

lagbox · Accepted Answer · 2019-10-09 17:56:11Z

2

You can use Lazy Eager Loading, you don't have to query for the user again, you already have it:

$user = $this->getGuard()->user();

$user->load('cards');

Laravel 6 Docs - Eloquent - Relationships - Lazy Eager Loading

answered Oct 9, 2019 at 17:56

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

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

1 Comment

Muhammad Sulman Over a year ago

yep its working fine. This is what, I really wanted yesterday. Thanks

Abhay Maurya · Accepted Answer · 2019-10-09 07:39:13Z

1

Use a simple where ?

$user->where('id', Auth::id())->with(['cards'])->first();

won't that work?

answered Oct 9, 2019 at 7:39

Abhay Maurya

12.3k9 gold badges50 silver badges67 bronze badges

4 Comments

Muhammad Sulman Over a year ago

It works, infact now, I used to fetch this way User::with(['cards'])->find($user->id). But, it has some little bit extra effort so, I try to find better one approach.

Abhay Maurya Over a year ago

whats the "extra effort" here if i may ask?

Muhammad Sulman Over a year ago

$user->where('id', Auth::id())->with(['cards'])->first(); I think it should be like $user->with('cards') and that's it. Hope so, you got that point. But anyway it also fair enough.

Abhay Maurya Over a year ago

You dont wanna use $user = $this->getGuard()->user();, you also dont wanna use where, script cant assume itself which user you are reffering to

Muhammad Sulman · Accepted Answer · 2019-10-09 11:03:51Z

0

Here is another way

User::with(['cards'])->find($user->id);

answered Oct 9, 2019 at 11:03

Muhammad Sulman

1,6912 gold badges21 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to fetch data using with via object in Laravel eloquent?

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related