1. PHP
  2. How To Make Delete Multiple Rows Using PHP

How To Make Delete Multiple Rows Using PHP

Submitted by alpha_luna on Friday, July 31, 2015 - 14:21.
Language
PHP

Good Day!!!

In this tutorial, we are going to learn on How To Make Delete Multiple Rows Using PHP. The features of this project is to add a data then, delete multiple data using check box as our selector. Hope you find this useful.

Directions:

For Javascript - Select All Rows
  1. <script language="JavaScript">
  2. function sel(source)
  3. {
  4. checkboxes = document.getElementsByName('check[]');
  5. for(var i in checkboxes)
  6. checkboxes[i].checked = source.checked;
  7. }
  8. </script>
For PHP - Add Data
  1. if(isset($_POST['submit']))
  2. {
  3.  $userid=$_POST['userid'];
  4.  $name=$_POST['name'];
  5.  $username=$_POST['username'];
  6.  $email=$_POST['email'];
  7.  $address=$_POST['address'];
  8.  $id1 = $_SERVER['REMOTE_ADDR'];
  9.  $insert=mysql_query("insert into user (userid,name,username,email,address) values ('$userid','$name','$username','$email','$address')");
  10.  if($insert)
  11.  {
  12.         echo "<script>alert('User has been added'); window.location='index.php'</script>";
  13.  }
  14.  
  15. }
For PHP - Delete Multiple Rows of Data
  1. if(isset($_POST['delete']))
  2. {
  3. $check=$_POST['check'];
  4. $count=count($check);
  5. for($i=0;$i<$count;$i++){
  6. $del_id = $check[$i];
  7. $delete=mysql_query("delete from user where id='$del_id'") or die(mysql_error());
  8.  }
  9. if($delete)
  10. {
  11.         echo "<script>alert('User has been deleted'); window.location='index.php'</script>";
  12. }
  13.        
  14. }
