[RESOLVED] Problems with checkboxes

em_123

Hello, just wondered if anyone could help please? I am new to php and I am trying to update by database so that if any check boxes are checked then update to 'yes' and any check boxes that were not checked to be updated to 'no'. My code for creating the check boxes is:

print "<td align = \"CENTER\" bgcolor=\"$color\">" . "<input type=\"checkbox\"  name=\"fchk1[]\"  value=\"$doc_no\" echo '$checked' >

and my code for the action page is:

if(isset($_POST['update'])) {
$fchk1=$_POST['fchk1'];
if (is_array($fchk1)){
      foreach ($fchk1 as $doc_no){
        $update_query = "UPDATE uploads u SET u.saccess = 'yes' WHERE  u.doc_no = '$doc_no'";
        $result = $db->query($update_query);
        //$db->disconnect();
        header("Location: main.php?target=docs&type=h");
            }
   }
else {

   $update_query = "UPDATE uploads SET saccess = 'no'";
   $result = $db->query($update_query);
   //$db->disconnect();
   header("Location: main.php?target=docs&type=h");
}
}

the checked part works fine, but the unchecked part does not work unless there is no checked boxes. Is what i am trying to do even possible? any help would be really appreciated.

Thank you Emma

coldwerturkey

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


//After form, find value of chbx for database. 1=checked, 0=unchecked
$value = (isset($_POST['chbx']) && $_POST['chbx'] == '1')? 1 : 0; 


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

em_123

Thank you coldwerturkey,

I cant seem to get the code to work, when I check one box it checks them all, I think its because the value as been changed to '1' instead of '$doc_no' on the checkbox creation. 😕 any ideas?

em_123

Never mind i figured it out for myself now. All i had to do was turn all the checkboxes to 'no' before looking at the checked boxes.

	$update_saccess = "UPDATE uploads u SET u.saccess = 'no'";
	$result = $db->query($update_saccess);

$fchk1=$_POST['fchk1'];
if (isset($fchk1)){
	foreach ($fchk1 as $doc_no){
		$update_query = "UPDATE uploads u SET u.saccess = 'yes' WHERE u.doc_no = '$doc_no'";
		$result1 = $db->query($update_query);
		header("Location: main.php?target=docs&type=h");

	}
}

Thank you anyways!