How to Update Multiple Records in Laravel?

Hi Friends,

This post will give you an example of how to update multiple rows in laravel eloquent. I explained simply about how to update multiple row in laravel. we will help you to give an example of laravel update multiple records by id. you will learn laravel update multiple rows with array.

You can use this example with laravel 6, laravel 7, laravel 8 and laravel 9 versions.

If you want to update multiple rows in laravel eloquent then you can use where() with update(), whereIn() with update() method of eloquent. I added three simple examples to update multiple products in laravel eloquent. so let’s see the one by one example:

Example 1:

<?php

namespace AppHttpControllers;

use IlluminateHttpRequest;

use AppModelsProduct;

class ProductController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

Product::where("type", 1)

->update(["color" => "red"]);

dd("Products updated successfully.");

}

}

Example 2:

<?php

namespace AppHttpControllers;

use IlluminateHttpRequest;

use AppModelsProduct;

class ProductController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$ids = [34, 56, 100, 104];

Product::whereIn("id", $ids)

->update([

'color' => 'blue',

'size' => 'XL',

'price' => 200

]);

dd("Products updated successfully.");

}

}

Example 3:

<?php

namespace AppHttpControllers;

use IlluminateHttpRequest;

use AppModelsProduct;

class ProductController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$ids = [34, 56, 100, 104];

Product::whereIn("id", $ids)

->update($request->all());

dd("Products updated successfully.");

}

}

i hope it can help you…

Leave a Comment