PHP Mysql-Deleting multiple records using checkbox

Sometimes we have to delete multiple records at once. There is various method to delete multiple records at once. Here I am going to show a very simple method using checkbox to delete multiple records. I hope it will help you.

First create a database, here I am goint to create a database called test.

CREATE DATABASE `test` ;

Now create a table to insert data.

CREATE TABLE `test`.`tbluser` (

  `userid` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

  `name` VARCHAR( 100 ) NOT NULL ,

  `address` VARCHAR( 100 ) NOT NULL ,

  `contactno` INT( 7 ) NOT NULL ,

  `email` VARCHAR( 100 ) NOT NULL ,

  `remarks` TEXT NOT NULL 

) ENGINE = MYISAM

OK Now write your connection string to connect with mysql database:

<?php

$dbhost="localhost";

$dbuser="yourdbusername";

$dbpass="yourdbpassword";

$dbname="test";

mysql_connect("$dbhost","$dbuser","$dbpass") or die('Could not connect');

mysql_select_db($dbname);

?>

Now create a form and display all data and use a checkbox having value of userid.

Here I will pass value in array using checkbox

<input name=”checkbox[]” type=”checkbox” id=”checkbox[]” value=”<? echo $row['userid']; ?>”>

Now insert submit button for delete records

<input name=”delete” type=”submit” id=”delete” value=”Delete Records”>

Using For loop find the selected checkbox and delete records

<?

Check if Delete button was posted

if($_POST['delete']){

Check for posted checkboxes

$checkbox=$_POST['checkbox'];

Using the for loop find the checkboxes which are selected

for($i=0;$i<count($checkbox);$i++){

Pass the Value in $del_id variable

$del_id = $checkbox[$i];

Now Delete records from table

$sql = “DELETE FROM tbluser WHERE userid=’$del_id’”;

$result = mysql_query($sql);

}

And now refres the page

if($result){

echo “<meta http-equiv=\”refresh\” content=\”0;URL=deletemultiplerecords.php\”>”;

}

}

?>

Complete Code:

<?php
 $dbhost="localhost";
   $dbuser="yourdbuserid";
   $dbpass="yourdbpassword";
   $dbname="test";
mysql_connect("$dbhost","$dbuser","$dbpass") or die('Could not connect');
mysql_select_db($dbname);
?>
<form name="form1" method="post" action="">
<table width="918" border="0">
<tr>
<td>SNO</td>
<td>Name</td>
<td>Address</td>
<td>Contact No</td>
<td>Email</td>
<td>Remarks</td>
<td>Select</td>
</tr>
<?php

  $query="SELECT * FROM tbluser";

  $result=mysql_query($query);

  $sno=1;

  while($row=mysql_fetch_array($result, MYSQL_ASSOC)){

  ?>
<tr>
<td><? echo $sno;?></td>
<td><? echo $row['name'];?></td>
<td><? echo $row['address'];?></td>
<td><? echo $row['contactno'];?></td>
<td><? echo $row['email'];?></td>
<td><? echo $row['remarks'];?></td>
<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['userid']; ?>"></td>
</tr>
<?

  $sno=$sno+1;

  }

  ?>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td colspan="2"><div align="center">
<input name="delete" type="submit" id="delete" value="Delete Records">
</div></td>
</tr>
</table>
<?

  if($_POST['delete']){

  //print_r($_POST);

  $checkbox=$_POST['checkbox'];

  //exit;

  for($i=0;$i<count($checkbox);$i++){

  $del_id = $checkbox[$i];

  $sql = "DELETE FROM tbluser WHERE userid='$del_id'";

  $result = mysql_query($sql);

  }

  // if successful redirect to delete_multiple.php

  if($result){

  echo "<meta http-equiv=\"refresh\" content=\"0;URL=deletemultiplerecords.php\">";

  }

  }

  ?>
</form>

Download Zip Here

Related Articles

• Delete Multiple Records Using Checkbox With Select All Buttons
• PHP Mysql own CMS system Tutorial
• PHP Array Functions
• 10 Simple PHP Login Sytem Tutorial
• CSS style for CMS system