Laravel Eloquent, difference between attach() and syncWithoutDetaching()

Question

I'm wondering if there is a difference between the two following Eloquent instructions that update the data on the role_user pivot table of a many-to-many relationship between User and Role models.

// Attach the specified roles to the user
$user–>roles()–>attach([1, 2, 3]);

// Sync the specified roles without detaching the one previously assigned to the user
$user–>roles()–>syncWithoutDetaching([1, 2, 3]);

I think they do the same thing, am I correct?

I did now in Tinkerwell. I got the same result. What changes is the return value. From attach() is always null in any case. From syncWithoutDetaching() I get an array as return value. With the ids of the field attached, detached and updated. I guess that detached will always be empty in this case. [ "attached" => [], "detached" => [], "updated" => [], ] — Davide Casiraghi
– Davide Casiraghi, Commented Jan 27, 2021 at 12:47
did you make sure that this pivot table already has records matching 1, 2, 3 before running syncWithoutDetaching then see what the table looks like? did you then after that run attach and look at the pivot table? as that would answer this for you — lagbox
– lagbox, Commented Jan 27, 2021 at 12:48
I'm not getting why somebody voted down. To me seems an interesting question moved by curiosity to understand beyond the contents of the documentation. — Davide Casiraghi
– Davide Casiraghi, Commented Jan 27, 2021 at 12:48
same result ... did syncWithoutDetaching add new records or not? did attach add new records or not? run syncWithoutDetaching 5 times, are there 5 times as many new records? run attach 5 times, are there 5 times more records? — lagbox
– lagbox, Commented Jan 27, 2021 at 12:54

rakeysharyal · Accepted Answer · 2021-01-27 12:40:21Z

1

"attach" method inserts the array argument without syncing or removing existing data while "syncWithoutDetaching" method updates the existing value comparing with array argument and also does not remove rest of the existing values.

answered Jan 27, 2021 at 12:40

rakeysharyal

963 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tinystone Over a year ago

sync vs syncWithoutDetaching, explained 1 2

Collectives™ on Stack Overflow

Laravel Eloquent, difference between attach() and syncWithoutDetaching()

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related