Breaking News: Grepper is joining You.com. Read the official announcement!

update a pivot table using Eloquent

Make Your Own Project answered on September 25, 2021 Popularity 9/10 Helpfulness 8/10

answer update a pivot table using Eloquent

related laravel + update pivot table

update a pivot table using Eloquent

Comment

$user = User::find(1);

$user->roles()->updateExistingPivot($roleId, [
    'active' => false,
], false);

//The last param is to not update time updated_at column timestamp.

Popularity 9/10 Helpfulness 8/10 Language php

Source: laravel.com

Tags: eloquent php pivot-table using

Link to this answer
Share Copy Link

Contributed on Sep 25 2021

Make Your Own Project

0 Answers Avg Quality 2/10

Closely Related Answers

laravel + update pivot table

Comment

// A user has many roles
// The BelongsToMany relationship uses a pivot table
public function roles(): BelongsToMany {
	return $this->belongsToMany(
      User::class, 
      'users_roles',
      'user_id',
      'role_id'
    );
}
// Example roles
// Role 1 = 'Editor';
// Role 2 = 'Guest';

// Lets update the attached roles for each user using sync()
User::chunk(5000, function ($users) { // Get a chunk of the users
	$users->each(function ($user) { // Loop through the chunk of users
      	$user->roles()->sync([1, 2]); // Sync the users roles to be ONLY 1 & 2 (Sync will remove all other attached roles)
    });
});

// The pivot table is now updated // No need to manually update the pivot table

Popularity 10/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Nov 30 2022

Danny Hardy

0 Answers Avg Quality 2/10

update a pivot table using Eloquent

Contents

More Related Answers

update a pivot table using Eloquent

Closely Related Answers

laravel + update pivot table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.