Get a user with posts

user_17230034 0
Viewed 54

I am trying to get a user with his posts in laravel, so far I have tried to use the following line

User::findOrFail($user_id)->with('posts')->first();

But I am getting the first user on the table regardless of what the user ID specified is.

I have tried to dd the user_id and it's working fine, (getting the user_id from the route).

So far the result I am getting is if the user id is x and the first user in the table has an id of 1 I get the info of user id 1 and his posts.

Thanks in advance!

laravel-8 eloquent laravel php
2 Answers

You have your methods in the wrong order.

  1. findOrFail executes the query immediately, which returns the User record for $user_id.

  2. Chaining that to ->with() will start a new query.

  3. Finally, calling ->first() returns the first User from the database.

Adjust your query as such:

User::with('posts')->findOrFail($user_id);
user_39656310

findOrFailand first will give you the User Object but you have to decide witch function you will use.

If you use Routemodel Binding then you can use: User::with('posts')->first(); or User::load('posts');

If you dont use routemodel Binding you can use findOrFail like that: User::with('posts')->findOrFail($user_id);

user_148071110
Related