Updating multiple records

[zymurgy]

I have the following form -

echo "<form action=\"wishlist.php\" method=\"post\" target=\"_self\">"
."<table border=\"1\">"
."<tr>"
."<td>Date</td>"
."<td>Time</td>"
."<td>Name</td>"
."<td>Item</td>"
."<td>Item found?</td>"
."</tr>";
do {
echo "<tr>"
."<td><input name=\"id\" type=\"hidden\" value=".$row_wishlist['index'].">".$row_wishlist['dateentered']."</td>"
."<td>".$row_wishlist['timeentered']."</td>"
."<td>".$row_wishlist['name']."</td>"
."<td>".$row_wishlist['itemrequired']."</td>"
."<td>"; 
if ($row_wishlist['itemfound'] == "1"){
echo "<input name=\"itemfound\" type=\"checkbox\" value=\"true\" checked></td>";
}
else {
echo "<input name=\"itemfound\" type=\"checkbox\" value=\"false\"></td>";
}
echo "</tr>";
} while ($row_wishlist = mysql_fetch_assoc($result));
echo "</table>"
."<br>"
."found by - <input name=\"foundby\">"
."<input type=\"submit\" name=\"update\" value=\"Update records\">"
."</form>";

what happens is that the records are retrieved from the DB and displayed in a table.

What i want to happen is that the checkbox next to each record can be checked/unchecked and then updated by pressing the update button.

The problem is i am not sure of the code that will be required. I'm guessing that the form will need to by some sort of array that is iterated through until the end is reached. In the loop a check could be made against the value of the checkbox - if changed then updateing the DB, if not then moving to the next record.

Can anyone help with the code at all?

[Shrike]

The big problem here is that you have want to update x number of records with one form submission, and there's nothing concrete linking the hidden field (the identifier) to the checkbox (the value portion). You could change the name of the checkbox to be

$row_wishlist['index'];

On form submission do

foreach($_POST as $key => $value){
  if($value == 1){
    $sql = "UPDATE table SET itemfound  = 1 WHERE index = $key";
  }
}

This could get a little messy if you are submitting more that just the checkboxes in the form.

I usually have a list of records as a basic HTML table, which each record having a link to an edit form which just edits that one record. Alot easier 🙂