Deleting multiple records with checkboxes

[netfrugal]

Below is some code that deletes multiple records using checkboxes. It works, but I notice an error being reported in my server logs:

"Undefined offset: 1 in /var/www/html/............php on line 51"

this is line 51: $sql = "DELETE FROM $tbl_name WHERE queueID ='$del_id'";

Anyone know what this error is talking about?

<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['queueID']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['queueID']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['adminID']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['customer_id']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if(isset($_POST['delete'])){
for($i=0;$i<$count;$i++){
$del_id = $_POST['checkbox'][$i];
$sql = "DELETE FROM $tbl_name WHERE queueID ='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=xyz.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

[cahva]

Reason for the error is because when you submit the form, unchecked variables dont submit. Now in your for clause you are trying to set $del_id of $_POST['checkbox'][$i] which doesnt exist (if the user didnt check them all). And the deletion should be done right after mysql connection:

...
mysql_select_db("$db_name")or die("cannot select DB"); 

if(isset($_POST['delete'])){
   if (!empty($_POST['checkbox'])) {
      foreach($_POST['checkbox'] as $v) {
         $del_id = mysql_real_escape_string($v);
         $sql = "DELETE FROM $tbl_name WHERE queueID ='$del_id'";
         mysql_query($sql);
      }
   }
}

[bradgrafelman]

If you wanted to minimize overheard, you could also reduce this down to one single DELETE query:

$del_id_list = mysql_real_escape_string(implode(',', $_POST['checkbox']));

$sql = "DELETE FROM $tbl_name WHERE queueID IN ($del_id_list)";

[Awon]

Hello There

I come to know you about About Delete Multiple Records-Checkbox With Select All Button.

I have a url which can help you.

Click Here : http://www.raiseitsolutions.com/forum/viewtopic.php?f=5&t=122

I hope it is enough for you.

Thank You

AWON