Technology. Education. Art (TEA) TEAlearn.org

Home > Courses > Web development using PHP and MySQL > Delete record using PHP

Delete record using PHP

Subject: Web development using PHP and MySQL

We use the DELETE SQL statement to delete record from a table.

syntax

DELETE FROM table_name WHERE id = record_id

Example

DELETE FROM feedback WHERE id = 3

However the record_id e.g 3 will not be hardcoded like this, just as we did with edit, we will introduce a "Delete" link and the link will send the id number to the code for deleting.

Here is the code (I have remove the pagination section to make the code focus on deleting, I will provide a GitHub link below to download the all code)

feedback_table_paginate_update.php


<HTML>
<HEAD>
<TITLE> Company Feedback </TITLE>
</HEAD>
<BODY>
<b>FEEDBACK LIST</b>


<?php
//include the connection string
include("conn.php");

if(isset($_REQUEST['delete_id'])){
	$delete_id = mysqli_escape_string($conn, $_REQUEST['delete_id']);
	$query  = "DELETE FROM feedback WHERE id = '$delete_id'";
	$result = mysqli_query($conn, $query) or die(mysqli_error($conn));
	if($result){
		print "Record deleted";
	}
	
}
//query the table
$query  = "SELECT * FROM feedback ORDER BY id DESC";
$result = mysqli_query($conn, $query) or die(mysqli_error($conn));	

//the table header
print "
<table width=\"50%\" border=1>
<tr>
<td>NAME</td>
<td>EMAIL</td>
<td>COMMENT</td>
<td>DATE POST</td>
<td></td>
<td></td>
</tr>
";

//loop through the query and print the result
while($info = mysqli_fetch_array($result)){
     $data_id = $info['id'];
     $data_name = $info['name'];
     $data_email = $info['email'];
     $data_comment = $info['comment'];
     $data_date = $info['date_submit'];

           print "
           <tr>
               <td> $data_name </td>
               <td> $data_email </td>
               <td> $data_comment </td>
               <td> $data_date </td>
               <td><a href=\"feedback_edit.php?id=$data_id\">Edit</a></td>
               <td> <a href=\"?delete_id=$data_id\" onclick=\"return confirm('Are you sure you want to delete?')\"> Delete </td>
           </tr>
           ";
}
print "</table>";
?>
</BODY>
</HTML>

Some explanations
New column with the link delete link was introduced:


 <td> <a href=\"?delete_id=$data_id\" onclick=\"return confirm('Are you sure you want to delete?')\"> Delete </td>

I gets the record id stores into variable $data_id and assigned it to the variable of our URL string delete_id and this URL submits back to same page (hence no file name in the URL, unlike the edit) ?delete_id=$data_id

The second part of the URL
onclick=\"return confirm('Are you sure you want to delete?')\ is a JavaScript onclick event that will prompt user to confirm if the really want to delete the record, to prevent record from being deleted by mistake.

If a user confirm that they really want to delete the record then this section of our code that actually delete the record using the selected id is then executed


if(isset($_REQUEST['delete_id'])){
	$delete_id = mysqli_escape_string($conn, $_REQUEST['delete_id']);
	$query  = "DELETE FROM feedback WHERE id = '$delete_id'";
	$result = mysqli_query($conn, $query) or die(mysqli_error($conn));
	if($result){
		print "Record deleted";
	}
}

Gitup link:

https://github.com/BenOnuorah/tea_learn_php_sample.git

Prompt before deleting