DEV Community

Cover image for How to Insert Multiple Records in Laravel
Msh Sayket
Msh Sayket

Posted on

1

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.");

    }

}
Enter fullscreen mode Exit fullscreen mode

I hope it can help you…
You Can learn More Tutorial from Dev Script School

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (0)

Heroku

Simplify your DevOps and maximize your time.

Since 2007, Heroku has been the go-to platform for developers as it monitors uptime, performance, and infrastructure concerns, allowing you to focus on writing code.

Learn More

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay