Delete Selected/Checked

Dysan

The following PHP code, displays records contained inside a database, along with a check box for each one.

Upon a check box and delete button being clicked, how do I delete the selected records?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM person");

echo '<table border="1">
<tr>
<th><input type="checkbox" name="checkbox" value="checkbox"></th>
<th>First Name</th>
<th>Last Name</th>
</tr>';

while($row = mysql_fetch_array($result))
{
  echo '<tr>';
  echo '<td><input type="checkbox" name="checkbox" value="checkbox"></td>';
  echo '<td>'.$row['FirstName'].'</td>';
  echo '<td>'.$row['LastName'].'</td>';
  echo '</tr>';
}
echo '</table>';

mysql_close($con);
?>

bradgrafelman

Most common way to do this is to make the checkboxes submit as an array (e.g. add '[]' onto the end of their names, such as 'delete[]') and set their value equal to the rows' ID numbers (or whatever unique data you use to identify rows in your table).

Then, in your processing script, you'd simply verify that $_POST['delete'] is an array, and run a query such as:

$ids = array_map('mysql_real_escape_string',$_POST['delete'])
$query = 'DELETE FROM person WHERE id IN (' . implode(',',$ids) . ')';

Note that the above code assumes you used numeric numbers (e.g. an AUTO_INCREMENT column) to identify your rows.

EDIT: Also, you shouldn't use 'SELECT *' but instead only SELECT the column(s) you're actually going to need data from.

Dysan

How do I apply that to the code in my previous post, in order to delete records that have been selected, upon a delete button being clicked?