Jump to content


Photo

Update multiple records from one submit


  • Please log in to reply
No replies to this topic

#1 andygt

andygt
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 June 2006 - 12:33 AM

Hi,

I have a table that displays a list of records. Each row represents an individual record in the database.

The end user will have the ability to check a series of boxes for any of the records and then submit the data back to the database. This will then update all the records.

My problem lies in creating a multidimensional array for the form. Right now if I print out the POSTed array I see

Array
(
    [recid] => Array
        (
            [0] => 5137
            [1] => 4623
            [2] => 6694
            [3] => 6505
            [4] => 6364
            [5] => 2677
        )

    [WebKickoffCheck] => Array
        (
            [0] => 1
            [1] => 1
            [2] => 1
        )
    [Submit] => Submit
)

How can I get this to be a multidimensional array so that I can use a foreach to then loop through each table row and post the data back to the database? Right now I have several different arrays that I would much rather loop through once than write separate loops for.

The form is below

<table>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" name="Overview">
$countRows = 0;
foreach ($projectList as $value) {
echo "<tr> \n
<td>";
echo '<input name="recid['.$countRows.']" type="hidden" value="'.$value[10].'" />';
?>
<input <?php if (!(strcmp($value[3],1))) {echo "checked=\"checked\"";} ?> name='WebKickoffCheck[<?php echo $countRows; ?>]' type='checkbox' value='1' >

...rest of fields
</td>
</tr>
</form>
</table>

Many thanks in advance for any help

Andy




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users