PHP

how to make db seeder in laravel

php artisan make:seeder UsersTableSeeder

insert data in database using seeder in laravel

step-1- php artisan make:seeder yourSeedername
step-2- //add data in inside run function in your new created seeder. eg
        $Records = [
            ['id'=>1, 'name'=>'abc','email'=>'abc@gmail.com'],
            ['id'=>2, 'name'=>'xyz','email'=>'xyz@gmail.com']
        ];
        YourModel::insert($Records);
        //don't forget to use model in top of your seeder
step-3- //register seeder in run function inside Database/Seeders/DatabaseSeers.php as follows
        $this->call(yourseeder::class);
step-4- //Now run following command
        php artisan db:seed

laravel seeder

#To create a seeder
php artisan make:seeder CategorySeeder

insert data using seeder in laravel

use IlluminateSupportFacadesDB;
use IlluminateSupportFacadesHash;
...
...
DB::table('users')->insert([
    'name' => 'John Doe',
    'email' => 'john@doe.com',
    'password' => Hash::make('password')
]);

how to use seeders in laravel

$ php artisan make:seeder MoviesTableSeeder

laravel database seeder

<?php

use IlluminateDatabaseSeeder;
use IlluminateSupportFacadesDB;
use IlluminateSupportFacadesHash;
use IlluminateSupportStr;

class DatabaseSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('users')->insert([
            'name' => Str::random(10),
            'email' => Str::random(10).'@gmail.com',
            'password' => Hash::make('password'),
        ]);
    }
}

database seeder laravel

// in DatabaseSeeder.php file
$this->call([
            UserSeeder::class,
]);

Laravel run seed table

$ php artisan db:seed

laravel database seeder

namespace DatabaseSeeders;

use AppModelsCategory;
use AppModelsPost;
use AppModelsUser;
use IlluminateDatabaseSeeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Seed the application's database.
     *
     * @return void
     */
    public function run()
    {
        $users = User::factory(2)->create();
        $categories = Category::factory(3)->create();
        Post::factory(3)->create([
            'user_id' => $users[0]->id,
            'category_id' => $categories[0]->id
        ]);
 
        Post::factory(3)->create([
            'user_id' => $users[1]->id,
            'category_id' => $categories[2]->id
        ]);

    }
}

save many records with seeder in laravel 8

$insertMany = Pricing::create(['name'=>request('name')]);
$insertMany->available()->createMany([
      ['service_id'=>1],
      ['service_id'=>2],
      ['service_id'=>3],
      ['service_id'=>4],
      ['service_id'=>5],
]);

create seed file from db laravel

composer require orangehill/iseed
  php artisan iseed my_table