Jump to content

Archived

This topic is now archived and is closed to further replies.

andygt

Update multiple records from one submit

Recommended Posts

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

[code]
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
)[/code]

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

[code]<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>[/code]

Many thanks in advance for any help

Andy

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.