Is there a way to do multiple updates without a checkbox?
I have a page that pulls in the dataID field in a hidden field based on url parameters to know which records to update. Then the user selects a progress status in the drop-down field. I need to update all the records already determined when they click the submit button.
I have this code but nothing happens:
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$MultipleUpdateConnection = $sdpc_i;
$MultipleUpdateTable = "data";
$MultipleUpdateRedirect = "progress_update_en_multiple.php?state=" . $_GET['state'] . "&districtID=" . $_GET['districtID'] . "&dataID=" . $_POST['dataID'] . "&progress_name=" . $_POST['progress'] . "";
$MultipleUpdateIndexColumn = "dataID";
$MultipleUpdateIndexColumnType = "d";
$MultipleUpdateIdentifier = "WADA_RepeatID_dataID";
for ($x=0; $x<sizeof($_POST[$MultipleUpdateIdentifier]); $x++) {
$MultipleUpdateCount = $_POST[$MultipleUpdateIdentifier][$x];
$UpdateQuery = new WA_MySQLi_Query($MultipleUpdateConnection);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = $MultipleUpdateTable;
$UpdateQuery->bindColumn("statusID", "1", "".((isset($_POST["statusID"."_".$MultipleUpdateCount]))?$_POST["statusID"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("last_modified_date", "t", "".((isset($_POST["last_modified_date"."_".$MultipleUpdateCount]))?$_POST["last_modified_date"."_".$MultipleUpdateCount]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("declined_reasoning", "s", "".((isset($_POST["declined_reasoning"."_".$MultipleUpdateCount]))?$_POST["declined_reasoning"."_".$MultipleUpdateCount]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("progress", "s", "".((isset($_POST["progress"."_".$MultipleUpdateCount]))?$_POST["progress"."_".$MultipleUpdateCount]:"") ."", "WA_NULL");
$UpdateQuery->addFilter($MultipleUpdateIndexColumn, "=", $MultipleUpdateIndexColumnType, $MultipleUpdateCount);
$UpdateQuery->execute();
}
if ($MultipleUpdateRedirect) {
if (function_exists("rel2abs")) $MultipleUpdateRedirect = rel2abs($MultipleUpdateRedirect,dirname(__FILE__));
header("location: " . $MultipleUpdateRedirect);
}
}
?>