I have a reference table with the following columns:
-user_id (foreign key)
-location_id (foreign key)
-skill_level
-court_id
I can update the skill_level pivot column value in the above table with:
$user = User::find($user_id)
$user->locations()->updateExistingPivot($location_id, array(
'skill_level' => $new_value
));
I would like to add something akin to a wherePivot() to the above so that only records that matches a certain court_id (in addition to user_id and location_id) are updated. Something similar to:
->wherePivot('court_id', '=', $court_id);
How would I do this with an updateExistingPivot() call?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire