How to Insert Multiple Records in Laravel?

Hey Artisan,

In this comprehensive tutorial, we will learn laravel eloquent insert multiple rows. you can see laravel eloquent bulk insert. This example will help you laravel insert multiple records eloquent. In this article, we will implement a laravel eloquent insert multiple rows.

If we work on big project and then we maybe require to add multiple rows on database using laravel eloquent. Laravel provide insert method for bulk records create on db.

In bellow example you can see i use multidimensional $myItems array variable and that insert multiple records same time using DB::insert(). So let's see and try this.

Example:

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use DB;
  
class ItemController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {
        $myItems = [
            ['title'=>'HD Topi','description'=>'It solution stuff'],
            ['title'=>'HD Topi 2','description'=>'It solution stuff 2'],
            ['title'=>'HD Topi 3','description'=>'It solution stuff 3']
        ];
          
        DB::table("items")->insert($myItems);
  
        dd("Added multiple items to database.");
    }
}

I hope it can help you...