Laravel: find if a pivot table record exists

php laravel eloquent pivot-table
datavoredan picture datavoredan · Feb 9, 2016 · Viewed 19.2k times · Source

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?

Answer

patricus picture patricus · Feb 9, 2016

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();

Related questions

Insert data to a pivot table in laravel

I have 3 tables: posts, tags, post_tag. Each Post has many tags so I use hasMany method for them. But when I choose for example 3 tags in my dropdown list, I can't add them to post_tag and as the …

Read More
Filtering pivot table data with Laravel models

Let's say I have three tables (this is just an example): users user_id username roles role_id name user_roles user_id role_id primary (boolean) And the corresponding laravel models: class User extends Eloquent { public function roles() { return $…

Read More
How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant. Example: $results = User::where('this', '=', 1) ->where('that', '=', 1) …

Read More