How to update multiple field?

• Stop using laravel
• Take this course https://laracasts.com/series/php-for-beginners
• and https://laracasts.com/series/laravel-from-scratch-2017
• Come back to laravel

Sorry, I didn't get your doubt, are you trying to create a multiple save and your pivot table is becoming empty? or are you having problems in routes?

Ps: your dropbox link is not working

@joaomantovani @jlrdw my problem is that yes i inserted all data (6 rows) but what is the route should be to get the edit form(like get('/acadmic/marks['1','2','3'...utpto '6']/update_form/) and same as post route ) because all value inserted at once

https://www.dropbox.com/s/rgd5748ap6tqavl/1.PNG?dl=0

Maybe

Route

Route::post('/acadmic/marks/{id}/update_form', yourcontroller@update);

Controller

 public function update($id, $reg_no = null,Request $request)
    {

        $s = Student::where('reg_no',$reg_no)->with('courses','courses.psubjects')->first();    
        $course_id = $s->courses->id;
        $datetime = Carbon::now();

        foreach ($request->subject as $key => $v)
         {       
            $data = [
                 
                 'course_id'  => $course_id,
                 'subject_id' => $v,
                 'test_marks' => $request->test_marks [$key],
                 'mid_marks'  => $request->mid_marks [$key],
                 'end_marks'  => $request->end_marks [$key],
                 'student_id' => $s->id,
                 'updated_at' => $datetime,
                 'created_at' => $datetime

                ];
          
                Mark::find($id)->update($data);
        }

        return back();
    }

@joaomantovani this will only accept single "id" so if i will followed this will not return value of other what about [1,2,3,4,5] (which inserted at once)

You can do 5 other requests or pass an array of ids

Mark::find($id[key])->update($data);

Think about the structure of your data.

If all the marks are associated with one course, then the route could be

/student/{student}/course/{course_id}/marks

or if the course_id is already unique to the student, then just

/course/{course_id}/marks

Then in the controller, get all marks related to the course and iterate over them in the form.

@Snapey that make sense I'll try

@Snapey @joaomantovani

action="/acadmic/{{id}}/{{$s->reg_no}}/marks_edit"

here what should i give {{ $s->marks['id'] }} not works

give where?

@Snapey

<form method="post" action="/acadmic/{{$s->marks['id']}}/{{$s->reg_no}}/marks_edit" data-parsley-validate ="">
        {{ csrf_field() }} {{ method_field('PATCH') }}
      <table class="table table-bordered  table-hover">
        <thead>
            <tr>
                <th  style="text-align: center;">Subject</th>
                <th  style="text-align: center;">Test Marks</th>
                <th  style="text-align: center;">Mid Marks</th>
                <th  style="text-align: center;">End Marks</th>
            </tr>
        </thead>
        @foreach($marks as $mark)
        <tbody>
            <tr>            
                <td class="col-md-3" >                      
                     <div class="form-group" >       
                      <select  class="form-control" id="subject[]"  name="subject[]" required="">
                      <option value="{{ $mark->subjects['id']}}">{{ $mark->subjects['name'] }}</option>
                      </select>
                     </div>                
                </td>                   
                <td class="col-md-3">                   
                    <div class="form-group">              
                     <input type="text" class="form-control"  id="test_marks[]"  name="test_marks[]" data-parsley-type="number" value="{{ $mark->test_marks }}" data-parsley-range="[0, 25]">
                    </div>                
                </td>
                <td class="col-md-3">                   
                    <div class="form-group">             
                    <input type="text" class="form-control" id="mid_marks" name="mid_marks[]" data-parsley-type="number" value="{{ $mark->mid_marks }}" data-parsley-range="[0, 50]">
                   </div>              
                </td>
                <td class="col-md-3">                   
                     <div class="form-group">             
                     <input type="text" class="form-control" id="end_marks" name="end_marks[]" value="{{ $mark->end_marks }}"  data-parsley-type="number"  data-parsley-range="[0, 100]">
                     </div>               
                </td>
            </tr>
        </tbody>
        @endforeach
      </table>
                   
     <div class="col-md-4 col-md-offset-4">
     <br>
        <button type="submit" class="btn btn-primary btn-lg btn-block">Submit</button>
     </div>     
    </form>

i got errors as expected

Undefined index: id (View: 

How could I possibly answer without knowing what $s contains?

@Snapey actually $s has Student , and Student have marks

my get_edit_form controller

public function geteditmarkForm($reg_no = null, $course_id=null)
    {
        $s = Student::where('reg_no',$reg_no)->with('courses','courses.psubjects')->first();


        $marks =  Mark::with('subjects')->where('course_id', $course_id)
                ->whereHas('students',function($query) use($reg_no){ 

                 $query->where('reg_no', $reg_no);

                })->get();

        return view('marks_sheet.marks_sheet_edit_form',compact('s','marks'));
    }

and my Student Model

public function marks()
    {
        return $this->hasMany(Mark::class);
    }

and my Mark Model

public function courses()
    {
        return $this->belongsTo(Course::Class,'course_id');
    }

    public function subjects()
    {
        return $this->belongsTo(Subject::Class,'subject_id');
    } 

    public function students()
    {
        return $this->belongsTo(Student::Class,'student_id');
    }

You want to save the marks you have already?

And you want to edit the marks for a specific course in one go?

Or all the marks for one student?

action="/student/{{$s->id}}/course/{{ $s->course->id}}/marks_edit"

@Snapey yes already saved but how can update (what is post controller) as @joaomantovani said i can pass in a array

Mark::find($id[key])->update($data);

so how can i find and update and i want "want to edit the marks for a specific course(of student and student next year have different course) in one go"

??

What's wrong with what I suggested?

https://laracasts.com/discuss/channels/laravel/how-to-update-multiple-field

Very unpatient and has no idea how to code. Your posts are a mystery. Learn how to use Laravel, how to write a question and keep in mind that's not our payed job.

@Snapey

action="/acadmic/{{$s->reg_no}}/{{$s->course_id}}/marks_edit"

and controller

 public function updateeditmarkForm($reg_no=null, $course_id = null, Request $request)
    {

        $s = Student::where('reg_no',$reg_no)->with('courses','courses.psubjects')->first();

        $marks = Mark::with('subjects')->where('course_id', $course_id)
                ->whereHas('students',function($query) use($reg_no){ 

                 $query->where('reg_no', $reg_no);

                })->get();    
        $course_id = $s->courses->id;
        $datetime = Carbon::now();
        foreach ($request->subject as $key => $v)
         {       
            $data = [
                 
                 'course_id'  => $course_id,
                 'subject_id' => $v,
                 'test_marks' => $request->test_marks [$key],
                 'mid_marks'  => $request->mid_marks [$key],
                 'end_marks'  => $request->end_marks [$key],
                 'student_id' => $s->id,
                 'updated_at' => $datetime
                 

                ];
            //dd($data);
                $marks->update($data);
        }

        return back();
    }

errrosrs as expected

Method update does not exist.

and @fabricecw sorry for that

ppp!!!

method update does not exist

public function updateeditmarkForm(

notice anything different here?

u mean i have to use

($id, $course_id, Request $request)

push

did you figure this out vipin?

btw what Snapey had said which is obvious is that

Your route is pointing to the Update Method where you instead have updateeditmarkForm so, you'd have to change your route to ControllerName@updateeditmarkForm