Laravel - Eloquent: get posts from user with users post table

Question

I searched a lot but could not find any answer about it, so I hope you could help me!

I have three tables: posts, users and post_users. Post_users contains two columns: user_id and post_id.

I need to get all posts by an user with Eloquent. Any ideas?

Answer 1

The Laravel docs cover this pretty well but I had an issue with it when I first started as well. Check out Laravel Relationships for the fully write up.

// Inside your Post model
public function user() {
    return $this->belongsTo('App\User');
}

// Inside your User model
public function posts() {
    return $this->hasMany('App\Posts');
}

You can then create a query:

$posts = User::find(1)->posts;

Or you can filter it further..

$posts = User::find(1)->posts()->where('active', 1)->get();

You may need to change your paths for the hasMany() and belongsTo() if your model location and names are different.

Answer 2

If you donot have relationship built, try this. However building relationships is preferred. PostUsers and Posts are assumed models of post-users and posts tables, and post as column of the posts table. this gives the posts of logged in user, but not tested.

$postusers=PostUsers::where(['user_id'=>Auth::user()->id])->get();
foreach($postusers as $postuser)
{
        $posts=Posts::where(['post_id'=>$postuser->post_id)]->get();
        foreach($posts as $post)
         {
            print_r($post->post);
         }
}

Answer 3

Try this

From Controller :

dd(Auth::user()->posts);

App/User

    public function posts()
    {
        return $this->belongsToMany('App\Entities\posts', 'post_users', 'user_id', 'post_id');
    }

Answer 4

As you wish. Relation between User and Post is many-to-many

- Defined relation

// In User model
public function posts(){
    return $this->belongsToMany(Post::class);
}
// In Post model
public function users(){
    return $this->belongsToMany(User::class);
}

- Table structure

- users
    id
- posts
    id
- post_user
    user_id
    post_id

- Get all post by a user

$posts = User::find($user_id)->posts

Answer 5

make relationship with post model on the user model:

public function posts()
    {
        return $this->hasMany(Post::class);
    }

make relationship with user model on the post model:

 public function User()
    {
        return $this->belongsTo(User::class);
    }

in controller or Wherever you use:

  $userPosts = User::find($user->id)->posts->where('status', 1);