Laravel7-將多個資料插入到mysql資料庫中沒有映射資料

我正在將多個資料插入 mysql 資料庫，顯然一切正常，但是當我在 phpmyadmin 中檢查資料時，似乎只有第一個選中復選框的第一個值被多次插入，這意味著只有第一個 id_student 是值被多次插入。我認為這是一個映射問題，但我不知道如何解決它，有人可以幫助我嗎？

• 這是我的看法

@foreach ($group->students as $student)
         @if($student->pivot->pass)
         <tr>
            <td class="align-middle text-center">
                <input class="form-control" type="text" name="name" value="{{$student->last_name}} {{$student->Names}}" disabled>
            </td>

            <td class="align-middle text-center">
                <input class="form-control form-control-sm" type="text" name="grade" value="{{isset($student->pivot->grade)?$student->pivot->grade:''}}" placeholder="Grade" disabled>
            </td>

            <form action="{{url('/Create/Records/')}}" method="POST">
             {{csrf_field()}}

                  <input class="form-control form-control-sm" type="hidden" name="id_student" value="{{$student->id_student}}" >

                  <td class="align-middle text-center">
                      <input id="select" type="checkbox" name="select[]">
                  </td>
        </tr>
        @endif
@endforeach

• 這是我在 Controller 中的功能。

     public function create(Request $request)
        {
            try { 
                
                $id_student = $request->get('id_student');
                   
                $consecutive = DB::select('SELECT SUM(idRecord) FROM records GROUP BY idRecord'); 
                $final_consecutive = sprintf("d", $consecutive); 
                foreach($request->select as $data)
                {
                    Records::create(['id_student' => $id_student, 'consecutive' => $final_consecutive]);
                }
    
                return back()->with('success', 'Constancia creada correctamente');
            } catch (\Illuminate\Database\QueryException $e) {
                $message = $e->getMessage();
                if (strpos($message, "Duplicate entry")) {
                    return back()->with('err', 'Esta constancia ya ha sido creada');
                }
                if (strpos($message, "1366 Incorrect integer value: '' for column 'idGrupo'")) {
                    return back()->with('err', 'Debe seleccionar un grupo para poder continuar');
                }
                return back()->with('err', $message);
            }
        }

• “記錄”表的影像

uj5u.com熱心網友回復：

您有一個表格，$group->students這意味著一次只能插入一個。您最終插入許多相同的事實只是有問題。如果您真的想一次插入多條記錄，則需要將您的記錄包裝@foreach在表單中：

<form action="{{url('/Create/Records/')}}" method="POST">
{{csrf_field()}}
@foreach ($group->students as $student)
    @if($student->pivot->pass)
         <tr>
            <td class="align-middle text-center">
                <input class="form-control" type="text" name="name[]" value="{{$student->last_name}} {{$student->Names}}" disabled>
            </td>

            <td class="align-middle text-center">
                <input class="form-control form-control-sm" type="text" name="grade[]" value="{{isset($student->pivot->grade)?$student->pivot->grade:''}}" placeholder="Grade" disabled>
            </td>



            <input class="form-control form-control-sm" type="hidden" name="id_student[]" value="{{$student->id_student}}" >

            <td class="align-middle text-center">
                <input id="select" type="checkbox" name="select[]">
            </td>
        </tr>
    @endif
@endforeach
</form>

然后你可以迭代 id_student：

    public function create(Request $request)
        {
            try { 
                foreach ($request->get('id_student') as $index => $id_student) {
                    $consecutive = DB::select('SELECT SUM(idRecord) FROM records GROUP BY idRecord'); 
                    $final_consecutive = sprintf("d", $consecutive); 
                    Records::create(['id_student' => $id_student, 'consecutive' => $final_consecutive]);
               }
              
                return back()->with('success', 'Constancia creada correctamente');
            } catch (\Illuminate\Database\QueryException $e) {
                // ....
            }
        }

旁注：如果您實際上不打算使用它們，我不確定您為什么要添加name,grade和表單。select

標籤：php mysql 拉拉维尔 形式 复选框

上一篇：創建具有多個描述的可訪問復選框組

下一篇：在另一個選項中顯示輸入欄位值更改輸入值時選擇選項值