You can use php query to delete the data from the mysql database.<\/p>\n
Example code:<\/strong><\/p>\n [php]<?php \/\/ Create connection \/\/ sql to delete a record if ($conn->query($sql) === TRUE) { $conn->close(); Code Explanation:<\/strong><\/p>\n After we connected to the database. We have used On the next statement, we have used if statement to check whether php script has successfully executed or not. if it resulted true then echo statement delete data will be executed.<\/p>\n","protected":false},"excerpt":{"rendered":" You can use php query to delete the data from the mysql database. Example code: [php]<?php $servername = "localhost"; $username = "username"; $password = "password";<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-381","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/comments?post=381"}],"version-history":[{"count":1,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/381\/revisions"}],"predecessor-version":[{"id":382,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/381\/revisions\/382"}],"wp:attachment":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/media?parent=381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/categories?post=381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/tags?post=381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n$servername = "localhost";
\n$username = "username";
\n$password = "password";
\n$dbname = "myDB";<\/p>\n
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die("Connection failed: " . $conn->connect_error);
\n} <\/p>\n
\n$sql = "DELETE FROM MyGuests WHERE id=3";<\/p>\n
\n echo "Record deleted successfully";
\n} else {
\n echo "Error deleting record: " . $conn->error;
\n}<\/p>\n
\n?>[\/php]<\/p>\n$sql<\/code> query to instruct the php script to delete the data from myGuest<\/code> database WHERE <\/code>id number is 3.<\/p>\n$sql = \"DELETE FROM MyGuests WHERE id=3\";<\/code><\/p>\n