Checkboxes and MySQL Assistance Needed

endurox

Lets say I have a form with 3 checkboxes (valued 1, 2, 3 respectively along with today's date). On this form I have a save/submit button to save the inputted values into mysql database.

Once saved, I redisplay those checkboxes to the user by checking to see if they are checked within the database, if so, then I simply give them a "checked" status. Thus the user see's their saved values for those checkboxes.

All that is working fine. Now, I wish to see if the user:
a) hits the save button without changing anything, if so then just skip manipulating the database. This currently does not work because my form simply re-adds those fields just saved to the database. Hence a user can continue to add identical rows into my database. What code/theory should I use to check to see if identical data already exisits, if so just skip?

b) unchecks a field then saves the form again. If a value was previously saved, but now the user unchecks that checkbox. What code/theory should I use to remove that previously checked checkbox in the database? DEL FROM users WHERE chk = 'val';?

Any help would be much appreciated.

coldwerturkey

endurox;10906766 wrote:
a) hits the save button without changing anything, if so then just skip manipulating the database. This currently does not work because my form simply re-adds those fields just saved to the database. Hence a user can continue to add identical rows into my database. What code/theory should I use to check to see if identical data already exisits, if so just skip?

b) unchecks a field then saves the form again. If a value was previously saved, but now the user unchecks that checkbox. What code/theory should I use to remove that previously checked checkbox in the database? DEL FROM users WHERE chk = 'val';?

If a row in your table looks like

userid | value_of_1 | value_of_2 | value_of_3

Then just UPDATE the row instead of inserting a new one for that user.. so you don't get the same user values for a user. If one is unchecked, the update will change it's checked value.

//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}>";

endurox

thank you!