Multiple Variables from GET, Using each?

[Anon]

I'm trying to send (via GET) variables to a script which will then query a database with those variables. Assuming my SQL statements and everything are ok, here is this snipplet I am having a problem with:

if ($drinks == True)
{
$sql .= "AND drinks = '$drinks' ";
}
if ($food == True)
{
$sql .= "AND food = '$food' ";
}

So if I have collector.php?drinks=milk&food=cookies then the correct number of results appears.

But, if I attempt to use multiple selections like collector.php?drinks=milk&drinks=coke&food=cookies&food=chips then I only receive results for drinks=milk and food=cookies --- the second variable are ignored.

I read over the each function in the manual, but I'm confused how I would apply that function here.

Any help greatly appreciated. Thanks

[Anon]

Here's one of many attempts that does not work:

if ($drinks == True)
{
while( list($mult_drinks) = each($drinks))
{
$sql .= "AND drinks = '$mult_drinks' ";
}
}
Hmmm...

[jc94062]

"collector.php?drinks=milk&drinks=coke&food=cookies&food=chips"

If we have "?var=something" then you can read the value of var as $var, ie: $var is a variable.

If your example you are basically doing

$drinks='milk';
$drinks='coke';
$food='cookies';
$food='chips';

And theres no way thats going to work, "coke" will override "milk", except passing it via the URL it doesn't override, it just retains the original value.

while\each loops are used for arrays.

You need to do something like

collector.php?drink1=milk&drink2=coke&food1=cookies&food2=chips

If you have problems creating that kind of URL automatically just let me know, but it should be straightforward with a for loop.

[Anon]

Hmmm... I think I can still do it utilizing the same GET format (of course, I'm probably wrong). How about...

if ($drinks == True)
  {
     $sql .= " AND ";
     reset ($_GET);
     while (list ($key, $val) = each ($_GET)) {
		$count = $count + 1;
		if ($count > 1)
			{
			$sql .= " OR ";
			}
     $sql .= "$key = '$val'";
        }
  }

... this does not solve my problem with multiples. But, I think I'm getting closer (utilizing OR).

[jc94062]

I'm 99% sure you can't pass two values through a URL with the same variable name, unless you want to do something along the lines of

?food=item1+item2 ... Not sure on whether + is allowed or not tho.

Oh, and

if ($drinks == True)
{
$sql .= " AND drinks = '$drinks'";
}
if ($food == True)
{
$sql .= " AND food = '$food'";
}

putting the spaces at the front is a little better, means your $sql doesn't end up with an unneeded space at the end 😃

[Anon]

Thanks James for your help --- I wouldn't have added [] (also known as %5B%5D) if it wasn't for your comments.

ok, this works using the following GET:
collector.php?drinks%5B%5D=milk&drinks%5B%5D=coke

In the script I do the following:
reset ($HTTP_GET_VARS);
$count = 0;
if ($drinks == True)
{
$sql .= "AND ";
while (list($key, $val) = each($HTTP_GET_VARS))
{
while (list($vala, $valb) = each ($val))
{

		$count = $count + 1;
		if ($count > 1)
			{
			$sql .= " OR ";
			}
		$sql .= " drinks= $valb ";
   	}
  }

}

Later I close the parenthetical required for WHERE.

[jc94062]

Yeah that works because you are creating an array instead of the same variable 😃