Laravel Update Multiple Records with Example

Oct 17, 2022 . Admin



Hello Friends,

Now, let's see the article on laravel updates multiple records with an example. This post will give you a simple example of how to update multiple rows in laravel. it's a simple example of laravel updating multiple rows with an array. This post will give you a simple example of how to update multiple data in laravel. Here, Creating a basic example of how to update multiple data in laravel.

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

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 App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Product;
  
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 App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Product;
  
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 App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Product;
  
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...

#Laravel