Laravel, sync() – how to sync an array and also pass additional pivot fields?

by

In order to sync multiple models along with custom pivot data, you need this:

$user->roles()->sync([ 
    1 => ['expires' => true],
    2 => ['expires' => false],
    ...
]);

Ie.

sync([
    related_id => ['pivot_field' => value],
    ...
]);

edit

Answering the comment:

$speakers  = (array) Input::get('speakers'); // related ids
$pivotData = array_fill(0, count($speakers), ['is_speaker' => true]);
$syncData  = array_combine($speakers, $pivotData);

$user->roles()->sync($syncData);

More Related Contents:

  1. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  2. Automatically deleting related rows in Laravel (Eloquent ORM)
  3. Get Specific Columns Using “With()” Function in Laravel Eloquent
  4. How do I get the query builder to output its raw SQL query as a string?
  5. How to do this in Laravel, subquery where in
  6. Laravel Eloquent Query Using WHERE with OR AND OR?
  7. Laravel Check If Related Model Exists
  8. Laravel update model with unique validation rule for attribute
  9. How can I convert many statement mysql to laravel eloquent?
  10. Eloquent ORM Code Hinting in PhpStorm
  11. Laravel Model with Two Primary Keys update [duplicate]
  12. Laravel eager loading with limit
  13. Laravel OrderBy relationship count
  14. Laravel Eloquent: How to order results of related models?
  15. How to set a default attribute value for a Laravel / Eloquent model?
  16. Laravel – Database, Table and Column Naming Conventions?
  17. Order By before Group By using Eloquent (Laravel)
  18. How to Merge Two Eloquent Collections?
  19. How to create a subquery using Laravel Eloquent?
  20. Eloquent model mass update
  21. Difference between Eloquent\Model::get() and all()
  22. Laravel 4.1: How to paginate eloquent eager relationship?
  23. Eloquent many-to-many-to-many – how to load distant relation easily
  24. Laravel Eloquent: How to get only certain columns from joined tables
  25. How can I query raw via Eloquent?
  26. Find or Create with Eloquent
  27. A __construct on an Eloquent Laravel Model
  28. How to get last insert id in Eloquent ORM laravel
  29. Laravel Many to many self referencing table only works one way
  30. Merge ‘with’ and ‘whereHas’ in Laravel 5

Leave a Comment