How To Delete Data in MySQL/PHP

Introduction: This tutorial is on how to delete data through HTML/PHP from a MySQLi table. Listing: This tutorial is carrying on from my previous two tutorials in which I taught you how to insert and list data to/from a MySQL(i) database and table. You can check those tutorials out here; Inserting Data: http://www.sourcecodester.com/tutorials/php/7751/how-insert-data-mysqli-database-through-php.html Listing Data: http://www.sourcecodester.com/tutorials/php/7758/how-select-data-mysql-table-php.html Listing Modifications: Before we can being, we are going to modify my listing script from my previous tutorial to add in a simple 'delete' link next to each of the records output to the screen, like so... So now we have a link with the text value of 'Delete' next to each of our displayed rows. This link goes to 'page.php' with the GET variable 'id' value of the ID of the current row being read by the query statement/while loop - This gives us a reference when deleteing so that we don't accidentally delete the wrong row. Page.php: Now, we need to create 'page.php', if it is not the same page as you have your listing code on, you are going to want to re-create the basic PHP code tags and database connection... Again, this above code would create a connection in the variable named 'con' to the database 'testDB' with the username of 'root', no password, and on the 'localhost' service server. GET: We know that we are parsing our row ID from our listing page to our deletion script through the GET key of 'del', so before we can use that key, we need to ensure that it is there... Next we want to ensure that it is not equal to nothing/null/empty... ... Of course, if we tried to delete a null key, we would receive an error. Now we can put the value of our GET 'del' key in to a variable, we'll name this 'key'... Finally, we want to create our query and output the returning code. To do this, we create the query... The above code would delete all (* wildcard) columns from the table 'testTable' on the row where the 'id' column matches the value of the 'key' variable - the value we parsed from our listing script earlier on. Now we can simply check if the query executed successfully, and output a message accordingly... Finished!