Delete data from database table on click button or link PHP

php Delete data from database table on click button or link PHP SQL Delete Statement

How to delete the data from database using PHP ?

To delete the data from database table by clicking the hyper link we first need to pass the unique identifier or ID as the GET request parameter in the URL. E.g <a href="delete.php?id=5">Delete</a> • In the above code we are going to pass the id with value equal to 5. • We can get this id value on delete.php page with PHP by $_GET[' '] or $_REQUEST[''] functions. $id = $_GET['id'];

How to pass the id of record from database to the anchor tag href link?

We will pass the id into the ' href ' attribute of anchor tag . • First will write the file name e.g ' delete.php ' . • Then will use the question mark symbol ?. • Then will pass the parameters e.g ' id=5 '

So the overall URL link will be like as delete.php?id=5 Note! We can pass multiple parameters in the URL with ' & ' symbol. e.g delete.php?user_id=5&record_id=55

Show.php File

<table border='1'>
	<tr>
		<th>First Name</th>
		<th>Last Name</th>
		<th>Username</th>
		<th>Password</th>
		<th>Delete</th>
	</tr>

<?php 

$conn = mysqli_connect('localhost', 'root', '', 'myfirstdatabase');

$sql_query = mysqli_query($conn,"SELECT ! FROM users");

while($fetch_result  = mysqli_fetch_assoc($sql_query))
{?>


<tr>
		<td><?php echo $fetch_result['first_name']; ?></td>
		<td><?php echo $fetch_result['last_name']; ?></td>
		<td><?php echo $fetch_result['username']; ?></td>
		<td><?php echo $fetch_result['password']; ?></td>
		<td><a href="delete.php?id=<?php echo $fetch_result['id']; ?>">Delete</a></td>
</tr>	


<?php } ?> 

	
</table>

Output

First Name	Last Name	Username	Password	Delete
Hussain	Khan	Alikhan2018	Ali12345	Delete
Umer	Khan	Umerkhan2018	12345	Delete
Usman	Khan	UsmanKhan22	Usman12345	Delete

Detail tutorial to display the record into table ⇨ Visit ⇨ How to fetch database table data and display it in HTML table?

Accept the GET request parameter and delete the record

As on onclick the delete button we will redirect to the delete.php file.

delete.php File

<?php 

$conn = mysqli_connect('localhost', 'root', '', 'myfirstdatabase');

$id = $_GET['id'];     //Geting the id value from URL parameter id

$sql_query = mysqli_query($conn,"DELETE FROM users WHERE id='".$id."' ");

header("location: show.php");   // Redirecting back to the show.php file after deleting the record.

?>

php SQL Delete Statement Chapter Next »