Laravel update table

Question

I'm trying to do simple function edit student table field, But its updating only first field: first_name

My controller.

    public function editStudent(Request $request)
{
    $studId = $request->get('studId');
    $studFirstName = $request->get('firstName');
    $studLastName = $request->get('lastName');
    $studGender = $request->get('gender');
    $studBirthday = $request->get('birthday'); 
    $studSchoolId = $request->get('schoolId'); 
    $update = Student::where('id', $studId)->update(['first_name' => $studFirstName],
    ['last_name' => $studLastName], ['gender' => $studGender], ['birthday', $studBirthday], ['school_id' => $studSchoolId]); 
    return response()->json([
        "update" => $update,
    ]);
}

aynber · Accepted Answer · 2021-10-08 13:28:29Z

3

Update takes a single array, you're passing in multiple arrays

$update = Student::where('id', $studId)
    ->update([
        'first_name' => $studFirstName,
        'last_name' => $studLastName, 
        'gender' => $studGender, 
        'birthday'=> $studBirthday, 
        'school_id' => $studSchoolId
    ]);

edited Oct 8, 2021 at 13:28

answered Oct 8, 2021 at 13:26

aynber

23.2k9 gold badges57 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Irakli Ardia Over a year ago

I tried that but it's errors SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list'

aynber Over a year ago

Ah, there's an extra comma instead of an arrow between birthday and studBirthday. I've edited my answer to fix hat

Kamyar · Accepted Answer · 2021-10-08 15:31:31Z

0

Its better to get the item from DB then update that on a second query:

$student = Student::find($studId);

$student->update([
    'first_name' => $request->firstName,
    'last_name' => $request->lastName, 
    'gender' => $request->gender, 
    'birthday'=> $request->birthday, 
    'school_id' => $request->schoolId
]);

answered Oct 8, 2021 at 15:31

Kamyar

214 bronze badges

Collectives™ on Stack Overflow

Laravel update table

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related