checkboxes

[dast]

I just want to check whether a checkbox is checked and if it is add a record. I want to add a seperate record per checkbox. The folowing code is what I've got so far. Am i on the right track?

       foreach ( $HTTP_POST_VARS as $key => $val ) {
	   if (isset($key)) {
	   $sql = "INSERT INTO tblteam (employee_id, project_id) VALUES ('$key','$project_id')";
	   $result = pg_query($sql);
	   }
	   }

Any help would be great 🙂

[dast]

It seems like it should work but it doesnt actually add any records. What am i doing wrong?

[HalfaBee]

This code is going to do every POSTed var, even the submit button.
$key will always be set in the loop, because that is what the foreach does 🙂

Try putting
or pg_result_error( $result );

after the query to see if it is working.
You could also try pg_result_status() to see what is happening.

HalfaBee

[Threehearts]

Hi!
Checkboxes that arent checked usually dont send any data, not even themdselves.
so if $var_name_of_checkbox exists the box has been checked, so you could simply add all of them
unless you do something about the fact before the form is sent, of course.

example:
checkboxes chckbx_a, chckbx_b and chckbx_c are in a form, value is 1 for checked.
i check chckbx_a and chckbx_c

so in php if get
$POST['chckbx_a'] == true
$POST['chckbx_b'] == false
$_POST['chckbx_c'] == true

unless i set the value to '0' for chckbx_b with clientsided script.
in this case all 3 boxes exist, with a value of 1, 0 and 1 respectively.

greetings, jakob