{"id":12082,"date":"2020-03-13T06:39:31","date_gmt":"2020-03-13T06:39:31","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=12082"},"modified":"2020-03-13T13:05:37","modified_gmt":"2020-03-13T13:05:37","slug":"read-update-and-delete-data-through-model","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/read-update-and-delete-data-through-model\/","title":{"rendered":"Read, Update, and Delete data through Model."},"content":{"rendered":"\n

Read Data from Database through Model <\/h1>\n\n\n\n

First, we have to connect our model and database in our controller. For that we use below code in our controller:- <\/p>\n\n\n\n

use DB;
use app\/Model_Name;<\/h3>\n\n\n\n

After configuring DB and model, we make a function in which we create an instance of our model. After that, we use all()<\/strong> for fetching our data from the database. Before running the code we have to set Route for it. After setting the route let’s See the below code:-<\/strong><\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

See the output below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

If we want to fetch a particular row then we use the first()<\/strong> method. See the below code:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

in the above code, we provided id no. 4 so that it fetched all data of ID => 4. and if we can’t add where condition then it by default prints the first row. See the output below:-<\/strong> <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Update Data from Database through Model <\/h1>\n\n\n\n

There is no method to update data, so to update data first we fetch the table and then declare the key-value and save it. See below:-<\/strong> <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

See the output below:-<\/strong><\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Delete Data from Database through Model <\/h1>\n\n\n\n

We use delete()<\/strong> method to delete the data from the database through the model. <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

See the output below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Read Data from Database through Model First, we have to connect our model and database in our controller. For that we use below code in our controller:- use DB;use app\/Model_Name;… <\/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-12082","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\/12082","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=12082"}],"version-history":[{"count":44,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/12082\/revisions"}],"predecessor-version":[{"id":12139,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/12082\/revisions\/12139"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=12082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=12082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=12082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}