{"id":17720,"date":"2020-08-31T05:58:55","date_gmt":"2020-08-31T05:58:55","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=17720"},"modified":"2021-10-29T07:07:22","modified_gmt":"2021-10-29T07:07:22","slug":"how-to-store-countries-states-cities-seed-classes-into-the-database-in-laravel-php-part-2","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-store-countries-states-cities-seed-classes-into-the-database-in-laravel-php-part-2\/","title":{"rendered":"How to Store Countries, States, Cities seed classes into the Database in Laravel PHP? (Part-2)"},"content":{"rendered":"\n<p>How to Store Countries, States, Cities seed classes into the Database in Laravel PHP?<\/p>\n\n\n\n<p><a href=\"https:\/\/www.devopsschool.com\/blog\/how-to-store-countries-states-cities-seed-classes-into-the-database-in-laravel-php-part-1\/\">Part-1<\/a>                                                                                                                                                     <a href=\"https:\/\/www.devopsschool.com\/blog\/how-to-store-countries-states-cities-seed-classes-into-the-database-in-laravel-php-part-3\/\">Part-3<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91-1024x576.png\" alt=\"\" class=\"wp-image-17878\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-91.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><span class=\"has-inline-color has-vivid-red-color\"><strong>Step 1.<\/strong> <\/span><strong>Create<\/strong> a State seeder file. <strong>Write<\/strong> down the following command as follows:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">$  php artisan make:seeder StatesTableSeeder\n<\/code><\/span><\/pre>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79-1024x576.png\" alt=\"\" class=\"wp-image-17721\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-79.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 2.<\/span><\/strong> <strong>Create <\/strong>a State model. <strong>Write<\/strong> down the following command as follows:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">$  php artisan make:model State -m\n<\/code><\/span><\/pre>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80-1024x576.png\" alt=\"\" class=\"wp-image-17722\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-80.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 3.<\/span><\/strong> <strong>Add<\/strong> columns into Country table.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"> <span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">up<\/span><span class=\"hljs-params\">()<\/span>\n    <\/span>{\n        Schema::create(<span class=\"hljs-string\">'states'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-params\">(Blueprint $table)<\/span> <\/span>{\n           $table-&gt;bigIncrements(<span class=\"hljs-string\">'state_id'<\/span>);\n            $table-&gt;string(<span class=\"hljs-string\">'state_name'<\/span>);\n            $table-&gt;integer(<span class=\"hljs-string\">'country_id'<\/span>);\n            $table-&gt;timestamps();\n        });\n    }<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 4. <\/span>Go<\/strong> to<strong><em> Database\/seeds\/DatabaseSeeder<\/em><\/strong> file. <strong>Write<\/strong> down the following command as follows to add State seeder class:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"> <span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">run<\/span><span class=\"hljs-params\">()<\/span>\n    <\/span>{\n        <span class=\"hljs-keyword\">$this<\/span>-&gt;call(CountriesTableSeeder::class);\n        <span class=\"hljs-keyword\">$this<\/span>-&gt;call(StatesTableSeeder::class);\n    }<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 5. <\/span>Go<\/strong> to<strong><em> Database\/seeds\/CountriesTableSeeder<\/em><\/strong> file.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/17c87e73e02c399d96bfd372045d5eb6.js\"><\/script>\n\n\n\n<p><span class=\"has-inline-color has-vivid-red-color\"><strong>Step 6.<\/strong> <\/span><strong>Migrate&nbsp;<\/strong>the tables into the&nbsp;<strong>MySQL database<\/strong>.<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">$ php artisan migrate<\/code><\/span><\/pre>\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 7.<\/span><\/strong> <strong>Run <\/strong>the seeder class file individually.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">$  php artisan db:seed --<span class=\"hljs-class\"><span class=\"hljs-keyword\">class<\/span><\/span>=StatesTableSeeder<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 8. <\/span><\/strong> <strong>Go<\/strong> to<strong><em> app\\http\\Controllers\\MainController.php<\/em><\/strong> file. Define funcitions of Country and State.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/20b2e47edcbd81f9b46444b014f368d1.js\"><\/script>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 9. <\/span><\/strong>Then,&nbsp;<strong>go&nbsp;<\/strong>to&nbsp;<strong>routes\/web.php<\/strong>&nbsp;file and&nbsp;<strong>define&nbsp;<\/strong>all these routes.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">Route::<span class=\"hljs-keyword\">get<\/span>('\/getStates\/{id}<span class=\"hljs-string\">','<\/span>MainController@getStates<span class=\"hljs-string\">');<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90-1024x576.png\" alt=\"\" class=\"wp-image-17877\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/08\/image-90.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Thanks<\/p>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_72823\"><figure class=\"wp-block-embed wp-block-embed-youtube is-type-video is-provider-youtube epyt-figure\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_38842\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_72823\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div><\/figure><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>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: Step 2. Create a State model. Write down the following command as follows: Step 3. Add columns into Country table. Step 4. Go to Database\/seeds\/DatabaseSeeder&#8230;<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[1,5201],"tags":[],"class_list":["post-17720","post","type-post","status-publish","format-standard","hentry","category-sql","category-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/17720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=17720"}],"version-history":[{"count":6,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/17720\/revisions"}],"predecessor-version":[{"id":24559,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/17720\/revisions\/24559"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=17720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=17720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=17720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}