How do you change the checkbox setting with PHP?

keelbolt

I am building a website for my Morris side, and they want to have a page where each member can indicate his availability for various events. I have built a trial page using checkboxes in a grid against each member and each event. The trial page is at: http://www.chalicemorris.org/availability.php

Using Form Tools (if it will work with over 300 fields) I can pass the checked boxes to a mysql database on submit. This I can do myself as I've done similar things many times (again, if I can get Form Tools to work with this number of checkbox fields).

However, I then want a php script that will read the database and pass the new checkbox settings back to the page so that the next member who logs on will see the changed ticks indicating the availability that previous members have submitted. I can't find the php code to change the status of each checkbox field and I'm stuck on how to do this. As php will do most things, I'm sure it can do this.

I'd also like the php script to change the background colour of each table cell where a checkbox field has been changed, so that it is clear to the person submitting his availability that his data has been recorded. Again, how do I get php to do this?

Can anyone help me out with this, or do you know a better way of doing things? I don't do Java, but I can do very, very simple php (like in CSS sheets, etc).

bradgrafelman

How is the HTML for the checkboxes built? Dynamically? If so, it's a simple matter of checking whether or not the data in MySQL indicates that the user had selected box and, if so, echo checked="checked" inside the <input> HTML tag.

If you're building the table dynamically, you could do the same with the <td> tag for each cell; if the data indicates that the box was last checked, output some sort of style/class for that cell.

coldwerturkey

when dealing with checkbox values, a lot of people have found this very helpfuly:

//On form; checkbox option
echo "<input name='chbx' value='1' type='checkbox' CHECKED>";



//After submition , find value of chbx for database: 1=chked, 0=unchked
$value = (isset($_POST['chbx']) && $_POST['chbx'] == '1')? 1 : 0; 
//update users record w/ $value



//Retrieving from database, find if chbx is checked for redisplaying original sumbission
$ckd = (isset($row['chbx']) && $row['chbx'] == '1')? "CHECKED" : ""; 
echo "<input name='chbx' value='1' type='checkbox' {$chk}>";