Friends is a pivot table code is
public function friends() {
return $this->belongsToMany('Trinity\Users\User', 'friends', 'user_id', 'friend_id');
}
Last updated
2 years ago.
Have you ever tried this?
$friend = User::whereHas('friends', function($query) use ($id, $user)
{
$query->where('friend_id', '=', $id)->where('user_id', '=', $user);
})->count();
Last updated
2 years ago.
But there is an option that, user_id is the visiting user id or the other way around.
Last updated
2 years ago.
I see your point.
Make this change:
$query->where('friend_id', '=', $id)->where('user_id', '=', $user)->orWhere('friend_id', '=', $user)->where('user_id', '=', $id);
Last updated
2 years ago.
Solution
I got it working with this
$friend = $this->friends()->where('friend_id', '=', $id)->where('user_id', '=', $user)->orWhere('friend_id', '=', $user)->where('user_id', '=', $id)->first();
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast