{"id":11950,"date":"2020-03-07T12:12:59","date_gmt":"2020-03-07T12:12:59","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=11950"},"modified":"2020-03-09T05:48:17","modified_gmt":"2020-03-09T05:48:17","slug":"how-to-insert-read-update-and-delete-data-from-database-using-controller","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-insert-read-update-and-delete-data-from-database-using-controller\/","title":{"rendered":"How to Insert and Read data from database using Controller."},"content":{"rendered":"\n<p>First, make a Controller and View. To use the database query in the controller, we have to use database class (<strong>use DB;<\/strong>) in the controller. See the below image:- <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"127\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Use-database-class.png\" alt=\"\" class=\"wp-image-11955\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Use-database-class.png 535w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Use-database-class-300x71.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/figure><\/div>\n\n\n\n<h1 class=\"has-vivid-red-color has-text-color has-text-align-center wp-block-heading\">Insert data into Database.<\/h1>\n\n\n\n<p>First, make a function in the controller in which define a variable which is equal to the insertion Syntax and echo the variable.<\/p>\n\n\n\n<h3 class=\"has-luminous-vivid-orange-color has-text-color has-text-align-center wp-block-heading\">Syntax<\/h3>\n\n\n\n<script src=\"https:\/\/gist.github.com\/SushantSinghRajput03\/d037d894af9cbb909df99220c36d9b71.js\"><\/script>\n\n\n\n<p>Where, R1 = Row1<br>               R2 = Row2<\/p>\n\n\n\n<p>See the below image for insertion of data into the database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"272\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-using-controller.png\" alt=\"\" class=\"wp-image-11962\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-using-controller.png 535w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/insertion-using-controller-300x153.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/figure>\n\n\n\n<p>Now <strong>route <\/strong>the <strong>controller<\/strong>, start <strong>Laravel development server<\/strong> and open the page. As the page opens, the data inserted into the database and returns 1 as output. Now let&#8217;s check that our data is inserted or not.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"688\" height=\"132\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-controller-db.png\" alt=\"\" class=\"wp-image-11974\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-controller-db.png 688w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Insertion-by-controller-db-300x58.png 300w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/figure>\n\n\n\n<p>Yeah, it&#8217;s inserted.<\/p>\n\n\n\n<h1 class=\"has-vivid-red-color has-text-color has-text-align-center wp-block-heading\">Read data from Database.<\/h1>\n\n\n\n<p>To read the data from a database we use <strong>get()<\/strong>. See the syntax below<\/p>\n\n\n\n<p class=\"has-text-align-center\">$<strong>Variable<\/strong>= DB::table(&#8220;<strong>Table_name<\/strong>&#8220;)-&gt;<strong>get()<\/strong>;<\/p>\n\n\n\n<p>See the below image for help:-<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"294\" height=\"114\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Read-db-data.png\" alt=\"\" class=\"wp-image-11986\"\/><\/figure><\/div>\n\n\n\n<p>See the output when we open the page. It shows all data inserted in the database.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"417\" height=\"387\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Read-db-data-output.png\" alt=\"\" class=\"wp-image-11991\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Read-db-data-output.png 417w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/03\/Read-db-data-output-300x278.png 300w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/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\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, make a Controller and View. To use the database query in the controller, we have to use database class (use DB;) in the controller. See the below image:- Insert&#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":[5203],"class_list":["post-11950","post","type-post","status-publish","format-standard","hentry","category-laravel","tag-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11950","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=11950"}],"version-history":[{"count":33,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11950\/revisions"}],"predecessor-version":[{"id":11997,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11950\/revisions\/11997"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=11950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=11950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=11950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}