Pass mysql query results to a different php script

edude

Hello,
First I must say I am a real newbie.
I have writen a php script "recerca.php" that executes a mysql query.
The script shows some of the fields executed in the query, and I want to
include a link to allow the user deciding if she wants to see the
remaining fields. If the user clicks the link I want to open a new
window which shows the remaining fields.
At this moment, I don't know how do all this, mainly opening the new
window and getting the variables values to display in this new window.
Here the code I have used for the link:

echo '<td>Display information on<a href="scripts/pintador.php">
questionnaires</a></td>';

In the script "pintador.php" I use the same variables as in the main
"recerca.php".
I don't get a new window but a blank page in the previous one. Can someone give me any clue, please?
Thanks in advance.

bpat1434

<a href="" target="blank">
That will open it in a new window. Then, just call a new query with the same information. If need be, use $GET variables to get the basic information to help build your query.

~Brett

edude

Thank you very much; it improves. But I cannot get the variables from the original script "recerca.php".
Here the code of "recerca.php":

...
$qid=stripslashes($row['questionnaireid']);
$qyear=stripslashes($row['questionnaireyear']);
$qnum=stripslashes($row['questionnumber']);

if ($showquestcount=='2') {
      echo '<td>...href="scripts/pintador.php?qid&qyear&qnum&showquestcount"...;
...
}

My script's "pintador.php" code:

<?php

$_GET[$qid];
$_GET[$qyear];
$_GET[$qid];

$array_qid=explode("--",$_GET[$qid]);
$array_qyear=explode("--",$_GET[$qyear]);
$array_qnum=explode("--",$_GET[$qnum]);
$showquestcount=$_GET[$showquestcount];

echo $array_qid.$array_qyear.$array_qnum.$showquestcount;
exit;
?>

It produces as a result:

$array_qid: Array
$array_qyear: Array
$array_qnum: Array
$showquestions:

I don't know why. Am I wrong typing the variables in the url? Should I enable Globals? What can I do?

bpat1434

WTH? Where did this post go?

Thank you very much; it improves. But I cannot get the variables from the original script "recerca.php".
Here the code of "recerca.php":
$qid=stripslashes($row['questionnaireid']);
$qyear=stripslashes($row['questionnaireyear']);
$qnum=stripslashes($row['questionnumber']);

if ($showquestcount=='2') {
      echo '<td>...href="scripts/pintador.php?qid&qyear&qnum$showquestcount"...;
}
My script's "pintador.php" code:
<?php

$_GET[$qid];
$_GET[$qyear];
$_GET[$qid];

$array_qid=explode("--",$_GET[$qid]);
$array_qyear=explode("--",$_GET[$qyear]);
$array_qnum=explode("--",$_GET[$qnum]);
$showquestcount=$_GET[$showquestcount];

echo $array_qid.$array_qyear.$array_qnum.$showquestcount;
exit;
?>
It produces as a result:
$array_qid: Array
$array_qyear: Array
$array_qnum: Array
$showquestions: 
I don't know why. Am I wrong typing the variables in the url? Should I enable Globals? What can I do?

Huh?

When retrieving data from a url, the "&" is the separater, and the = defines variable value pairs. So:
?qid&qyear&qnum$showquestcount
If using that URL I wanted to get the "qid", "qyear", "qnum", I'd much rather use:
?qid=¿¿¿&qyear=¿¿¿&qnum=¿¿¿
(Where "¿¿¿" is replaced by the variables value from within your PHP script)
and then my php code would be:

<?php

$qid=$_GET['qid'];
$qyear=$_GET['qyear'];
$qnum=$_GET['qnum'];

?>

Something more like:

<?php
if ($showquestcount=='2') {
      echo '<td>...href="scripts/pintador.php?qid='.$qid.'&qyear='.$qyear.'&qnum='.$qnum.'&showquestcount='.$showquestcount.'"...;
} 
?>

Then, in my other php file:

<?php
$qid=$_GET['qid'];
$qyear=$_GET['qyear'];
$qnum=$_GET['qnum'];
$showquestcount=$_GET['showquestcount'];
?>

~Brett

edude

Thanks again for your answer. I deleted my own post about half an hour later, I think, because I could solve my problems and moreover saw some stupid mistakes (as wrong variables' names) in my typing and didn't want to bother anyone with them. I thought deleting it would be better, I am sorry about this.

Well, to let you know how I solved it, here my scripts:

"recerca.php":

...
$qid=stripslashes($row['questionnaireid']);
$qyear=stripslashes($row['questionnaireyear']);
$qnum=stripslashes($row['questionnumber']);
echo '<td>Display information on<a href="scripts/pintador.php?qid='.$qid.'&qyear='.$qyear.'&qnum='.$qnum.'&showquestcount='.$showquestcount.'" target="Questionnaires"> questionnaires</a></td>';
...

"pintador.php":

...
$showquestcount=$_GET['showquestcount'];
$qid=$_GET['qid'];
$qyear=$_GET['qyear'];
$qnum=$_GET['qnum'];
$array_qid=explode("--",$qid);
$array_qyear=explode("--",$qyear);
$array_qnum=explode("--",$qnum);
...

Well, actually I have passed 19 variables through the url, some of them very long text strings concatenated with the separator "--". But the pieces of the scripts shown contain all what I have done.
Many thanks for your new answer. I will try to make it with "¿¿¿".

bpat1434

If you're sending multiple qid, qyear, and qnum values, then you have to use your way. The $GET array will only use the last set of variable=>value pairs. So if you have 3 "year" variables in the url like:
?year=1&year=2&year=25
then, when you get it in your PHP script, the $GET['year'] will only have one value: 25.

Otherwise, my method is just fine.

~Brett