$conn=mysql_connect("localhost","root","") or die(mysql_error()); [green]\\db connection[/green]
$db=mysql_select_db("test") or die(mysql_error()); [green]\\select DB[/green]
if(isset($_POST['update'])){ [green]\\check if fomr was submitted[/green]
$update=array(); [green]\\create array to hold required and un-required values[/green]
if(isset($_POST['required']['req_1'])){ [green]\\check which checkboxes were submitted, and and which were not, and create the array with the appropriate values for the update[/green]
$update['req1']='TRUE';
}
else{
$update['req1']='FALSE';
}
if(isset($_POST['required']['req_2'])){
$update['req2']='TRUE';
}
else{
$update['req2']='FALSE';
}
if(isset($_POST['required']['req_3'])){
$update['req3']='TRUE';
}
else{
$update['req3']='FALSE';
}
if(isset($_POST['required']['req_4'])){
$update['req4']='TRUE';
}
else{
$update['req4']='FALSE';
}
[green]\\you'll need to check for as many checkboxes as you have[/green]
$query2="UPDATE required SET req_1=$update[req1], req_2=$update[req2], req_3=$update[req3], req_4=$update[req4] WHERE id_user=2";
[green]\\build update query[/green]
if($res=mysql_query($query2)){
echo "Update Successfull";
} [green]\\Execute query[/green]
}
[green]\\ From here, we build the form to show the chekced and unchecked values from the DB[/green]
$query="Select * FROM required WHERE id_user=2";
$results=mysql_query($query) or die(mysql_error());
echo '<form action="word.php" method="POST">';
$var2="Test";
$i=0;
while($row=mysql_fetch_array($results)){
$values['ch1']=box_checker($row['req_1']);
$values['ch2']=box_checker($row['req_2']);
$values['ch3']=box_checker($row['req_3']);
$values['ch4']=box_checker($row['req_4']);
echo<<<EOE
User: $row[id_user] ---
<input type="checkbox" value="Required" name="required[req_1]" $values[ch1]>
<input type="checkbox" value="Required" name="required[req_2]" $values[ch2]>
<input type="checkbox" value="Required" name="required[req_3]" $values[ch3]>
<input type="checkbox" value="Required" name="required[req_4]" $values[ch4]>
<br>
EOE;
$i++;
}
echo "<input type=submit value='Update Requirements' name='update'></form>";