Update fields using foreach in Laravel PHP

Question

I'm trying to update multiple rows based on its unique field taskCode

and will update the field of taskWeight from tbl_projtask

I have this 2 variable

$request->dataWeight This variable is coming from ajax request that contains something like this 95,75,65 a value that is separated by commas.
$request->dataWeightAttr This variable is coming from ajax request that contains something like this TaskCode1, TaskCode2, TaskCode3

In my MainController.php

I have this code

    $myString = $request->dataWeightAttr;
        foreach($myString as $value){
            DB::table('tbl_projtask')
            ->where('taskCode', $value)
            ->update([
            'taskWeight'=> $request->dataWeight,
            'by_id'=> auth()->user()->id,
            'updated_by'=> auth()->user()->name,
            'updated_at' => now()
            ]);
        }

As you can see in my update code

I used request->dataWeightAttr to find which rows should be updated and $request->dataWeight the value for specific taskCode

Am I doing this right?

yes I want to update taskWeight where taskCode is given from the $request->dataWeightAttr — King RG
– King RG, Commented Nov 5, 2019 at 7:27

Yasin Patel · Accepted Answer · 2019-11-05 07:29:50Z

1

Convert your string to an Array

$dataWeight = explode(',',$request->dataWeight); // convert to array
$dataWeightAttr = explode(',',$request->dataWeightAttr); // convert to array

Assuming you have related values in both array.

foreach($dataWeightAttr as $key => $value){
    DB::table('tbl_projtask')
    ->where('taskCode', $value)
    ->update([
    'taskWeight'=> $dataWeight[$key],
    'by_id'=> auth()->user()->id,
    'updated_by'=> auth()->user()->name,
    'updated_at' => now()
    ]);
}

answered Nov 5, 2019 at 7:29

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

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

Comments

Poldo · Accepted Answer · 2019-11-05 07:22:00Z

1

You can use whereIn instead of foreach if you want to update same fields but different id.

 DB::table('tbl_projtask')
  ->whereIn('taskCode', $request->dataWeightAttr)
  ->update([
     'taskWeight'=> $request->dataWeight,
     'by_id'=> auth()->user()->id,
     'updated_by'=> auth()->user()->name,
     'updated_at' => now()
 ]);

answered Nov 5, 2019 at 7:22

Poldo

1,9321 gold badge15 silver badges27 bronze badges

Collectives™ on Stack Overflow

Update fields using foreach in Laravel PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related