Limited Time Offer!

For Less Than the Cost of a Starbucks Coffee, Access All DevOpsSchool Videos on YouTube Unlimitedly.
Master DevOps, SRE, DevSecOps Skills!

Enroll Now
Laravel

How to Store Countries, States, Cities seed classes into the Database in Laravel PHP? (Part-2)

August 31, 2020 comments off

How to Store Countries, States, Cities seed classes into the Database in Laravel PHP?

Part-1 Part-3

Step 1. Create a State seeder file. Write down the following command as follows:

$  php artisan make:seeder StatesTableSeeder

Step 2. Create a State model. Write down the following command as follows:

$  php artisan make:model State -m

Step 3. Add columns into Country table.

 public function up()
    {
        Schema::create('states', function (Blueprint $table) {
           $table->bigIncrements('state_id');
            $table->string('state_name');
            $table->integer('country_id');
            $table->timestamps();
        });
    }

Step 4. Go to Database/seeds/DatabaseSeeder file. Write down the following command as follows to add State seeder class:

 public function run()
    {
        $this->call(CountriesTableSeeder::class);
        $this->call(StatesTableSeeder::class);
    }

Step 5. Go to Database/seeds/CountriesTableSeeder file.

Step 6. Migrate the tables into the MySQL database.

$ php artisan migrate

Step 7. Run the seeder class file individually.

$  php artisan db:seed --class=StatesTableSeeder

Step 8. Go to app\http\Controllers\MainController.php file. Define funcitions of Country and State.

Step 9. Then, go to routes/web.php file and define all these routes.

Route::get('/getStates/{id}','MainController@getStates');

Thanks

Usha Kiran
Latest posts by Usha Kiran (see all)