Update Not Working Correctly

For some reason if I uncheck a checkbox, it won't save that it is now unchecked. But, if there is a checkbox group, it will remember that it is unchecked as long as there is one checked. Here is my code:

<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$UpdateQuery = new WA_MySQLi_Query($sdpc_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "`data`";
$UpdateQuery->bindColumn("districtID", "i", "".((isset($_POST["districtID"]))?$_POST["districtID"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("softwareID", "i", "".((isset($_POST["softwareID"]))?$_POST["softwareID"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("agreement_typesID", "i", "".((isset($_POST["agreement_typesID"]))?$_POST["agreement_typesID"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("agreement_file", "s", "".(((isset($_FILES["agreement_file"]))? preg_replace('/.[^.]*$/', '', $_FILES["agreement_file"]["name"]) :"")) ."", "WA_IGNORE");
$UpdateQuery->bindColumn("signed_agreement_file", "s", "".(((isset($_FILES["signed_agreement_file"]))? preg_replace('/.[^.]*$/', '', $_FILES["signed_agreement_file"]["name"]) :"")) ."", "WA_IGNORE");
$UpdateQuery->bindColumn("statusID", "i", "".((isset($_POST["statusID"]))?$_POST["statusID"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("date_approved", "t", "".((isset($_POST["date_approved"]))?$_POST["date_approved"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("date_expired", "t", "".((isset($_POST["date_expired"]))?$_POST["date_expired"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("requestor", "s", "".((isset($_POST["requestor"]))?$_POST["requestor"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("requestor_email", "s", "".((isset($_POST["requestor_email"]))?$_POST["requestor_email"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("school", "s", "".((isset($_POST["school"]))?implode(", ",$_POST["school"]):"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("year", "s", "".((isset($_POST["year"]))?$_POST["year"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("grade_level", "s", "".((isset($_POST["grade_level"]))?implode(", ",$_POST["grade_level"]):"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("content_area", "s", "".((isset($_POST["content_area"]))?implode(", ",$_POST["content_area"]):"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("cost", "s", "".((isset($_POST["cost"]))?$_POST["cost"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("paid_by", "s", "".((isset($_POST["paid_by"]))?$_POST["paid_by"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("media_release", "s", "".((isset($_POST["media_release"]))?$_POST["media_release"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("declined_reasoning", "s", "".((isset($_POST["declined_reasoning"]))?$_POST["declined_reasoning"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("notes", "s", "".((isset($_POST["notes"]))?$_POST["notes"]:"") ."", "WA_IGNORE");
$UpdateQuery->bindColumn("request_submitted_date", "t", "".((isset($_POST["request_submitted_date"]))?$_POST["request_submitted_date"]:"") ."", "WA_IGNORE");
$UpdateQuery->addFilter("dataID", "=", "i", "".($_GET['dataID']) ."");
$UpdateQuery->execute();
$UpdateGoTo = "manage_agreements.php?state=" . $_GET['state'] . "&districtID=" . $_GET['districtID'] . "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>

Checkbox code looks like this:

<input <?php if (!(strcmp($district_data->getColumnVal("media_release"),"Yes"))) {echo "checked=\"checked\"";} ?> name="media_release" type="checkbox" value="Yes" aria-label="Requires Media Release">

Thanks

You have the default value set to "ignore" for that field. That means that if no value is submitted, then the update for that column is ignored. If you set it to "null" or "blank" then it will set the value to null or blank when no value is submitted.

So, when someone enters a new value in the form field, I want it to update it to that form field but, if there is nothing entered in the form field, I want it to ignore that field and leave whatever is in the database for that field there. So, would that be Ignore, null, or blank?

That is ignore. So if you have a checkbox and set the checkbox value to "yes"... then when someone checks the box it gets set to "yes". If they uncheck the box then no value is submitted. If it is set to "ignore", then the database "yes" value remains.

The "ignore" option is really there for the password or hashed field values. You can't or wouldn't want to pre-fill the password field for security reasons, so you want to leave the old password when the field is left blank, but update it if someone enters a value.

Usually all other fields use "blank" or "null" to allow users to update and actually put in a blank value. You could also update the default to be a string like "No", so that if the value is blank (like an unchecked box) the string "No" is placed in that field.

This makes sense. I will try this. Thanks

Lisa

I made them all WA_NULL and now none of them are updating:

<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$UpdateQuery = new WA_MySQLi_Query($sdpc_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "`data`";
$UpdateQuery->bindColumn("districtID", "i", "".((isset($_POST["districtID"]))?$_POST["districtID"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("softwareID", "i", "".((isset($_POST["softwareID"]))?$_POST["softwareID"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("agreement_typesID", "i", "".((isset($_POST["agreement_typesID"]))?$_POST["agreement_typesID"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("agreement_file", "s", "".($WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"]) ."", "WA_IGNORE");
$UpdateQuery->bindColumn("signed_agreement_file", "s", "".($WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"]) ."", "WA_IGNORE");
$UpdateQuery->bindColumn("statusID", "i", "".((isset($_POST["statusID"]))?$_POST["statusID"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("date_approved", "t", "".((isset($_POST["date_approved"]))?$_POST["date_approved"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("date_expired", "t", "".((isset($_POST["date_expired"]))?$_POST["date_expired"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("requestor", "s", "".((isset($_POST["requestor"]))?$_POST["requestor"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("requestor_email", "s", "".((isset($_POST["requestor_email"]))?$_POST["requestor_email"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("school", "s", "".((isset($_POST["school"]))?implode(", ",$_POST["school"]):"") ."", "WA_NULL");
$UpdateQuery->bindColumn("year", "s", "".((isset($_POST["year"]))?$_POST["year"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("grade_level", "s", "".((isset($_POST["grade_level"]))?implode(", ",$_POST["grade_level"]):"") ."", "WA_NULL");
$UpdateQuery->bindColumn("content_area", "s", "".((isset($_POST["content_area"]))?implode(", ",$_POST["content_area"]):"") ."", "WA_NULL");
$UpdateQuery->bindColumn("cost", "s", "".((isset($_POST["cost"]))?$_POST["cost"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("paid_by", "s", "".((isset($_POST["paid_by"]))?$_POST["paid_by"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("media_release", "s", "".((isset($_POST["media_release"]))?$_POST["media_release"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("declined_reasoning", "s", "".((isset($_POST["declined_reasoning"]))?$_POST["declined_reasoning"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("notes", "s", "".((isset($_POST["notes"]))?$_POST["notes"]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("request_submitted_date", "t", "".((isset($_POST["request_submitted_date"]))?$_POST["request_submitted_date"]:"") ."", "WA_NULL");
$UpdateQuery->addFilter("dataID", "=", "i", "".($_GET['dataID']) ."");
$UpdateQuery->execute();
$UpdateGoTo = "manage_agreements.php?state=" . $_GET['state'] . "&districtID=" . $_GET['districtID'] . "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>

Does your database allow null values for all of those columns? It would fail if you try to set a null value to a column that doesn't allow null.

It is working now. Thanks