Delete record from table using Checkbox [duplicate]

Question

Possible Duplicate:
Deleing Multiple Rows Using Checkboxes, PHP and MySQL

I wonder whether someone may be able to help me please.

I'm trying to put together a script which creates a form which gives the user the ability to delete a record via the selection of a checkbox and then pressing a 'submit' button.

From reading through many articles, I've put together the following script which is the section of code that builds the table, checkboxes and submit button.

 <?php

$query = "SELECT  l.*, COUNT(f.locationid) totalfinds FROM detectinglocations l LEFT JOIN finds f ON f.locationid = l.locationid WHERE l.userid = '$idnum' GROUP BY l.locationname";

$result=mysql_query($query);

$count=mysql_num_rows($result);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="del" id="del" action="deletelocation.php" method="post">
<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>
<td align="center" bgcolor="#FFFFFF"><strong>Email</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['locationid']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['locationid']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['locationname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['returnedaddress']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['totalfinds']; ?></td>
</tr>

<?php
}
?>

<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input type="submit" value="Delete" /></td>
</tr>
</table>
</form>
</td>
</tr>
</table>

The code below, then deals with the deletion of the record.

<?php

$del_id = $_POST['checkbox']; 

for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $detectinglocations WHERE locationid='$del_id'";
$result = mysql_query($sql);
}


?>

The correct information is retrieved and shown in the form table, but the problem I'm having is that I'm unable to get the deletion of the record to work. I've run this through JavaScript Console, but unfortunately I don't receive an error message which may help me to solve the problem.

I just wondered whether someone could possibly take a look at this please and let me know where I'm going wrong.

Where do you define $detectinglocations? What do you get if you echo out $sql and run it right in the database? — andrewsi
– andrewsi, Commented Sep 23, 2012 at 15:09
Too many questions already exist about that: stackoverflow.com/questions/10145717/… stackoverflow.com/questions/9239648/… stackoverflow.com/questions/8870741/… stackoverflow.com/questions/1296149/… stackoverflow.com/questions/8529005/… stackoverflow.com/questions/8522070/… — Jocelyn
– Jocelyn, Commented Sep 23, 2012 at 15:14
Hi @andrewsi, thank your for replying to my post so quickly. 'detectinglocations is my table name, and from the articles I've read I didn't see anywhere that defined the table. I am however relatively new to this, so maybe this is the problem. If I take out the 'sql' line. There is no change the initial error. Kind regards — IRHM
– IRHM, Commented Sep 23, 2012 at 15:14
@IRHM - detectinglocations and $detectinglocations are not the same. Try removing the $ from your DELETE query and try again? — andrewsi
– andrewsi, Commented Sep 23, 2012 at 15:16
Hi thank you for your reply. I've managed to get this to work using @GBD solution. All the best and kind regards — IRHM
– IRHM, Commented Sep 23, 2012 at 15:18

GBD · Accepted Answer · 2012-09-23 15:13:39Z

0

Change your PHP code as below

$del_id = $_POST['checkbox']; 
$detectinglocations = 'your database table name';

foreach($del_id as $value){
   $sql = "DELETE FROM ".$detectinglocations." WHERE id='".$value."'";
   $result = mysql_query($sql);
}

answered Sep 23, 2012 at 15:13

GBD

16k2 gold badges49 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IRHM Over a year ago

Hi GBD, thank you very much for replying to my post and for the solution. This did the trick. Once again, many thanks and kind regards.

IRHM Over a year ago

Hi @GBD, it certainly wasn't me. I've cancelled this out. Perhaps it was the same person who down voted my question. When the time delay allows I'll accept the answer. Kind regards

Collectives™ on Stack Overflow

Delete record from table using Checkbox [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related