problem storing variables in array

[Dima]

A user has the option to check off any combination of 6 check boxes on the form. After he hits submit, the following code should execute.

    while (list ($key,$val) = @each ($box)) {
        echo "$val,";
        $array[i] = $val ;
        echo $array[i] ;
        $i = $i+ 1 ;
        $a = $i ;    
    }

//output array contents
for ($i = 1; $i <= $a; $i++) {

    echo $array[i] ;

} 

"While ()" function is working; it outputs variables. but array (last portion of the code) is only outputting last variable checked. How can I go by storing user entered variables into array?

Thank you.

[agentforte]

I am not too sure I can help. I am pretty new at this BUT,
I think you would be better off with a foreach loop instead.

I am achieving what I want to assemble the checkbox list in a form with the following:
(assuming that $box is an array with the check box values)

$box=array('optionname'=>'This is a check option',
                'option2name'=>'this is the second option');

foreach ($box as $key=>$val) {
    echo '<label><input type="checkbox" name="' . $key . '" value="' . $key . '"  /> ' . $val . '</label>';
    echo "\n";
} 

Then to validate, I use the same $box array to check that the value submitted is a key in the array:

if (!array_key_exists($_POST['value'], $box) || $_POST['value'] != '')) {
$errormsg = 'There was an error with your submission';
} 

of course you should escape those POST values first.

[Dima]

I fixed the code. It is outputting desired result in Localhost, but when I test it online on shared server, it says:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ..../test1.php on line XX (the line with "$querzipytrack1 = mysql_fetch_array($queryziptrack2)")

if(register_globals) {
echo "Register globals is ON";}
else{echo "Register globals is OFF";}

include 'init.php';
$a = 0 ;
    while (list ($key,$val) = @each ($_POST['box'])) {
        $a = $a + 1 ;
    }

for ($j = 0; $j <= $a-1; $j++) {

    for ($i = 0; $i <= $a-1; $i++) {
    $box1 = $box["$i"] ;
    $box2 = $box["$j"] ;
    $queryziptrack2 = mysql_query("SELECT {$box1} FROM paint WHERE color='$box2'");
    $querzipytrack1 = mysql_fetch_array($queryziptrack2);
        if ($querzipytrack1["{$box1}"] == 1) {
            $masking = "Extra masking is required" ;
        } else {
            $masking1 = "Extra masking is not required" ;
        }
    }
} 

Register Globals is ON.

[byron3@earthlink]

Why are there curly braces around $box1 in your sql query for "$queryziptrack2"?

[Dima]

Why are there curly braces around $box1 in your sql query for "$queryziptrack2"?

Should anything else be there?

As I mentioned, it works flawless on localhost, but issues that warning on server when uploaded.

[kigoobe]

Yes, try removing the curly braces first.

[Dima]

$queryziptrack2 = mysql_query("SELECT $box1 FROM paint WHERE color='$box2'"); 

did not work. I don't think there is problem with {}.

Is there anything else like Register_Globals that might be different in localhost vs shared server?

[kigoobe]

$queryziptrack2 = mysql_query("SELECT ".$box1." FROM paint WHERE color='".$box2."'"); 

And this? Else, try this -

$queryziptrack2 = mysql_query("SELECT ".$box1." FROM paint WHERE color=".$box2); 

[Dima]

$queryziptrack2 = mysql_query("SELECT ".$box1." FROM paint WHERE color='".$box2."'"); 

And this? Else, try this -

$queryziptrack2 = mysql_query("SELECT ".$box1." FROM paint WHERE color=".$box2); 

1st one worked on localhost, but produced the same warning on shared server.

2nd one did not work at all.

[agentforte]

remember, when you use single quotes '$something' the string is taken literally as $somthing
if you use double quotes "$something" the value is taken as a variable.

so the statement WHERE color='$box2' whould look for the string $box2 in the color column. it should be color=$box2.

I found that my server requires a different type of quote for sql queries: `
(usually above the tab key on the left of your keyboard)

the new sql would be:

$queryziptrack2 = mysql_query("SELECT `$box1` FROM `paint` WHERE color=`$box2`"); 

since you used double quotes, it should be fine. Another way you could probably do it is this:

$queryziptrack2 = mysql_query('SELECT `' . $box1 . '` FROM `paint` WHERE color=`' . $box2 . '`'); 

I hope this helps.

[Dima]

My bad. register_globals was OFF, but this script said that it was ON:

if(register_globals) {
echo "Register globals is ON <br>";}
else{echo "Register globals is OFF <br>";} 

How can I make this work when register_globals = OFF

while (list ($key,$val) = @each ($_POST['box'])) {
    $$key = $val;
    echo "$val, $key";
} 

[byron3@earthlink]

foreach($_POST AS $key => $value) {
    ${$key} = $value;
} 

Read the online documentation:http://us2.php.net/register_globals

[Dima]

foreach($_POST AS $key => $value) {
    ${$key} = $value;
} 

did not work. Output: "Extra masking is not required."

whole code:

include 'xxx.php';
$a = 0 ;

//    while (list ($key,$val) = @each ($_POST['box'])) {
//    $$key = $val;
//        $a = $a + 1 ;
//    }

foreach($_POST AS $key => $value) {
    ${$key} = $value;
    $a = $a + 1 ;
} 

for ($j = 0; $j <= $a-1; $j++) {

    for ($i = 0; $i <= $a-1; $i++) {
    $box1 = $box["$i"] ;
    $box2 = $box["$j"] ;
    $queryziptrack2 = mysql_query("SELECT {$box1} FROM paint WHERE color='$box2'");
    $querzipytrack1 = mysql_fetch_array($queryziptrack2);
    
    if (mysql_num_rows($queryziptrack2) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
    }

    if ($querzipytrack1["{$box1}"] == 1) {
        $masking = "<font color=red>Extra masking is required.</font>" ;
    } else {
        $masking1 = "<font color=red>Extra masking is not required.</font>" ;
    }

    }
}

echo "<form method=post action=''>";
echo "<table border='0' cellspacing='0' style='border-collapse: collapse' width='200' >

<tr bgcolor='#ffffff'>
<td width='25%'><input type=checkbox name=box[] value='black' /></td>
<td width='25%'>&nbsp;Black</td>
.....................................
<tr><td colspan =6 align=center><input type=submit value='Tell Me'></form></td></tr>
</table>"; 

below worked when register_globals = on

foreach($_POST['box'] AS $key => $value) {
    ${$key} = $value;
    $a = $a + 1 ;
}