[RESOLVED] Lost in array for checkboxes

[dmacman1962]

Hi All,

I did this before, but I am not getting it this time...

I have a form with checkboxes named GradeLevel[0] - GradeLevel[7]. As such...

<input name="GradeLevel[0]" type="checkbox" tabindex="5" value="Elementary"> 

On my process page I build an array...

// Check and see if they clicked on at least one Grade Taught
if(!isset($_POST['GradeLevel'])) { // You did not select any boxes
 	$_POST['GradeLevel'] = array();// Make it an array
    die("<p align='center'><font face='Arial' size='3' color='#FF0000'>You did not select a Grade Level Taught. <br>Please hit the back button and choose a Grade Taught.</font></p>");  // Go back
} else {
foreach ($_POST['GradeLevel'] as $grade) { //Set the elements in the array
	$GradeLevel8 = $grade[0];
	$GradeLevel9 = $grade[1];
	$GradeLevel10 = $grade[2];
	$GradeLevel11 = $grade[3];
	$GradeLevel12= $grade[4];
	$GrageLevel13 = $grade[5];
	$GrageLevel14 = $grade[6];
	$GradeLevel15 = $grade[7];
	echo '--'.$grade.'<br>'; // echo out the array values as  I go
   	 }
} 

And the echo above gives me...

--Elementary
--Grade 7
--Grade 8
--Grade 9
--Grade 10
--Grade 11
--Grade 12
--Post High School

But when I try to insert them into my db, I my fields I get.

GradeLevel0 ------ P
GradeLevel1 ------ o
GradeLevel2 ------ s
GradeLevel3 ------ t
GradeLevel4 ------
GradeLevel5 ------ H
GradeLevel6 ------ i
GradeLevel7 ------ g

Instead of ...

GradeLevel0 ------ Elementary
GradeLevel1 ------ Grade 7
GradeLevel2 ------ Grade 8
GradeLevel3 ------ Grade 9
GradeLevel4 ------ Grade 10
GradeLevel5 ------ Grade 11
GradeLevel6 ------ Grade 12
GradeLevel7 ------ Post High School

Here is my insert command...

$sql ="insert into birthday_club";
$sql .="(Title, FirstName, LastName, Position, School, SchoolAddress, City, State, Zip, SchoolEmailAddress, EmailAddress, Phone, Product, GradeLevel0, GradeLevel1, GradeLevel2, GradeLevel3, GradeLevel4, GradeLevel5, GradeLevel6, GradeLevel7, Date, Time, Processed)";
$sql .="values('$Title', '$FirstName', '$LastName', '$Position', '$School', '$SchoolAddress', '$City', '$State', '$Zip', '$SchoolEmailAddress', '$EmailAddress', '$Phone', '$Product', '$grade[0]', '$grade[1]', '$grade[2]', '$grade[3]', '$grade[4]', '$grade[5]', '$grade[6]', '$grade[7]', '$Date', '$Time', '$Processed')";

I cannot see my error.

Thanks in advance,

Don

[void_function]

Here:

foreach ($_POST['GradeLevel'] as $grade) { //Set the elements in the array
	$GradeLevel8 = $grade[0];
	$GradeLevel9 = $grade[1];
	$GradeLevel10 = $grade[2];
	$GradeLevel11 = $grade[3];
	$GradeLevel12= $grade[4];
	$GrageLevel13 = $grade[5];
	$GrageLevel14 = $grade[6];
	$GradeLevel15 = $grade[7];
	echo '--'.$grade.'<br>'; // echo out the array values as  I go
   	 }

$grade is element of array (foreach ARRAY as ELEMENT), not array, so when you apply [] to it, you fetch individual chars of the string.

[dmacman1962]

I am not following you.

If I echo $grade, I just get the last part of the array "Post High School".

I understand if I echo $grade[0] I am getting the "P" in "Post High School".

What I don't get is why this worked before, and now I've tried about every possible way and can only get the last part of the array or the first letter of the last part of the array.

Thanks for taking the time to walk me thru this by the way!

Don

[void_function]

foreach $ARRAY as $element, loops through array elements and on each pass assigns current element to $element. In your case that is $grade. You echo $grade in each pass and it correctly results with:

--Elementary
--Grade 7
--Grade 8
--Grade 9
--Grade 10
--Grade 11
--Grade 12
--Post High School

Then, in SQL you use $grade as if it were an array, and it is not, it is a string. More correctly, it contains the LAST entry of $_POSTed array, which is "Post High School", since you apparently use it in SQL after the foreach loop. Using it as array with [] operators acts like pointer indexing in C, thatis it returns each char of the string at [n_th] position.

[dmacman1962]

Got it!

Thanks, here is the "new" working code...

foreach (array($_POST['GradeLevel']) as $grade) { //Set the elements in the array
	$GradeLevel8 = $grade;
	$GradeLevel9 = $grade;
	$GradeLevel10 = $grade;
	$GradeLevel11 = $grade;
	$GradeLevel12= $grade;
	$GrageLevel13 = $grade;
	$GrageLevel14 = $grade;
	$GradeLevel15 = $grade;
   	 }
} 

Thanks for the walkthru !

Don