retrieve html queries in php

Anon

Hi All,

I am struck in deep muck and not sure how to get out of it! The context seems simple, but I have no idea. It goes as follows:

I have a PHP page which generates some code for me. It generates a set of clickable links. When a user clicks on the links, the requested page is appended by a query such as http://localhost/newpage.php?MyQuery.

What I need to do is to capture MyQuery in the resulting window. Does any of you know of a way, either PHP or HTML, of retrieving this query?

Thanks a lot in advance.
shash

Anon

i'm not sure if i understand the question right, but...

http://localhost/newpage.php?MyQuery=hello&MyQuery1=World

$MyQuery = $HTTP_GET_VARS['MyQuery'];
$MyQuery1 = $HTTP_GET_VARS['MyQuery1'];

echo "$MyQuery $MyQuery1"; // will print Hello World

basically, when you have a url like http://localhost/newpage.php?MyQuery=hello&MyQuery1=World you can retrieve them with HTTP_GET_VARS.

hope this helps,

~kyle

frymaster

what i think you're talking about is you have a set of queries such as

$query1 = "SELECT foo FROM bar WHERE clown='bozo'";

and what you want to do is this

and it's barfing like a frat pledge... because the spaces and equals signs in your $query1 string ar causing problems. To solve this you should use our pal urlencode(), which basically turns spaces anything that's not a number, letter or underscore into the url code so it can be passed via GET. so we would try:

echo "<a href=\"do_yatta_yatta.php?query=" . urlencode($query1) . "\">ack</a>";

now, on your receiving page, this needs to be translated back with urldecode(). so you would call:

$result = pg_exec($db, urldecode($query1));

or whatever the mysql version of said call would be....

if that's not what you're looking for then, oops.

Anon

Thank you. That fixes my problem.

Shash