[RESOLVED] Delete Multiple record using checkbox

lyndonabing

hi to all..

can you please help me with this..:

this is the FORM:

<?php

while($rows=mysql_fetch_array($rs)){
$id = $rows['id'];
?>
<input type="checkbox" name="check[]" id="check" value="<?php echo $id;?>"

<?php }?>
<input type="delete" name="delete" id="delete" value="DELETE" />

this is the PROCESS:

<?php
if(isset($POST['delete']))
{
$checkbox = $POST['check'];
for($i=0;$i<=count($checkbox);$i++)
{
$query = "DELETE * FROM tbl_name WHERE id='$checkbox'";
$result = mysql_query($query,$conn);
}
}
?>

THEN: nothing happen..

i've search a lot of tutorial..but i doesnt work..

can anyone please help me about this..

thank you in advance..

🙂

bradgrafelman

That's because the index of $checkbox you want isn't "i", it's $i. I would also recommend concatenating that array piece:

$query = 'DELETE * FROM tbl_name WHERE id=' . $checkbox[i];

Also note that I removed the quotes around the value, since it's (presumably) a numeric value.

You should also be sanitizing user-supplied data with a function such as [man]mysql_real_escape_string/man before you ever use it in a query.

lyndonabing

$query = 'DELETE * FROM tbl_visual_photos WHERE id='.$checkbox[$i].'';

i tried this one..not yet happen..

or any script process could solve this problem brad..
its because i tried them the script they gave me same like this..
its doesnt work yet..

still the record not deleted..

foyer

I would add 'or die(mysql_error());' to the query. Maybe you can figure out why it's not deleting.

lyndonabing

yup thats true foyer.. i always put die(mysql_error()).. ok thank u.. ive don this problem..