ItSolutionStuff.com

How to Create Seeder with JSON data in Laravel?

By Hardik Savani • April 16, 2024
Laravel

Hi,

In this short tutorial we will cover an laravel seed from json file example. i explained simply about how to create seeder with json file in laravel. if you have question about laravel seeder from json file then i will give simple example with solution. we will help you to give example of laravel seeder json.

Sometime we need to read long json file and store that data in you database and we need to do maybe in every setup then we always choose seeder for that. so here i will give you very simple example of how to create seeder with json data in laravel and you can use this example with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 version.

Step 1: Create Json File

in first step we will create country json file with name and code. so you can create data folder inside database folder and put that file as bellow preview:

database/data/country.json

Step 2: Create Seeder and Country Model

here, we will create migration for countries table. so let's create migration as bellow:

php artisan make:migration create_countries_table

database/migrations/your_migtion_file.php

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateCountriesTable extends Migration

{

/**

* Run the migrations.

*

* @return void

*/

public function up()

{

Schema::create('countries', function (Blueprint $table) {

$table->id();

$table->string('name');

$table->string('code');

$table->timestamps();

});

}

/**

* Reverse the migrations.

*

* @return void

*/

public function down()

{

Schema::dropIfExists('countries');

}

}

now let's run migration:

php artisan migrate

next, add soft delete facade in user model as like bellow:

app/Models/County.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Country extends Model

{

use HasFactory;

protected $fillable = [

'name', 'code'

];

}

Step 3: Create Seeder

In this step, we need to create add seeder for country lists.

Create Seeder with bellow command

php artisan make:seeder CountrySeeder

database/seeders/CountrySeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;

use App\Models\Country;

use File;

class CountrySeeder extends Seeder

{

/**

* Run the database seeds.

*

* @return void

*/

public function run()

{

Country::truncate();

$json = File::get("database/data/country.json");

$countries = json_decode($json);

foreach ($countries as $key => $value) {

Country::create([

"name" => $value->name,

"code" => $value->code

]);

}

}

}

now let's run seeder:

php artisan db:seed --class=CountrySeeder

now you can see bellow added country lists on your table:

I hope it can help you.

Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

How to Add Country List in Laravel?

Read Now →

How to Change Column Length using Laravel Migration?

Read Now →

How to Update Enum Value in Laravel Migration?

Read Now →

Laravel Migration Enum Default Value Example

Read Now →

Laravel Migration Add Enum Column Example

Read Now →

Laravel 8 Model Observers Tutorial Example

Read Now →

Laravel Import Large SQL File using Seeder Example

Read Now →

Laravel 8 Livewire CRUD with Jetstream & Tailwind CSS

Read Now →

Laravel 8 PDF | Laravel 8 Generate PDF File using DomPDF

Read Now →

Laravel 8 Database Seeder Tutorial Example

Read Now →

How to create database seeder in Laravel 5.7?

Read Now →