[RESOLVED] Posting checkboxes from Forms to an array in new page

adrian_melange

Hi there guys,

Can anyone advice what is missing or wrong in my statements from page1 to page2 becoz the values for the checkbox or hidden fields in an array from page1 doesnt get transferred.

page1

 
while ($line = mysql_fetch_array($result)) {
   $count++;
   echo "\t<tr>\n"; 
	{
       	echo "\t\t<td>$line[title] &nbsp;</td>\n";
       	echo "\t\t<td>$line[first_date] &nbsp;</td>\n";
       	echo "\t\t<td>$line[last_date] &nbsp;</td>\n";
       	echo "\t\t<td>$line[time] &nbsp;</td>\n";
       	echo "\t\t<td>$line[country] &nbsp;</td>\n";
       	echo "\t\t<td>$line[venue] &nbsp;</td>\n";
       	echo "\t\t<td><input type=\"checkbox\" name=\"array_course[$count]\"";
	if (trim($line[display_flag])==on)	// If Display Flag says Yes (On)
		{
		echo " checked=\"on\"";		// tick Checkbox
		}
	echo ">&nbsp;</td>\n";


   	echo "\t\t<td><a href=\"training_update.php?\">Update</a> &nbsp;<input type=\"text\" name=\"array_index_key[$count]\" value=\"$line[index_key]\"></td>\n";
   	echo "\t\t<td><a href=\"training_delete.php?\">Delete</a> &nbsp;</td>\n";
}
   echo "\t</tr>\n";
}

page2

$a= $_POST['array_index_key[0]']; 
$b = $_POST['array_index_key[1]']; 
echo $a;
echo "<br>" . $b

Kudose

Unless $count is initialized to -1, you will never get an array key of 0, you increment $count before it is ever used once.

Try this on page 2:

<?php
  $courses = $_POST['array_course'];
  $index_keys = $_POST['array_index_key'];
  echo '<pre>';
  print_r($courses); print_r($index_keys);
  echo '</pre>';
?>

adrian_melange

TQ Kudose 🙂

Here's my page2 code:


$count = $_POST['count'];

    for ($i = 1; $i <= $count; $i++) {
            $array_course = $HTTP_POST_VARS["array_course"];
$array_index_key = $HTTP_POST_VARS["array_index_key"];

	$query = "UPDATE training_workshops SET " .
	" display_flag = '$array_course[$i]' " .
	" WHERE index_key='$array_index_key[$i]'";

	$result = mysql_query($query) or die('Query failed: ' . mysql_error());

    }

Kudose

Try this instead, it's a little bit cleaner:

 $count = $_POST['count'];
$array_course = $_POST['array_course'];
$array_index_key = $_POST['array_index_key'];
        for ($i = 1; $i <= $count; $i++) {


    $query = "UPDATE training_workshops SET " .
    " display_flag = '$array_course[$i]' " .
    " WHERE index_key='$array_index_key[$i]'";

    $result = mysql_query($query) or die('Query failed: ' . mysql_error());

    }

Mainly because $HTTP_POST_VARS and $HTTP_GET_VARS have been depreciated and $POST and $GET are the replacement. Plus, there is no need to reset the array variables each loop.