Getting value of checkbox in form build from database

[StrangerInBeijing]

I got this page I want to use to edit records in the database. All text fields, and one bool (tinyint(1)) field to indicate whether the record is active or not.

I build up a table of records from the database like this:

<?php          	
	$count = $results->num_rows;	
	while($row = $results->fetch_object())  {  
?>
	<tr>
		<td>
    	<input type="hidden" name="_count" value="<?php echo $count ?>"/>  
			<input name="id[]" type="hidden" id="id" value="<?php echo $row->id; ?>" />
		</td>
		<td>
			<input name="lang_code[]" type="text" id="lang_code" value="<?php echo $row->lang_code; ?>" />
		</td>
		<td>
			<input name="name_en[]" type="text" id="name_en" value="<?php echo $row->name_en; ?>" />
		</td>
		<td>
			<input name="name_native[]" type="text" id="name_native" value="<?php echo $row->name_native; ?>" />
		</td>
		<td>
			<input type="checkbox" <?php if($row->active) echo "checked='checked'"; ?> value="<?php echo $row->active; ?>" name="active[]" id="active" />
		</td>      
	</tr>      
<?php }	?>

and at the top of the page run the following if the page was posted:

for($i=0;$i< $_POST['_count'];$i++){
  $id=$_POST[id][$i];
  $lang_code=$_POST[lang_code][$i];
  $name_en=$_POST[name_en][$i];
  $name_native=$_POST[name_native][$i];
  $active=$_POST[active][$i];
  update_language($id,$lang_code,$name_en,$name_native,$active);
}

Everything works fine, it's just I cannot get whether the check box ($active) was checked or not.

[penagate]

If the checkbox is checked then its `value` attribute is sent to the server.

<input type="checkbox" name="test" value="Bananas" />
...
<?php
  if (isset($_POST['test']) && $_POST['test'] == 'Bananas')
    # ...
?>

If it is not checked then its value is blank.

[StrangerInBeijing]

guess i'm doing sth wrong.
tried isset($_POST[active][$i]) without luck...will give it a break and check later. still asleep here

[penagate]

do

print_r($_POST) 

and see what is being sent.

[StrangerInBeijing]

I did the print_r($_POST) thing, and realized I don't see "active" in there.

Then did print_r($_POST[language_code]); and get the values as it should be send.

print_r($_POST[active]); returned nothing. So the array for the $active[] checkbox are not send.

So for text fields the following work fine, but not for checkbox. Can anyone think what is wrong with the following:

while($row = $results->fetch_object())  {  ?>
	<tr>
		<td>              
			<input name="id[]" type="hidden" id="id" value="<?php echo $row->id; ?>" />
		</td>
		<td>
			<input name="language_code[]" type="text" id="language_code" value="<?php echo $row->language_code; ?>" />
		</td>
		<td>
			<input name="language_english[]" type="text" id="language_english" value="<?php echo $row->language_english; ?>" />
		</td>
		<td>
			<input name="language_native[]" type="text" id="language_native" value="<?php echo $row->language_native; ?>" />
		</td>
		<td>
			<input type="checkbox" <?php if($row->active) echo("checked='checked'"); ?> name="active[]" id="active" value="1" />
		</td>      
	</tr>      
<?php }	?>

[manavo11]

If it is not checked, i think it doesn't get sent at all (not just a blank value). isset should return false.