jeudi 7 septembre 2017

Need to update multiple records at once using Laravel Eloquent

I just need to update multiple rows at time.

Am able to insert multiple rows at a time, like the code below,

foreach ($request->something as $key => $value) {
    $data=array(
        'db_table_field0'=> $request->form_something[$key],
        'db_table_field1'=>$request->form_something2[$key],
        'db_table_field2'=>$request->form_something3[$key],
        'db_table_field3'=>$request->form_something4[$key],
        );
        tableModel::insert($data);
 }

data is inserting, I tried same for update like,

foreach ($request->something as $key => $value) {
    $auc_det_id = tableModel::where('value', $request->value[$key])->get();

    $data=array(
        'db_table_field0'=> $request->form_something[$key],
        'db_table_field1'=>$request->form_something2[$key],
        'db_table_field2'=>$request->form_something3[$key],
        'db_table_field3'=>$request->form_something4[$key],
        );
        $auc_update->update($data);
 }

It's not updating, some error like method update not found.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire