{"id":147,"date":"2009-02-13T23:31:30","date_gmt":"2009-02-13T23:31:30","guid":{"rendered":"https:\/\/jassweb.com\/new22\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate\/"},"modified":"2009-02-13T23:31:30","modified_gmt":"2009-02-13T23:31:30","slug":"solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/","title":{"rendered":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]"},"content":{"rendered":"<h2> Introduction <\/h2>\n<p>[ad_1]<\/p>\n<p>Adding a button to a PHP form that deletes rows from a MySQL database can be a useful way to manage data. This tutorial will provide step-by-step instructions on how to add a button to a PHP form that will delete rows from a MySQL database. It will also provide tips on how to ensure that the data is securely deleted from the database. By following this tutorial, you will be able to easily add a button to your PHP form that will delete rows from your MySQL database.<\/p>\n<h2> Solution<\/h2>\n<p><\/p>\n<p>You can use a delete button in your form to delete rows from your MySQL database.<\/p>\n<p>To do this, you will need to create a form with a delete button. The form should include a hidden field that contains the ID of the row you want to delete.<\/p>\n<p>When the delete button is clicked, you can use a PHP script to execute a MySQL query to delete the row from the database.<\/p>\n<p>For example, the following code will delete a row from a table called &#8216;users&#8217; where the ID is equal to the value of the hidden field:<\/p>\n<p><?php\nif(isset($_POST['delete'])) {\n    $id = $_POST['id'];\n    $sql = \"DELETE FROM users WHERE id = '$id'\";\n    $result = mysqli_query($conn, $sql);\n    if($result) {\n        echo \"Row deleted successfully\";\n    } else {\n        echo \"Error deleting row\";\n    }\n}\n?><\/p>\n<form action=\"\" method=\"post\">\n    <input type=\"hidden\" name=\"id\" value=\"<?php echo $id; ?>&#8220;><br \/>\n    <input type=\"submit\" name=\"delete\" value=\"Delete\"><br \/>\n<\/form>\n<p>This code should be placed in a PHP file and the file should be included in the page where the form is located. <\/p>\n<p><\/p>\n<div class=\"entry-content\" itemprop=\"text\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/p>\n<p><\/p>\n<div id=\"answer-40479557\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"40479557\" data-parentid=\"40479421\" data-score=\"3\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>In your html view page some change <code>echo \"&lt;td&gt;&lt;a href=\"https:\/\/stackoverflow.com\/questions\/40479421\/delete.php?did=\".$row[\"id'].\"'&gt;Delete&lt;\/a&gt;&lt;\/td&gt;\";<\/code> like bellow: <\/p>\n<pre><code>&lt;?php\nwhile($row = mysql_fetch_array($result))\n{\n    echo \"&lt;tr&gt;\";\n        echo \"&lt;td&gt;\" . $row['name'] . \"&lt;\/td&gt;\";\n        echo \"&lt;td&gt;\" . $row['id'] . \"&lt;\/td&gt;\";\n        echo \"&lt;td&gt;\" . $row['rollnumber'] . \"&lt;\/td&gt;\";\n        echo \"&lt;td&gt;\" . $row['address'] . \"&lt;\/td&gt;\";\n        echo \"&lt;td&gt;\" . $row['phonenumber'] . \"&lt;\/td&gt;\";\n        echo \"&lt;td&gt;&lt;a href=\"https:\/\/stackoverflow.com\/questions\/40479421\/delete.php?did=\".$row[\"id'].\"'&gt;Delete&lt;\/a&gt;&lt;\/td&gt;\";\n    echo \"&lt;\/tr&gt;\";\n}\n?&gt;\n<\/code><\/pre>\n<p>PHP delete code :<\/p>\n<pre><code>&lt;?php\nif(isset($_GET['did'])) {\n    $delete_id = mysql_real_escape_string($_GET['did']);\n    $sql = mysql_query(\"DELETE FROM venu WHERE id = '\".$delete_id.\"'\");\n    if($sql) {\n        echo \"&lt;br\/&gt;&lt;br\/&gt;&lt;span&gt;deleted successfully...!!&lt;\/span&gt;\";\n    } else {\n        echo \"ERROR\";\n    }\n}\n?&gt;\n<\/code><\/pre>\n<p>Note : Please avoid <code>mysql_*<\/code> because <code>mysql_*<\/code> has beed removed from<br \/>\nPHP 7. Please use <code>mysqli<\/code> or <code>PDO<\/code>.<\/p>\n<p>More details about of <code>PDO<\/code> connection <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/php.net\/manual\/en\/pdo.connections.php\">http:\/\/php.net\/manual\/en\/pdo.connections.php<\/a><\/p>\n<p>And more details about of <code>mysqli<\/code> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/php.net\/manual\/en\/mysqli.query.php\">http:\/\/php.net\/manual\/en\/mysqli.query.php<\/a><\/p>\n<\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p> <span class=\"d-none\" itemprop=\"commentCount\">2<\/span> <\/p>\n<\/div>\n<\/div>\n<p>solved How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] <\/p>\n<p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/div>\n<p>[ad_2]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction [ad_1] Adding a button to a PHP form that deletes rows from a MySQL database can be a useful way to manage data. This tutorial will provide step-by-step instructions on how to add a button to a PHP form that will delete rows from a MySQL database. It will also provide tips on how &#8230; <a title=\"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/\" aria-label=\"More on [Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[346,339],"class_list":["post-147","post","type-post","status-publish","format-standard","hentry","category-solved","tag-html","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"Introduction [ad_1] Adding a button to a PHP form that deletes rows from a MySQL database can be a useful way to manage data. This tutorial will provide step-by-step instructions on how to add a button to a PHP form that will delete rows from a MySQL database. It will also provide tips on how ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2009-02-13T23:31:30+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]\",\"datePublished\":\"2009-02-13T23:31:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/\"},\"wordCount\":208,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"keywords\":[\"html\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/\",\"name\":\"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"datePublished\":\"2009-02-13T23:31:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb","og_description":"Introduction [ad_1] Adding a button to a PHP form that deletes rows from a MySQL database can be a useful way to manage data. This tutorial will provide step-by-step instructions on how to add a button to a PHP form that will delete rows from a MySQL database. It will also provide tips on how ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/","og_site_name":"JassWeb","article_published_time":"2009-02-13T23:31:30+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]","datePublished":"2009-02-13T23:31:30+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/"},"wordCount":208,"commentCount":0,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["html","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/","name":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2009-02-13T23:31:30+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-add-a-button-to-my-php-form-that-deletes-rows-from-my-mysql-database-duplicate-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to add a button to my PHP form that deletes rows from my MYSQL database [duplicate]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=147"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/147\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}