Deleting Data from within the Database using PHP

    You can delete data from the database using delete command within the mysql_query function.

    Example: 

    <html>
   <head>
      <title>Deleting a Record from Database</title>
   </head>
   <body>
<?php
         if(isset($_POST[‘delete’])) {
   $db_host = 'localhost:3036';
   $db_user = 'root';
   $db_pass = 'rootpassword';
   $db_conn = mysql_connect($db_host, $db_user, $db_pass);   
   if(! $db_conn ) {
      die('Connection failed: ' . mysql_error());
   }
$stu_id = $_POST['stu_id'];
$db_sql = "DELETE from student where stu_id = $stu_id" ;
   mysql_select_db('demo_db');
   $db_retval = mysql_query( $db_sql, $db_conn );
if(! $db_retval ) {
      die('data cannot not be deleted: ' . mysql_error());
   }
echo "deleted data successfully\n";
   mysql_close($db_conn);
?> else
{
?>
<form method = "post" action = "<?php $_PHP_SELF ?>">
                  <table width = "400" border =" 0" cellspacing = "1" 
                     cellpadding = "2">                  
                     <tr>
                        <td width = "100">Student ID</td>
                        <td><input name = "stu_id" type = "text" 
                           id = "stu_id"></td>
                     </tr>
                     <tr>
                        <td width = "100"> </td>
                        <td> </td>
                     </tr>                  
                     <tr>
                        <td width = "100"> </td>
                        <td>
                           <input name = "delete" type = "submit" 
                              id = "delete" value = "Delete">
                        </td>
                     </tr>                  
                  </table>
               </form>
            <?php
         }
      ?>      
   </body>
</html>

    People are also reading:

    Previous Tutorial Next Tutorial