如何在POST中发送多个复选框检查以从数据库中删除？

Question

I've been trying think of a way to do this. I want it to where users can check off items, hit submit and it goes to the code on the next page and deletes all of the checked items from the database. Problem one is that in the post its only sending over the last checked item. Here is how I have it set up right now.

echo "<form name='fm1' METHOD ='POST' ACTION ='displaydelete.php' > ";

//Draws up the table headers echo ""; echo ""; echo "Fund Number "; echo "Hours "; echo "Percentage"; echo "Delete"; echo ""; //While there are query results data is pushed into table cells while ($row = mysql_fetch_array($queryResult2)) { $hours = $row['hours']; $percentage = $hours / 160 * 100;

   echo "<tr>";
    echo "<td>";
    echo $row['funnumber'];
    echo "</td>";
    echo "<td>";
    echo $hours;
    echo "</td>";
    echo "<td>";
    echo $percentage ."%";
    echo "</td>";
    echo "<td>";
   echo "<input type='checkbox' name='id' value='$row[id]'/>";
  echo "</td>";
    echo "</tr>";




}
    //End of tabel 
echo "</table>";

echo" "; echo "";

What I would like to do is push all of the items into a variable and maybe delete them that way. I'm not really sure how you would handle multiple deletes. I'm doing my delete like this for something else if this helps any.

 $query = "DELETE FROM users

WHERE ninenumber = '$ninenumber'"; $result = mysql_query($query) or die("Query Failed: " .mysql_error());

        mysql_close($conn);

Answer 1

Instead of this:

echo "<input type='checkbox' name='id' value='$row[id]'/>";

You need this:

echo "<input type='checkbox' name='id[]' value='$row[id]'/>";

Note the difference. I added [] after the input name. This tells the client and server that there are multiple inputs with that name. $_POST['id'] will be an array you can loop through on the next page.

foreach ($_POST['id'] as $checkbox) {
    // DELETE FROM users WHERE ninenumber = $checkbox
}

isset, is_array, and mysql_real_escape_string omitted for brevity.