Multiple Delete Data

Submitted by azalea zenith on Tuesday, October 4, 2016 - 13:15.
If you are looking for on how to create Multiple Delete Data in PHP then you are at the right place. This simple system can add data to the database then you can delete the data individually or you can be used the checkbox to delete more than one data in just one click. We are going to use the checkbox as our selector so the user can select multiple or one data only to delete. Hope you will find this tutorial useful. We are going to construct first the Form Field where we can add data to the database.
  1. <form method="post">
  2.    <div>
  3.       <label>Member Name</label>
  4.       <input type="text" name="tbl_member_name" placeholder="Member Name . . . . .">
  5.    </div>
  6.    <div>
  7.       <label>Contact Number</label>
  8.       <input type="number" name="tbl_member_contact" placeholder="Contact Number . . . . .">
  9.    </div>
  10.    <button type="submit" name="submit">Submit</button>
  11. </form>
In the source code below, we are going to use to select/unselect the data in the table enable to delete the data in the database.
  1. <td>
  2.    <input type="checkbox" name="check[]"  value="<?php echo $row_member['tbl_member_id']; ?>" id="all" />
  3. </td>
Then, let's create our database connection to display and delete data in the database.
  1. <?php
  2. $db = mysql_connect('localhost', 'root', '') or die("Unable to connect to Database Server.");
  3. mysql_select_db('db_search', $db) or die("Could not select database.");
  4. ?>
And, this is the query where we can add data to the database and we can delete in a single data to multiple in the database. Check the query below and study. This query use to add data in the database.
  1. <?php
  2.  
  3. if (isset($_POST['submit']))
  4.         {
  5.         $tbl_member_name = $_POST['tbl_member_name'];
  6.         $tbl_member_contact = $_POST['tbl_member_contact'];
  7.         $insert = mysql_query("insert into tbl_member (tbl_member_name, tbl_member_contact, tbl_member_added) values ('$tbl_member_name', '$tbl_member_contact', NOW())");
  8.         header('location:index.php');
  9.  
  10.         // if($insert)
  11.         // {
  12.         //      echo "<script>alert('User has been added'); window.location='index.php'</script>";
  13.         // }
  14.  
  15.         }
  16. ?>
This query use to delete data it's either in one or multiple data to be deleted in the database.
  1. if(isset($_POST['delete']))
  2. {
  3. $check = $_POST['check'];
  4. $count = count($check);
  5. for($i=0;$i<$count;$i++){
  6. $delete_id = $check[$i];
  7. $delete = mysql_query("delete from tbl_member where tbl_member_id='$delete_id'") or die(mysql_error());
  8.  }
  9. if($delete)
  10. {
  11.         echo "<script>alert('User/s has been deleted'); window.location='index.php'</script>";
  12. }      
  13. }
  14. ?>

Output

Result For the full source code, kindly click the "Download Code" button below. Thank you.
Tags
multiple delete data
multiple select data to delete
Multiple Delete
PHP/MySQL
multiple delete data using pdo query

Add new comment

About text formats
  • 162 views