Help With $_GET

iceman2g

I'm using $_GET[] to get results from one page to echo to another page. I have a checkbox setup so that the values of those checkbox are passed to next page and is displayed. Can only seem to get one of those checkbox values to display though.

Here's the code i'm using, on the page passing the values.

echo"<td><input type=\"checkbox\" name=\"id\" value=\"$selection\"></td>";

Now this is what i'm using to get that value and have it echo to the new page.

		echo"<table align=\"center\" valign=\"top\" width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
$result = mysql_query("SELECT * FROM ".$prefix."store_question WHERE answer= '".$_GET['id']."' ");

while($row = mysql_fetch_array($result))
								{ 

								$answer= $row["answer"]; 
								$title=$row["title"];
								$title=stripslashes($title);
						        $answer = nl2br($answer);



	echo"<tr>";
		echo"<td><br><b>$title<b><br></td>";
	echo"</tr>";
	echo"<tr>";
		echo"<td><br>$answer";	

		echo"</td>"; 
	echo"</tr>";
}										 
	echo"</table>";

Here's what's being displayed in the ie bar.
"http://localhost/result.php?id=27ZDF3&id=+GR31O3&submit=GO"

What am I missing that's only allowing one result to be displayed.

gaucho

Hello iceman2g,

you haven't posted the whole code but I assume the checkboxes are within a form.
I also assume you just have more than one checkbox on that page,
I also assume you have something like a submit-button to trigger the database query.
Well, as far as I remember, (correct me if I'm wrong) checkbox values are passed as $POST and not as $GET which would mean you would have to chage your form method to post first.
Then, if you have more than one checkbox you must define the name as array in your input definition, and the value should be a static integer, normally 1, $selection can be set behind (I assume it's just a description or title, etc),
like this:

echo"<td><input type=\"checkbox\" name=\"id[$id]\" value=\"1\">$selection</td>";

instead of

echo"<td><input type=\"checkbox\" name=\"id\" value=\"$selection\"></td>";

On the resulting page with the query and output you should put this code on top of the php-block to have direct access to your variables passed to it:

if(!empty($_POST)
  extract($_POST);

This way you can loop through thi id-array as it was a local variable.

Then you would have to create a loop to construct the "WHERE"-clause,
eg like this:

$where = "";
foreach($id as $k => $v){
if($v == 1){
   if(empty($where))
     $where .= "WHERE answer ='".$k."'";
   else
     $where .= " OR answer='".$k."'";
}
}

The last thing you have to do is to query the database and display the results.

Hope this helps

best regards

gaucho

iceman2g

Using $GET or $POST doesn't make a difference, the only real difference is $GET is visible in ie bar and I always use it until I know code is working then i change it to $POST. It's kinda my way of seeing what's going on.

Also I tryed name=\"id[$id]\" value=\"$id\" before but that didn't work. I also tryed using ('".implode($_GET['id'])."') but that didn't work either. I'll try those suggestion though.

gaucho

Well,
sorry it didn't work the easy way.

The way I described it is normally the way I do it, and it worked so far.

good luck

gaucho

ZibingsCoder

Um...did you try just making the checkboxes' names "id[]"? Stupid question probably, but you just have to do something like...

if ( !is_array($_POST['id']) )
{
   //blah
}

else
{
   foreach ( array_values($_POST['id']) as $id_num )
   {
      //do something with $id_num
   }
}

Inside the foreach, you should run a seperate MySQL query for each $id_num, that way you'll be assured of getting the multiple...things...

gaucho

Googled around a little,

$GET or $POST, don't matter.
But found a little skeleton for checkboxes while looking around.
This aproach is roughly the same:

<form method="post">
I speak the following languages:
<input type="checkbox" name="lang[ ]" value="en">English<br />
<input type="checkbox" name="lang[ ]" value="fr">Français<br />
<input type="checkbox" name="lang[ ]" value="es">Español<br />
</form>

so you can also use other variable types as values and just check if they are in the result array, because one thing I forgot is that from one page to another or after submit, only checkbox values that are "checked" are passed. The other ones don't even exist in the array.

Cheers

gaucho

iceman2g

Originally posted by ZibingsCoder
Um...did you try just making the checkboxes' names "id[]"? Stupid question probably, but you just have to do something like...
if ( !is_array($_POST['id']) )
{
   //blah
}

else
{
   foreach ( array_values($_POST['id']) as $id_num )
   {
      //do something with $id_num
   }
}
Inside the foreach, you should run a seperate MySQL query for each $id_num, that way you'll be assured of getting the multiple...things... [/B]

yeah that helped. Thing to note though whether or not name="id[]" is empty still works so i'm guessing the problem had to do with me not using array_values. This like so much more is new to me.