Hi, are you looking for the code in which you want to delete the multiple records using a checkbox? In this tutorial, you will learn to delete multiple records in PHP using the checkbox or selected checkbox.
In the previous tutorial, you learned about how to delete a single record. Here you learn about to delete the multiple records by selected checkbox with validation to select at least one checkbox. Here are the files and folders to delete multiple records in PHP. Check this demo.
So without wasting our time, let’s get started to create our files.
index.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>Delete records from database using PHP - Coding Birds Online</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="validation.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<link rel="icon" href="https://codingbirdsonline.com/wp-content/uploads/2019/12/cropped-coding-birds-favicon-2-1-192x192.png" type="image/x-icon">
<style>
#thead>tr>th{ color: white; }
</style>
</head>
<body>
<div style="margin-top: 20px;padding-bottom: 20px;">
<center>
<img width="100" src="https://codingbirdsonline.com/wp-content/uploads/2019/12/cropped-coding-birds-favicon-2-1-192x192.png"/>
<h3>Delete multiple records from database using PHP </h3>
</center>
</div>
<div class="container">
<form action="delete-script.php" method="post">
<table class="table table-bordered">
<thead id="thead" style="background-color:#1573ff">
<tr>
<th>Sr.No</th>
<th>Name</th>
<th>Email</th>
<th>Contact</th>
<th>Department</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
include "config.php";
include_once "Common.php";
$common = new Common();
$records = $common->getAllRecords($connection);
if ($records->num_rows>0){
$sr = 1;
while ($record = $records->fetch_object()) {
$recordId = $record->id;
$name = $record->name;
$email = $record->email;
$contact = $record->contact;
$department = $record->department;?>
<tr>
<td><?php echo $sr;?></td>
<td><?php echo $name;?></td>
<td><?php echo $email;?></td>
<td><?php echo $contact;?></td>
<td><?php echo $department;?></td>
<td><input type="checkbox" name="recordsCheckBox[]" id="recordsCheckBox" value="<?php echo $recordId;?>"></td>
</tr>
<?php
$sr++;
}
}
?>
</tbody>
</table>
<input type="submit" name="deleteBtn" id="deleteBtn" class="btn btn-success" onclick="return validateForm();" value="Delete Records" style="float: right"/>
</form>
</div>
</body>
</html>This index.php file includes config.php and Common.php. These files are database connections and PHP class file. Let’s create these files.
config.php
<?php
$hostName = "localhost"; // host name
$username = "root"; // database username
$password = ""; // database password
$databaseName = "codingbirds"; // database name
$connection = new mysqli($hostName,$username,$password,$databaseName);
if (!$connection) {
die("Error in database connection". $connection->connect_error);
}
?>Common.php
<?php
class Common
{
public function getAllRecords($connection) {
$query = "SELECT * FROM bird_delete_records";
$result = $connection->query($query) or die("Error in query1".$connection->error);
return $result;
}
public function deleteRecordById($connection,$id) {
$query = "DELETE FROM bird_delete_records WHERE id='$id'";
$result = $connection->query($query) or die("Error in query".$connection->error);
return $result;
}
}validation.js
function validateForm() {
var count_checked = $("[name='recordsCheckBox[]']:checked").length;
if (count_checked == 0) {
alert("Please check at least one checkbox");
return false;
}else{
return true;
}
}delete-script.php
<?php
include "config.php";
include_once "Common.php";
if (isset($_POST['deleteBtn'])){
$recordIds = $_POST['recordsCheckBox'];
$common = new Common();
foreach ( $recordIds as $id ) {
$delete = $common->deleteRecordById($connection,$id);
}
if ($delete) {
echo '<script>alert("Record deleted successfully !")</script>';
echo '<script>window.location.href="index.php";</script>';
}
}After running this code you will get output like this.
So this is the output when you run the code. Now if you press the delete button when you get a prompt alert that, select at least one checkbox.
After selecting and pressing the delete button the records will be deleted that you have selected before. I hope you understood the concept and the code.
You can download the full working source code from here so that there is no error in your code. You can also watch this video uploaded a year ago of mine, telling the same thing but in procedural style.
Happy Coding 🙂
21 Comments
Awesome
It is very helpful to delete multiple records by single click..
Thanks
Thank you for your expertise. Somebody like me who is not tech savvy lol. I’m always doing things the hard way.
Hahaha, Thanks
Thank you for sharing. It was so helpful so easy to understand.
Informative and helpful to learn how to delete multiple records. Thank you for the post.
Helpful post! I’m not good in doing web development but this is understandable for newbie. Thanks!
It is not an easy task for me, just for certain people
Coding sounds awesome, but It’s all gibberish for me. Thank you for sharing your knowledge with us!
Very informative post! Thanks for sharing.
hope it would help me when i would restart to learn php for my scientific team
Thanks for the tutorial, it is very useful
vary good post..
Thank you for sharing how to delete multiple at a time, huge time saver!
Very helpful information on deleting multiple records in PHP using the checkbox. I have recently started following your blog. You keep the coding so precise and straightforward which make it easy to understand. Thank you for sharing.
That is very informative. I need to do that before the end of the year.
Very well written post. Quite Informative.
Thank you so much for this informative post,I am really thankful for such posts they really helped me with my blogging.
thanks for sharing this info, learnt the tips, cheers siennylovesdrawing
Nice instructional content! Though I do not have a current need for it but I will reference it here when I do. I like the you added a YouTube video to compliment your text to ensure reader can follow along as a viewer. Well done.
Thanks for your appreciation, It made my day 🙂
how to multiple delete data using ajax in wordpress plugin??