{"id":11999,"date":"2020-03-09T05:49:48","date_gmt":"2020-03-09T05:49:48","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=11999"},"modified":"2020-03-09T07:42:06","modified_gmt":"2020-03-09T07:42:06","slug":"how-to-update-and-delete-data-from-database-using-controller","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-update-and-delete-data-from-database-using-controller\/","title":{"rendered":"How to Update and Delete data from database using Controller."},"content":{"rendered":"\n

Update data from the database<\/h1>\n\n\n\n

To Update the data in database table we use update()<\/strong>. See the syntax below:- <\/p>\n\n\n\n

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

See the below code for updating data in the database. I’m updating my id=2 name and email. <\/p>\n\n\n\n

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

When we run the page, it will update the id=2 data from the above data, if the page returns 1 then data updated else not updated. Let’s see the database.<\/p>\n\n\n\n

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

See the above image, the data of id 2 is updated.<\/p>\n\n\n\n

Note:-<\/strong> If we can’t add where condition, then it will update all names and emails.<\/p>\n\n\n\n

Delete data from the database<\/h1>\n\n\n\n

We use delete()<\/strong> to delete the data from the database. See the syntax below:- <\/p>\n\n\n\n

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

I’m deleting id=2 from my database, see the code below:- <\/p>\n\n\n\n

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

See the output below when we run the page.<\/p>\n\n\n\n

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

Note:-<\/strong> If we can’t add where condition, then it will Delete all rows.<\/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\n\n\n

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

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

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

Update data from the database To Update the data in database table we use update(). See the syntax below:- See the below code for updating data in the database. I’m… <\/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-11999","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\/11999","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=11999"}],"version-history":[{"count":13,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11999\/revisions"}],"predecessor-version":[{"id":12027,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11999\/revisions\/12027"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=11999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=11999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=11999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}