update existing pivot table data in laravel

You can update existing pivot table column values in laravel using updateExistingPivot relationship method in laravel.

Answers 1
  • Update existing pivot table column value in laravel 8

    //Inside Controller's method 
    $user = App\Models\User::find(1);
    $roleId = 1;
    $attributes = ['order_by' => 2];
    $user->roles()->updateExistingPivot($roleId, $attributes);
    
    0

    It will update the column value of the existing record of pivot table in laravel 8. You can pass multiple column values per your requirement in the attributes array. updateExistingPivot method will update the user which has role id 1 with pivot column order_by by value of 2.

  • Back to code snippet queries related laravel