Laravel update array syntax

Question

I'm having trouble doing a record update array via POST in Laravel. I have captured all the post data in an array cant update array achievement

<form action="{{'updateapp'}}" method="post">
<table>
<tr><td>
<input type="checkbox" class="id" name="id[]" value="{{ $quarter->id }}" />
<input type="text" name="achv[]" value="{{ $quarter->achievement }}">
</td></tr>
</table>
</form>

Controller :

public function foo(Request $request)
{
    $ids = $request->id;
    $achvs = $request->achv;
    DB::table('quarters')->whereIn('id', $ids)
    ->update(array(['achievement' => $achvs ]));   

    return redirect('evaluator');      
  }

Rajinder · Accepted Answer · 2017-08-28 07:44:54Z

8

As you have set [] array in your form, you can access it as following

public function foo(Request $request)
{
    $ids = $request->id[0];
    $achvs = $request->achv[0];
    DB::table('quarters')->where('id', $ids)
    ->update(['achievement' => $achvs ]);   

    return redirect('evaluator');      
  }

if you want to update multiple rows then use following code:

foreach($request->id as $key => $value){ 

      $quarters = Quarters::find($request->id[$key]); 
      $quarters->achievement = $request->achv[$key]; 
      $quarters->save(); 
}

edited Aug 28, 2017 at 7:44

answered Aug 28, 2017 at 6:42

Rajinder

1,0911 gold badge17 silver badges30 bronze badges

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

3 Comments

Yandra Adie Over a year ago

FatalThrowableError in Grammar.php line 118: Type error: Argument 1 passed to Illuminate\Database\Grammar::parameterize() must be of the type array, string given, called in C:\xampp\htdocs\sofia-project\vendor\laravel\framework\src\Illuminate\Database\Query\Grammars\Grammar.php on line 376

Rajinder Over a year ago

your question little confusing now. please explain in detail what do you want exactly.

Rajinder Over a year ago

I understood properly, I have update my answer. please check above code

Azxster · Accepted Answer · 2019-06-27 10:40:42Z

0

public function foo(Request $request)
{
    $ids = $request->id[0];
    $achvs = $request->achv[0];
    DB::table('quarters')->where('id', $ids)
    ->update(array(['achievement' => $achvs,'achievement1' => $achvs1]));
    return redirect('evaluator');      
  }

edited Jun 27, 2019 at 10:40

answered Jun 25, 2019 at 13:52

Azxster

768 bronze badges

1 Comment

creyD Over a year ago

While all answers are appreciated, it is very good to have some detail and explanation in your answer, so that people with similar problems can understand it too.

Collectives™ on Stack Overflow

Laravel update array syntax

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related