Delete multiple records from MySQL in PHP with checkbox

Delete multiple records from MySQL in PHP with checkbox

As we know, Its very time consuming to delete records one by one. Everyone wants to delete bulk record on single event only.

So here i will tell you how to delete bulk records from MySQL table in PHP with checkbox, you just need to select checkbox which one you want to delete and hit submit button to delete.

Its strongly recommended for large scale of data where its not possible to delete one by one.

Here in this tutorial, i will simple create a product table for demo with dummy records to test this code.

And with every row there will be one checkbox that hold the id of records in array.

There will be one checkbox with header too for select all records on single click.

When you are going to delete records, you will be asked for confirmation "Do you really want to delete records" when you click yes then selected records will be deleted from database table.

products table

In first step, create a products table in database and insert some dummy records after creating a table.

  1. CREATE TABLE `products` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  4. `details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  5. `created_at` datetime NOT NULL,
  6. `updated_at` datetime NOT NULL,
  7. `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=Active, 0=Deactive',
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Now i have a products table with id, name, details, created_at, updated_At, status fields.

Database Configuration : db_config.php

Now i need to setup my database configuration in db_config.php file.

  1. <?php
  2. $dbHost = 'localhost'; //database host name
  3. $dbUser = 'root'; //database username
  4. $dbPass = ''; //database password
  5. $dbName = 'expertphp_demo'; //database name
  6. $conn = mysqli_connect($dbHost,$dbUser,$dbPass,$dbName);
  7. if(!$conn){
  8. die("Database connection failed: " . mysqli_connect_error());
  9. }
  10. ?>
index.php

In this step, create a file where we list all records from database into html table but first include db_config.php for database access.

To work with js script, include jQuery library.

deleteConfirm() method is javascript function that is called on form submit to make sure you are really want to delete the product.

  1. <!DOCTYPE html>
  2. <html lang="en-US">
  3. <head>
  4.     <title>Delete multiple records from MySQL in PHP with checkbox - ExpertPHP</title>
  5. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  6.     <script src="https://code.jquery.com/jquery-3.1.0.min.js"></script>
  7. </head>
  8. <body>
  9. <?php
  10.     session_start();
  11. include_once('db_config.php');
  12. $query = mysqli_query($conn,"SELECT * FROM products");
  13. ?>
  14.     
  15. <form name="actionForm" action="action.php" method="post" onsubmit="return deleteConfirm();"/>
  16. <table class="table-striped">
  17. <thead>
  18. <tr>
  19. <th><input type="checkbox" name="check_all" id="check_all" value=""/></th>
  20. <th>Name</th>
  21. <th>Details</th>
  22. </tr>
  23. </thead>
  24. <?php
  25. if(mysqli_num_rows($query) > 0){
  26. while($row = mysqli_fetch_assoc($query)){
  27.     extract($row);
  28. ?>
  29. <tr>
  30. <td align="center"><input type="checkbox" name="selected_id[]" class="checkbox" value="<?php echo $id; ?>"/></td>
  31. <td><?php echo $name; ?></td>
  32. <td><?php echo $details; ?></td>
  33. </tr>
  34. <?php } }else{ ?>
  35. <tr><td colspan="3">No records found.</td></tr>
  36. <?php } ?>
  37. </table>
  38. <input type="submit" class="btn btn-primary" name="btn_delete" value="Delete"/>
  39. </form>
  40. <script type="text/javascript">
  41. function deleteConfirm(){
  42. var result = confirm("Do you really want to delete records?");
  43. if(result){
  44. return true;
  45. }else{
  46. return false;
  47. }
  48. }
  49. $(document).ready(function(){
  50. $('#check_all').on('click',function(){
  51. if(this.checked){
  52. $('.checkbox').each(function(){
  53. this.checked = true;
  54. });
  55. }else{
  56. $('.checkbox').each(function(){
  57. this.checked = false;
  58. });
  59. }
  60. });
  61. $('.checkbox').on('click',function(){
  62. if($('.checkbox:checked').length == $('.checkbox').length){
  63. $('#check_all').prop('checked',true);
  64. }else{
  65. $('#check_all').prop('checked',false);
  66. }
  67. });
  68. });
  69. </script>
  70. </body>
  71. </html>
action.php

In this step create a php file where we handle form data. when we click submit button then form will be submitted to their action page.

In this PHP file we will get all selected id of records that will be deleted from product table.

Once records are deleted then we store the message in session according to response to notify the user.

  1. <?php
  2. session_start();
  3. include_once('db_config.php');
  4. if (count($_POST["selected_id"]) > 0 ) {
  5.      $all = implode(",", $_POST["selected_id"]);
  6.      $query="DELETE FROM products WHERE 1 AND id IN($all)";
  7.      if(mysqli_query($conn,$query)){
  8.          $_SESSION['success'] = 'Products have been deleted successfully.';
  9.      }
  10.     }else{
  11.         $_SESSION['error'] = 'Select checkbox to delete product.';
  12.     }
  13. header("Location:index.php");
  14. ?>

Phone: (+91) 8800417876
Noida, 201301
sakarya escort akyazı escort arifiye escort erenler escort eve gelen escort ferizli escort geyve escort hendek escort otele gelen escort sapanca escort söğütlü escort taraklı escort
sakarya escort akyazı escort arifiye escort erenler escort eve gelen escort ferizli escort geyve escort hendek escort karapürçek escort karasu escort kaynarca escort kocaali escort otele gelen escort pamukova escort sapanca escort söğütlü escort taraklı escort
sakarya escort akyazı escort arifiye escort erenler escort eve gelen escort ferizli escort geyve escort hendek escort karapürçek escort karasu escort kaynarca escort kocaali escort otele gelen escort pamukova escort sapanca escort söğütlü escort taraklı escort
sakarya escort akyazı escort arifiye escort erenler escort eve gelen escort ferizli escort geyve escort hendek escort karapürçek escort karasu escort kaynarca escort kocaali escort otele gelen escort pamukova escort sapanca escort söğütlü escort taraklı escort
sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort izmit escort sakarya escort sapanca escort sakarya escort