Display All Records with Checkbox

[Dysan]

Hi.

 

I have the following code, that displays records in my database.

How do I display each record along with a checkbox, then when a delete button is clicked, delete the selected records?

 

mysql_select_db("my_db", $con);

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

while($row = mysql_fetch_array($result))
{
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
}

[pocobueno1388]

<?php

if (isset($_POST['submit'])){
   foreach ($_POST['delete'] as $id){
      $query = "DELETE FROM person WHERE personID='$id'";
      $result = mysql_query($query)or die(mysql_error());
   }
   
   echo "Records Deleted<p>";
}
   

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

echo "<form action='{$_SERVER['PHP_SELF']}' method='post'>";
while($row = mysql_fetch_array($result)){
  echo "<input type='submit' name='delete[]' value='{$row['personID']}'> ";
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
}
echo '<input type="submit" name="submit" value="Delete Records">';
echo '</form>';

?>

 

Wherever you see the row "personID" is where you need to replace that with whatever your unique ID is for that table.

[bwochinski]

If you're deleting a lot of records better to do one query...

 

$query = "DELETE FROM person WHERE personID=(".implode(",",$_POST['delete']).")";

[Dysan]

So you mean do this?

 

<?php

if (isset($_POST['submit'])){
   foreach ($_POST['delete'] as $id){
      $query = "DELETE FROM person WHERE personID=(".implode(",",$_POST['delete']).")";
      $result = mysql_query($query)or die(mysql_error());
   }
   
   echo "Records Deleted<p>";
}
   

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

echo "<form action='{$_SERVER['PHP_SELF']}' method='post'>";
while($row = mysql_fetch_array($result)){
  echo "<input type='submit' name='delete[]' value='{$row['personID']}'> ";
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
}
echo '<input type="submit" name="submit" value="Delete Records">';
echo '</form>';

?>