{"id":12028,"date":"2020-03-09T12:54:51","date_gmt":"2020-03-09T12:54:51","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=12028"},"modified":"2020-03-13T05:53:25","modified_gmt":"2020-03-13T05:53:25","slug":"inserting-data-in-database-through-model","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/inserting-data-in-database-through-model\/","title":{"rendered":"Inserting data in Database through Model."},"content":{"rendered":"\n<p>There are many methods for inserting data in database through Model. See below:-<\/p>\n\n\n\n<p>Migration is common in all methods in which we defined the table name and default value of all column&#8217;s. See below the migration code:- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"160\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Migration-of-insertion-by-object.png\" alt=\"\" class=\"wp-image-12039\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Migration-of-insertion-by-object.png 448w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Migration-of-insertion-by-object-300x107.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Method 1: Through object.<\/h2>\n\n\n\n<p>We can insert data using Object in our controller. See the below code for help:-<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/SushantSinghRajput03\/fccaf87a51be2440c7bba972bc2e9c2f.js\"><\/script>\n\n\n\n<p>Where, <strong>$project<\/strong> = Object.<\/p>\n\n\n\n<p>See <strong>Output<\/strong> below:- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"113\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-object-db.png\" alt=\"\" class=\"wp-image-12036\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-object-db.png 789w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-object-db-300x43.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-object-db-768x110.png 768w\" sizes=\"auto, (max-width: 789px) 100vw, 789px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Method 2: Through Controller<\/h2>\n\n\n\n<p>We can insert data by using constructor in our controller. See the below code for help:- <\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/SushantSinghRajput03\/ff5c4a71e754d634d4136b8f082d74a2.js\"><\/script>\n\n\n\n<p>But, whenever we are inserting data by using controller then we need to use <strong>fillable<\/strong> or <strong>guarded<\/strong> property in model otherwise it returns an error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">See below how to use fillable:- <\/h2>\n\n\n\n<p><em>protected $fillable = [&#8220;key1&#8243;,&#8221;key2&#8221;];<\/em> <\/p>\n\n\n\n<p><strong>Note:-<\/strong> We add value of key in fillable which we want to add in the database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"> See below how to use guarded:-  <\/h2>\n\n\n\n<p>protected $guarded = [&#8220;key1&#8243;,&#8221;key2&#8221;];<\/p>\n\n\n\n<p> <strong>Note:-<\/strong> We add the value of key in guarded which we don&#8217;t want to add in the database. <\/p>\n\n\n\n<p>See the <strong>Output<\/strong> below:-  <\/p>\n\n\n\n<p>insertion by using <strong>fillable<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"138\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-fillable.png\" alt=\"\" class=\"wp-image-12060\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-fillable.png 786w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-fillable-300x53.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-fillable-768x135.png 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure><\/div>\n\n\n\n<p> insertion by using <strong>guarded<\/strong>. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"788\" height=\"168\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-guarded.png\" alt=\"\" class=\"wp-image-12062\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-guarded.png 788w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-guarded-300x64.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-constructor-guarded-768x164.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">method 3: Through create() method<\/h2>\n\n\n\n<p> We can insert data using create() method in our controller. See the below code for help:- <\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/SushantSinghRajput03\/e417501dfcc304a41a24ec4127e93089.js\"><\/script>\n\n\n\n<p>As above property, it also depends on fillable and guarded.<\/p>\n\n\n\n<p>See the output below:- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"168\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-create-db.png\" alt=\"\" class=\"wp-image-12072\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-create-db.png 789w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-create-db-300x64.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-by-create-db-768x164.png 768w\" sizes=\"auto, (max-width: 789px) 100vw, 789px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are many methods for inserting data in database through Model. See below:- Migration is common in all methods in which we defined the table name and default value of&#8230; <\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5201],"tags":[],"class_list":["post-12028","post","type-post","status-publish","format-standard","hentry","category-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/12028","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=12028"}],"version-history":[{"count":43,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/12028\/revisions"}],"predecessor-version":[{"id":12081,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/12028\/revisions\/12081"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=12028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=12028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=12028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}