1. Define the many-to-many relationship between your models using the belongsToMany method.

class User extends Model
{
public function roles()
{
return $this->belongsToMany(Role::class)->withPivot('permission');
}
}

class Role extends Model
{
public function users()
{
return $this->belongsToMany(User::class)->withPivot('permission');
}
}

2. To store data in the pivot table, you can attach the related models using the attach method, passing an array of additional data as the second argument.

$user = User::find(1);
$role = Role::find(2);

$user->roles()->attach($role, ['permission' => 'read']);

3. You can also update the data in the pivot table using the updateExistingPivot method.

$user = User::find(1);
$role = Role::find(2);
$user->roles()->updateExistingPivot($role->id, ['permission' => 'write']);

4. You can retrieve the data stored in the pivot table using the pivot attribute.

$user = User::find(1);
foreach ($user->roles as $role) {
echo $role->pivot->permission;
}

Note: In the example above, we added withPivot method in both belongsToMany relationships to allow us to access the permission field in the pivot table.

The post How to Store Data in Pivot Table in Laravel? appeared first on TechGropse.