laravel update database multiple records

Question

I am new to Laravel. I'm simply trying to update a full row of mysql table. Data are being sent from a form. I only get to have only 2 records updated and the rest go NULL. I am sure that the fields names from Controller are matching input fields names in the form, also in the mysql table. I also made sure that fields listed in "fillable" method in the model.

In the controller tried:

public function approve($id, Request $request)
{
    $name = $request->input('name');
    $mark = $request->input('mark');
    $email = $request->input('email');
    $dob = date('Y-m-d H:i:s', strtotime($request->input('dob')));
    $country = $request->input('country');
     
    Certificate::where('id', '=', $id)
        ->update([
            'mark' => $mark,
            'name' => $name, 
            'dob' => $dob,
            'country' => $country
        ]);
}

I also tried

$query = DB::update("UPDATE certificates SET name='$name', mark='$mark', dob='$dob', country='$country' WHERE id='$id'");

Plz let me know what I might be doing wrong. Thank you

are you sure, you receive all fields from form, and you don't have validation? — Vasyl Zhuryk
– Vasyl Zhuryk, Commented Dec 15, 2020 at 23:33
you are updating with where clause. You will update just the records that satisfy the where clause. — Giacomo M
– Giacomo M, Commented Dec 15, 2020 at 23:35
yes that what im trying to do, but on row id = 2 i dont get to have all records updated on that row — user2305672
– user2305672, Commented Dec 15, 2020 at 23:37

KINGSLEY OKPARA · Accepted Answer · 2020-12-15 23:55:00Z

3

use DB facade, I was having an error similar to this, so this is what I used

use Illuminate\Support\Facades\DB;


 DB::table('certificates')
    ->where('id', $id)
    ->update([
    'mark' => $request->mark,
    'name' => $request->name, 
    'email' => $request->email,
    'dob' => $request->dob,
    'country' => $request->country
]);

answered Dec 15, 2020 at 23:55

KINGSLEY OKPARA

5591 gold badge8 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

laravel update database multiple records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related