Checkboxes

I am having trouble saving data from checkboxes.

I have tried the following combinations. Neither works (Ie. They don’t save the updated value.

<input <?php if (!(strcmp(($rsDecision->getColumnVal("ebird_full_review")),1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="ebird_full_review" value="1" id="ebird_full_review" />

$UpdateQuery->bindColumn("ebird_full_review", "c", "".((isset($_POST["Review"]))?$_POST["Review"]:"") ."", "WA_DEFAULT");



<input name="review" type="checkbox" id="review" value="<?php echo($rsDecision->getColumnVal("ebird_full_review")); ?>">


$UpdateQuery->bindColumn("ebird_full_review", "c", "".((isset($_POST["review"]))?$_POST["review"]:"") ."", "WA_DEFAULT");

I also tried "y" and "i".


What am I doing wrong?

The value referenced in the $_POST needs to match the form element name on the page. Your checkbox is named "ebird_full_review", but you are updating with the value from "Review"

I fixed the element name problem, but it still doesn't work.

On the Bindings page of the update wizard, I tried all of the data types (Integer, all three checkbox options), and none of them worked.

Please attach a copy of the page so I can take a look and try to figure out what is wrong.

Here is the file.

You have your checkbox html set to:

<input name="ebird_full_review" type="checkbox" id="ebird_full_review" value="<?php echo($rsDecision->getColumnVal("ebird_full_review")); ?>">

By setting the value to the current value in the database, all it can do is set the value to the value it already has when checked. The code should be:

<input name="ebird_full_review" type="checkbox" id="ebird_full_review" value="1" <?php echo($rsDecision->getColumnVal("ebird_full_review")?"checked":""); ?> >

That saves the changes, but when I reload the page, the checkbox remains unchecked regardless of the value of the data.

If I display that same field elsewhere on the page as a text box, the correct value shows.

It looks like I had a typo in the code... an extra quote at the end. I've removed it in the example above. Please try again and let me know.

That fixed it.

Thanks