[arcuivie]

I'm trying to create sort of a CP for myself where I can update multiple table values through POST data. Basically I have a table on the page that displays all the information pulled from the table I'm editing, and each field is within an form input text box. Looks like this:

PHP Code:

    while ($part = mysql_fetch_assoc($result2))

    {

$part_list .= "</tr><tr><td><input type=\"text\" name=\"apt\" size=\"5\" class=\"one\" value=\"" . $part['apt'] . "\" /></td><td><input type=\"text\" name=\"apt_type\" size=\"15\" class=\"one\" value=\"" . $part['apt_type'] . "\" /></td><td width=\"350\"><input type=\"text\" name=\"descript\" size=\"60\" class=\"one\" value=\"". $part['descript'] ."\" /></td><td>". $part['reqdate'] ."</td><td>". $part['postdate'] ."</td><td><input type=\"text\" name=\"pending\" size=\"1\" class=\"one\" value=\"". $part['pending'] ."\" /></td><td><input type=\"text\" name=\"invno\" size=\"10\" class=\"one\" value=\"". $part['invno'] ."\" /></td><td><input type=\"text\" name=\"amount\" size=\"5\" class=\"one\" value=\"". $part['amount'] ."\" /></td><td id=\"two\"><a href=\"lib/wkdltprq.php?woid=" . $part['wo_id'] ."&type=delete\"><strong>Delete</strong></a></td></tr>";

} 

This is just a snippet of code to show you how it's set up. So, I send this data to another file, which contains:

PHP Code:

$property = $_GET['property'];

$invoiceno = form($_POST['invno']);

$pending = form($_POST['pending']);

$amount = form($_POST['amount']);

$apt = form($_POST['apt']);

$apt_type = form($_POST['apt_type']);

$description = form($_POST['descript']);



mysql_query("UPDATE `workorders` SET descript = '$description', invno = '$invoiceno', amount = '$amount', pending = '$pending' WHERE apt = '$apt' AND apt_type = '$apt_type'")

or die (mysql_error());

header ("Location: ../invmanagement.php"); 

This would work fine if there was only 1 form I was working with, but with the way I have it set up I have 1 form with multiple same-named values, if that makes any sense. Anyway, how can I change my code so I can mass update what data is displayed on the table? While retaining values that weren't changed, of course.

Thanks a bunch!

[DAL]

use form arrays by naming your form inputs with [] on the end and then this will populate the $_POST results as an array;

PHP Code:

while ($part = mysql_fetch_assoc($result2))
    {
$part_list .= "</tr><tr><td><input type=\"text\" name=\"apt[]\" size=\"5\" class=\"one\" value=\"" . $part['apt'] . "\" /></td><td><input type=\"text\" name=\"apt_type\" size=\"15\" class=\"one\" value=\"" . $part['apt_type'] . "\" /></td><td width=\"350\"><input type=\"text\" name=\"descript\" size=\"60\" class=\"one\" value=\"". $part['descript'] ."\" /></td><td>". $part['reqdate'] ."</td><td>". $part['postdate'] ."</td><td><input type=\"text\" name=\"pending\" size=\"1\" class=\"one\" value=\"". $part['pending'] ."\" /></td><td><input type=\"text\" name=\"invno\" size=\"10\" class=\"one\" value=\"". $part['invno'] ."\" /></td><td><input type=\"text\" name=\"amount\" size=\"5\" class=\"one\" value=\"". $part['amount'] ."\" /></td><td id=\"two\"><a href=\"lib/wkdltprq.php?woid=" . $part['wo_id'] ."&type=delete\"><strong>Delete</strong></a></td></tr>";
} 

[arcuivie]

Ah, thanks a bunch! Do I need to change anything within the mysql query? Or will it be able to pick and choose the way it is?

[DAL]

I think you would just need to experiment with the values, PHP does some neat tricks when working with this kind of thing as far as I've experienced but I would always check to see what values are coming through from what scenarios.

It's easy to check;

PHP Code:

echo $property = $_GET['property']."<br>";
echo $invoiceno = form($_POST['invno'])."<br>";
echo $pending = form($_POST['pending'])."<br>";
echo $amount = form($_POST['amount'])."<br>";
echo $apt = form($_POST['apt'])."<br>";

foreach($_POST['apt'] as $val){
     if($val != "") echo " -- ".$val."<br>";
}

echo $apt_type = form($_POST['apt_type'])."<br>";
echo $description = form($_POST['descript'])."<br>";

//oops forgot this;
echo $SQL_query = "UPDATE `workorders` SET descript = '$description', invno = '$invoiceno', amount = '$amount', pending = '$pending' WHERE apt = '$apt' AND apt_type = '$apt_type'";
// mysql_query($SQL_query) or die (mysql_error());
//header ("Location: ../invmanagement.php"); 

[arcuivie]

Thanks again DAL, this is going to help a lot.

[DAL]

no problem - best of luck

Cheers
Dal