Laravel透视表-保存来自其他列的数据

Question

我正在尝试保存数据透视表中多列的数据。但是，数据没有保存。下面是我正在做的事情：

表

Schema::create('benefit_user', function (Blueprint $table) {
    $table->integer('benefit_id');
    $table->integer('user_id');
    $table->integer('amount1')->default(0);
    $table->integer('amount2')->default(0);
    $table->timestamps();
});

刀片

@foreach($benefits as $benefit)
 <tr>
     <td>
        <input class="form-check-input" type="checkbox" value="{{ $benefit->id }}" name="benefitId[]" id="flexCheckChecked"
        @foreach($user->benefits as $benefitId)
            {{ $benefitId->id === $benefit->id ? 'checked' : '' }}
         @endforeach
         >
      </td>
      <td>
          {{ $benefit->name }}
       </td>
       <td>
           <input type="text" class="form-control" name="amount1[]"
                @foreach($user->benefits as $e_pay)
                    value="{{ $benefitId->id === $benefit->id ? $benefitId->amount1 : '' }}"
                @endforeach
            >
        </td>
        <td>
            <input type="text" class="form-control" name="amount2[]"
                @foreach($user->benefits as $er_pay)
                     value="{{ $benefitId->id === $benefit->id ? $benefitId->amount2 : '' }}"
                @endforeach
            >
        </td>
     </tr>
@endforeach

如果我只使用checkbox来同步benefit_id和user_id，它就能工作。但如果添加额外的数据amount1和amount2，则不起作用。

控制器

$user->benefits()->sync([$request->benefitId => ['amount1' => $request->amount1, 'amount2' => $request->amount2]]);

事先谢谢你的帮助。

Answer 1

在将数据插入到povit表（如belwo）时，必须使用attach not sync

$user->benefits()->attach([$request->benefitId => ['amount1' => $request->amount1, 'amount2' => $request->amount2]]);