How to Delete Data from MySQL Database using PHP

Hello dear readers! welcome back to another section of our tutorial on PHP. In this section of our PHP tutorial, we will be studying about how to Delete Data from MySQL Database.

Data can be deleted from MySQL tables by executing SQL DELETE statement using PHP mysql_query function.

Following below is a very simple example to delete records from employee table. To delete a record in any table, it is required to locate that record by using a conditional clause. Below example makes use of primary key to match a record in employee table.


Try the following example below to understand delete operation. You need to provide an employee ID to delete employee record from the employee table.

      <title>Delete a Record from MySQL Database</title>
         if(isset($_POST['delete'])) {
            $dbhost = 'localhost:3036';
            $dbuser = 'root';
            $dbpass = 'rootpassword';
            $conn = mysql_connect($dbhost, $dbuser, $dbpass);
            if(! $conn ) {
               die('Could not connect: ' . mysql_error());
            $emp_id = $_POST['emp_id'];
            $sql = "DELETE FROM employee WHERE emp_id = $emp_id" ;
            $retval = mysql_query( $sql, $conn );
            if(! $retval ) {
               die('Could not delete data: ' . mysql_error());
            echo "Deleted data successfully\n";
         }else {
               <form method = "post" action = "<?php $_PHP_SELF ?>">
                  <table width = "400" border = "0" cellspacing = "1" 
                     cellpadding = "2">
                        <td width = "100">Employee ID</td>
                        <td><input name = "emp_id" type = "text" 
                           id = "emp_id"></td>
                        <td width = "100"> </td>
                        <td> </td>
                        <td width = "100"> </td>
                           <input name = "delete" type = "submit" 
                              id = "delete" value = "Delete">

Alright guys! This is where we are rounding up for this tutorial post. In our next tutorial guide, we will be discussing about how to use PHP to Backup MySQL Database.

Feel free to ask your questions where necessary and i will attend to them as soon as possible. If this tutorial was helpful to you, you can use the share button to share this tutorial.

Follow us on our various social media platforms to stay updated with our latest tutorials. You can also subscribe to our newsletter in order to get our tutorials delivered directly to your emails.

Thanks for reading and bye for now.