Full Source Code
  1. <!DOCTYPE html>
  4. <title>Delete Multiple Rows</title>
  5. <script language="JavaScript">
  6. function sel(source)
  7. {
  8. checkboxes = document.getElementsByName('check[]');
  9. for(var i in checkboxes)
  10. checkboxes[i].checked = source.checked;
  11. }
  13. <style type="text/css">
  14. body {
  15.         width:100%;
  16.         font-family:"Trebuchet MS";
  17.         margin:0;
  18.         padding:0;
  19. }
  20.  
  21. h2 a {
  22.         text-decoration:none;
  23.         color:#06F;
  24. }
  25.  
  26. #container {
  27.         width:800px;
  28.         margin:0 auto;
  29.         margin-top:30px;
  30. }
  32. </head>
  34.  
  35. <?php
  36. $db = mysql_connect('localhost','root','') or die ("Unable to connect to Database Server.");
  37. mysql_select_db ('demo', $db) or die ("Could not select database.");
  38. if(isset($_POST['submit']))
  39. {
  40. $userid=$_POST['userid'];
  41. $name=$_POST['name'];
  42. $username=$_POST['username'];
  43. $email=$_POST['email'];
  44. $address=$_POST['address'];
  45. $id1 = $_SERVER['REMOTE_ADDR'];
  46. $insert=mysql_query("insert into user (userid,name,username,email,address) values ('$userid','$name','$username','$email','$address')");
  47. if($insert)
  48. {
  49.         echo "<script>alert('User has been added'); window.location='index.php'</script>";
  50.  }
  51.  
  52. }
  53. if(isset($_POST['delete']))
  54. {
  55. $check=$_POST['check'];
  56. $count=count($check);
  57. for($i=0;$i<$count;$i++){
  58. $del_id = $check[$i];
  59. $delete=mysql_query("delete from user where id='$del_id'") or die(mysql_error());
  60. }
  61. if($delete)
  62. {
  63.         echo "<script>alert('User has been deleted'); window.location='index.php'</script>";
  64. }
  65.        
  66. }
  67. ?>
  68.  
  69.  
  70. <form method="post" name="form" action="">
  71. <table border="1" style="border:4px groove #CCC; float:left; margin-left:80px;" cellpadding="4" cellspacing="4">
  72.         <tbody>
  73.                 <tr>
  74.                         <td colspan="2" style="text-align:center; font-weight:bold;">Add User</td>
  75.                 </tr>
  76.                 <tr>
  77.                         <td>
  78.                                 <span style="color:blue;">User ID</span>
  79.                         </td>
  80.                         <td>
  81.                                 <input name="userid" style="font-size:15px;" placeholder="User ID..." type="text" id="userid" required />
  82.                         </td>
  83.                 </tr>
  84.                 <tr>
  85.                         <td>
  86.                                 <span style="color:blue;">Name</span>
  87.                         </td>
  88.                         <td>
  89.                                 <input name="name" style="font-size:15px;" placeholder="Name..." type="text" id="name" required />
  90.                         </td>
  91.                 </tr>
  92.                 <tr>
  93.                         <td>
  94.                                 <span style="color:blue;">Username</span>
  95.                         </td>
  96.                         <td>
  97.                                 <input name="username" type="text" style="font-size:15px;" placeholder="Username..." id="username" required />
  98.                         </td>
  99.                 </tr>
  100.                 <tr>
  101.                         <td>
  102.                                 <span style="color:blue;">Email</span>
  103.                         </td>
  104.                         <td>
  105.                                 <input name="email" type="email" style="font-size:15px;" placeholder="Email..." id="email" required />
  106.                         </td>
  107.                 </tr>
  108.                 <tr>
  109.                         <td>
  110.                                 <span style="color:blue;">Address</span>
  111.                         </td>
  112.                         <td>
  113.                                 <input name="address" style="font-size:15px;" placeholder="Address..." type="text" id="address" required />
  114.                         </td>
  115.                 </tr>
  116.                 <tr>
  117.                         <td align="center" colspan="2">
  118.                                 <input type="submit" style="color:#fff; background-color:#CCC; border:2px groove chocolate; border-radius:4px; font-size:15px;" name="submit" value="Add Employee" id="submit" />
  119.                         </td>
  120.                 </tr>
  121.         </tbody>
  123. </form>
  124.  
  125. <!---Viewing-->
  126. <form method="post">
  127.         <table border="1" style="border:4px groove #CCC; float:right; margin-right:80px;" cellpadding="0" cellspacing="0"  id="container">
  128.                 <tr align="center">
  129.                         <td>
  130.                                 <input type="checkbox"  onClick="return sel(this);"/>&nbsp;&nbsp;&nbsp;<span>Select All</span>
  131.                         </td>
  132.                         <td>
  133.                                 <strong>User ID</strong>
  134.                         </td>
  135.                         <td>
  136.                                 <strong>Name</strong>
  137.                         </td>
  138.                         <td>
  139.                                 <strong>Username</strong>
  140.                         </td>
  141.                         <td>
  142.                                 <strong>Email</strong>
  143.                         </td>
  144.                         <td>
  145.                                 <strong>Address</strong>
  146.                         </td>
  147.                 </tr>
  148.        
  149. <?php
  150. $id1 = $_SERVER['REMOTE_ADDR'];
  151. $result=mysql_query("select * from user order by id ASC ") or die(mysql_error());
  152. while($user_info=mysql_fetch_array($result)){
  153. ?>
  154.        
  155.                 <tr align="center">
  156.                         <td>
  157.                                 <input type="checkbox" name="check[]"  value="<?php echo $user_info['id']; ?>" id="all" />
  158.                         </td>
  159.                         <td>
  160.                                 <?php echo $user_info['userid']; ?>
  161.                         </td>
  162.                         <td>
  163.                                 <?php echo $user_info['name']; ?>
  164.                         </td>
  165.                         <td>
  166.                                 <?php echo $user_info['username']; ?>
  167.                         </td>
  168.                         <td>
  169.                                 <?php echo $user_info['email']; ?>
  170.                         </td>
  171.                         <td>
  172.                                 <?php echo $user_info['address']; ?>
  173.                         </td>
  174.                 </tr>
  175. <?php } ?>
  176.                 <tr>
  177.                         <td colspan="6">
  178.                                 <p align="center">
  179.                                         <input type="submit" style="color:#fff; background-color:#CCC; border:2px groove chocolate; border-radius:4px; font-size:15px;" name="delete" value="Delete" />
  180.                                 </p>
  181.                         </td>
  182.                 </tr>
  183.        
  184.         </table>
  185.        
  186.        
  187. </form>
  188.  
  189.  
  190. </body>
  191. </html>
So what can you say about this work? Share your thoughts in the comment section below or email me at [email protected]. Practice Coding. Thank you.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Tags
Delete
delete multiple data from database using php
Multiple Delete
multiple delete data
php

Comments

Submitted by temperator on Wed, 02/03/2016 - 02:39

how to do to be able to add a rar file that you can download in the table and how to do to be able to add one picture któro would wyświetlało also in the table.

Submitted by temperator on Wed, 02/03/2016 - 02:52

I mean something like this photo Please help in obtaining effect Regards

Add new comment

About text formats