How to Insert Multiple Records in Laravel

In this tutorial, we will learn How to Insert Multiple Records in Laravel. 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. You Can Learn How to Download File in Laravel Livewire 3

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.

How to Insert Multiple Records in Laravel 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…
You Can learn More Tutorial from Dev Script School