Edit Data using Array but the result is the same in Laravel

Question

I want to edit data using an array, but when I submit the edits, the results are all the same from below.

When editing each student name, it has a different value, but when submitting, the results are all the same, like this in MySQL and the Web:

Code:

Controller

public function UpdateEditGradeStudent(Request $request){
    $data = GradeDetail::find($request->id_grade_detail);

    foreach($request->id_grade as $index => $value) {
        DB::table('grade_details')
            ->update(array(
                'id_grade' => $value,
                'quiz' => $request->quiz[$index],
                'assignment' => $request->assignment[$index],
                'min_text' => $request->min_text[$index],
                'd_t' => $request->d_t[$index],
                'final_text' => $request->final_text[$index],
                'total' => $request->total[$index],
            ));
        
    }

    return redirect('/');
}

Blade

<form method="POST" action="{{route('edit.teacher.grade')}}" enctype="multipart/form-data">
                @csrf
{{--                <input type="hidden" name="id_grade[]" value="{{ $userGrades->id_grade }}">--}}
                <div class="flex">
                    <input type="submit" class="focus:outline-none text-white bg-[#464867] hover:bg-[#464867] font-medium rounded-lg text-sm px-5 py-2.5 mb-2 mt-3 mr-4" type="button" value="Save">
                    <a href="{{url('teacher/data-grade')}}" class="focus:outline-none text-white bg-[#464867] hover:bg-[#464867] font-medium rounded-lg text-sm px-5 py-2.5 mb-2 mt-3" type="button" >Cancel</a>
                </div>

                <table class="w-full text-sm text-left text-gray-500 dark:text-gray-400">
                    <tbody>
                    @php $no = 1; @endphp
                    @forelse($subject as $data)
                        <input
                            type="hidden"
                            name="id_grade[]"
                            value="{{$data->id_grade}}"
                        >

                        <tr class="bg-white border-b dark:bg-gray-900 dark:border-gray-700">
                            <th scope="row" class="py-4 px-6 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                                {{$no++}}
                            </th>
                            <th scope="row" class="py-4 px-6 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                                {{$data->username}}
                            </th>
                            <th scope="row" class="py-4 px-6 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                                {{$data->name}}
                            </th>
                            <th scope="row" class="py-4 px-6 font-medium text-red-700 whitespace-nowrap dark:text-white">
                                {{$data->min_score}}
                            </th>
                            <th scope="row" class="py-4 px-6 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                                <input
                                    type="number"
                                    min="0"
                                    max="100"
                                    name="quiz[]"
                                    id="quiz"
                                    value="{{$data->quiz}}"
                                    autocomplete="quiz"
                                    class="bg-gray-50 border border-gray-300 text-gray-900 text-sm rounded-lg focus:ring-blue-500 focus:border-blue-500 block w-full p-2.5 dark:bg-gray-600 dark:border-gray-500 dark:placeholder-gray-400 dark:text-white"
                                    required
                                >
                            </th>
                            <th scope="row" class="py-4 px-6 font-medium text-gray-900 whitespace-nowrap dark:text-white">
                                <input
                                    type="number"
                                    min="0"
                                    max="100"
                                    name="assignment[]"
                                    id="assignment"
                                    value="{{$data->assignment}}"
                                    autocomplete="min_score"
                                    class="bg-gray-50 border border-gray-300 text-gray-900 text-sm rounded-lg focus:ring-blue-500 focus:border-blue-500 block w-full p-2.5 dark:bg-gray-600 dark:border-gray-500 dark:placeholder-gray-400 dark:text-white"
                                    required
                                >
                            </th>

I didn't screenshot all the blade coding.

How to edit data array according to the data we have edited data.

Answer 1

Looks like your key is id_grade_detail, you should filter by that field:

@forelse($subject as $data)
    <input
        type="hidden"
        name="id_grade_detail[]"
        value="{{$data->id_grade_detail}}"
    >
    <input
        type="hidden"
        name="id_grade[]"
        value="{{$data->id_grade}}"
    >
    ...

And on the server:

public function UpdateEditGradeStudent(Request $request)
{
    foreach($request->id_grade_detail as $index => $value) {
        $grade_detail = GradeDetail::find($value);
        if ($grade_detail) {
            $grade_detail->quiz = $request->quiz[$index];
            $grade_detail->assignment = $request->assignment[$index];
            $grade_detail->min_text = $request->min_text[$index];
            $grade_detail->d_t = $request->quiz[$index];
            $grade_detail->final_text = $request->final_text[$index];
            $grade_detail->total = $request->total[$index];
            
            $grade_detail->save();
        }
    }

    return redirect('/');
}