Controller method issue in Laravel Eloquent

Question

This is my Controller method wherein I want to fetch posts by user id. I also have relationship defined in User model

public function posts()
{
    return $this->hasMany('Post','user_id','id');
}

UserController.php

use App\Post;
public function findPostsByUser($id){
    $user = User::findOrFail($id);    
    $posts = $user->posts()->get();
    return $posts;
}

But it is giving me 'Post' not found error. Can someone help on this.

Please update this first >hasMany('Post','user_id','id') to >hasMany('App\Post','user_id','id') — Vipertecpro
– Vipertecpro, Commented Mar 2, 2019 at 12:59
If you wont to get only posts use Post::where('user_id', $id)->get() — Davit Zeynalyan
– Davit Zeynalyan, Commented Mar 2, 2019 at 13:15

Piazzi · Accepted Answer · 2019-03-02 13:08:56Z

2

In your Post model make sure you have the relation defined like this:


public function user()
{
    return $this->belongsTo('App\User');
}

And change your User model to this:

public function posts()
{
    return $this->hasMany('App\Post','user_id','id');
}

answered Mar 2, 2019 at 13:08

Piazzi

2,6563 gold badges14 silver badges27 bronze badges

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

Comments

Davit Zeynalyan · Accepted Answer · 2019-03-02 13:13:09Z

2

Change relation method to

use App\Post;
....
public function posts()
{
    return $this->hasMany(Post::class,'user_id','id');
}

or

public function posts()
{
    return $this->hasMany('App\Post','user_id','id');
}

If you wont to get only posts that case use this

public function findPostsByUser($id){
    $posts = Post::where('user_id', $id)->get();
    return $posts;
}

The second solution has 1 query, but first solution has 2 query in db.

Also you can do it this way

public function findPostsByUser($id){
    $posts = Post::whereUserId($id)->get();
    return $posts;
}

answered Mar 2, 2019 at 13:05

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges