Laravel 9 Insert Multiple Records In Database

Websolutionstuff | Dec-16-2022 | Categories : Laravel MySQL

In this article, we will see laravel 9 insert multiple records in the database. Here, we will learn how to insert multiple records in the database in laravel 8 and laravel 9.

In laravel, you can insert multiple records into the database using model and laravel query builder. We will give you an example of using the model and laravel DB query.

So, let's see laravel multiple data insert into a database, insert data in the database in laravel 7/8/9.

Example:

In this example, we will create a multidimensional array and insert multiple records using the insert() function.

$createMultipleUsers = [
    ['name'=>'Admin','email'=>'[email protected]', 'password' => bcrypt('admin@123')],
    ['name'=>'Guest','email'=>'[email protected]', 'password' => bcrypt('Guest@123')],
    ['name'=>'Super-Admin','email'=>'[email protected]', 'password' => bcrypt('Sup-Admin@123')]
];

User::insert($createMultipleUsers); // Here we use Laravel Eloquent to insert multiple records
\DB::table('users')->insert($createMultipleUsers); // Here we are use Query Builder to insert multiple records

 

Example: Insert Multiple Records into the Database in Laravel 9 using Seeder

In this example, we will create a laravel seeder to create a dummy record and insert multiple records in laravel 9. So, follow the below steps and create a seeder.

Step 1: Create Laravel Seeder

In this step, we will create a laravel seeder using the following command.

php artisan make:seeder UserSeeder

 

Step 2: Edit UserSeeder

Now, we will edit the UserSeeder.php file. So, add the following code to that file.

database/seeders/UserSeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Faker\Generator as Faker;
use App\Models\User;

class UserSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $faker = Faker::create();

        foreach (range(1,25) as $index) {
            User::create([
                'name' => $faker->name,
                'email' => $faker->email,
                'job_description' => $faker->text,
                'company' => $faker->company
            ]);
        }
    }
}

 

Step 3: Run Seeder

In this step, we will run the laravel seeder using the following command.

php artisan db:seed --class=UserSeeder

 


You might also like:

Recommended Post
Featured Post
How To Create Unique Slug In Laravel 9
How To Create Unique Slug In L...

In this article, we will see how to create a unique slug in laravel 9. A slug is the part of a URL that i...

Read More

Sep-27-2022

Laravel 8 Ajax CRUD With Yajra Datatable
Laravel 8 Ajax CRUD With Yajra...

In this tutorial, we will see laravel 8 ajax crud with yajra datatable. I will show you how to create ajax crud ope...

Read More

Jan-05-2022

Laravel 11 ChartJS Line Chart Example
Laravel 11 ChartJS Line Chart...

Hello developer! In this article, we'll see how to create a dynamic line chart in laravel 11 using chart js. Yo...

Read More

May-10-2024

Laravel 11 CKEditor Image Upload Example
Laravel 11 CKEditor Image Uplo...

Hello, laravel web developers! In this article, we'll see how to image upload in CKeditor 5 in laravel 11....

Read More

May-20-2024