Level 2
Hi,
Maybe you're looking for the ->sync() relationships method. Take a look here :
https://laravel.com/docs/5.6/eloquent-relationships#updating-many-to-many-relationships
It should do the job, instead of a foreach loop.
Jul 20, 2018
4
Level 1
Updating multiple many to many relationships
I am wondering if there is a best practice when it comes to updating the pivot table for a many to many relationship. I currently have the following code which updates each pivot table record individually, but wonder if there is a better way to do this?
foreach( $job->codes as $code ) {
$job->codes()->updateExistingPivot(
$code->id,
[
'approved' => 1
]
);
}
Level 1
Thanks for the response @Jawelo. From what I read, sync() is used to construct new many to many relations, not update existing ones. It also requires a list of IDs to sync the relationship with, which I don't have without doing some sort of foreach over the returned collection. I will see if I can get the list of IDs out of that and see if sync() will work for me.
Level 1
Pretty sure your original idea is the way to go.
Level 6
why not using the DB facade? May be easier.
DB::table('code_job')->where('job_id', $job_id)->update['approved',1]);
1 like
Please or to participate in this conversation.