Laravel: find if a pivot table record exists

Question

I have two models which are joined by a pivot table, User and Task.

I have a user_id and a task_id.

What is the neatest way to check whether a record exists for this combination of user and task?

I hope this will be solution http://stackoverflow.com/questions/24555697/check-if-belongstomany-relation-exists-laravel — Ayaz Ali Shah, Feb 09 '16 at 07:11

score 62 · Accepted Answer · answered Feb 09 '16 at 07:28

62

You have a couple options depending on your situation.

If you already have a User instance and you want to see if it has a task with a certain id, you can do:

$user = User::find(1);
$hasTask = $user->tasks()->where('id', $taskId)->exists();

You can reverse this if you have the Task instance and want to check for a user:

$task = Task::find(1);
$hasUser = $task->users()->where('id', $userId)->exists();

If you just have the ids, without an instance of each, you could do the following:

$hasPivot = User::where('id', $userId)->whereHas('tasks', function ($q) use ($taskId) {
        $q->where('id', $taskId);
    })
    ->exists();

answered Feb 09 '16 at 07:28

patricus

@patricus, Seems you can help me. Look at this : https://stackoverflow.com/questions/44519339/how-can-i-update-pivot-table-on-laravel – moses toh Jun 13 '17 at 10:59
In my case, what works, considering your example table and column names is: `$user->userTasks()->where('task_id', $taskId)->exists();` but it depends on definition inside of the model files, of course. – Banik Oct 12 '22 at 10:55

Prafulla Kumar Sahu · Answer 2 · 2020-09-22T20:17:54.383

8

You can also try this, this is working in Laravel 5.7

$user = User::find(1);
$hasTask = $user->tasks->contains($taskId);

But the better way will be

$hasTask = $user->tasks()->where('tasks.id', $taskId)->exists();

edited Sep 22 '20 at 20:17

answered Feb 20 '19 at 13:34

1

Avoid doing is - this retrieves all the tasks for a certain user, puts them in memory and then checks if the $taskId is in there. – Eduardo Mar 31 '20 at 23:16
@Eduardo yes people should prefer eager loading or relationship query instead of collection for checking this. – Prafulla Kumar Sahu Apr 01 '20 at 03:43
@Eduardo I have updated my answer, I think this will be better this way. – Prafulla Kumar Sahu Apr 20 '20 at 05:56

score 6 · Answer 3 · answered Feb 09 '16 at 07:27

6

may be you search this?

$users = User::has('task')->get();

answered Feb 09 '16 at 07:27

Yurich

score 1 · Answer 4 · answered May 08 '20 at 07:55

1

Easiest to read for me is:

$user->tasks()->exists();

answered May 08 '20 at 07:55

score -3 · Answer 5 · edited Oct 16 '18 at 14:40

-3

You can use the code below:

$user = User::find(1);

$hasTask = $user->tasks()->where('task_id', $taskId)->exists();

edited Oct 16 '18 at 14:40

louisfischer

answered Jan 30 '18 at 09:53

pumpum

5 Answers5