catch variable form the url

hermzz

how can i catch a variable from the url and use it to do a search?
for example i need to get an id from a database
the url would be http://myhost/id.php3?=xx
how can i use the xx to do a search in the database?

malbera

http://myhost/script.php3?id=xx
in script.php3

$query="select * from table where id='$_GET[\\'id\\']' ";

hermzz

but how would you conitnue it?
i thought of:
$query="select * from table where id='$_GET['id']' ";
$myrow = mysql_fetch_array($result, MYSQL_ASSOC);
echo "<table width=\"100%\" border=\"0\" class='body'>";
printf("Nombre: %s", $myrow['id']);
echo "</table>";

Zajil

Example:
$url=parse_url(http://www.php.net/download-php.php3?csel=br);

$url[scheme] = http
$url[host] = www.php.net
$url[path] = /download-php.php3
$url[query] = csel=br

hermzz

i know how to build the url, but i dont know how to get a variable from it in another page, for example:
index.php3 builds a url called
http://www.myhost.com/id.php3?id=1
how can i get the variable id=1 into id.php3
with this id i have to get to show the rest of the row, how can i do this?

Zajil

may be there is better way but you can the code that I post in the top then explode $url[query]

$x=explode("=",$url[query]);
$$x[0]=$x[1]; // assign xx to  $id variable.

I hope that works

hermzz

im really new on php, could you explain what that explode is? and ow it works if it is posible?
thanks

Zajil

$url[query] equal id=xx

So when you explode $url[query] on "=" you will split $url[query] based on splitter "="

$x=explode("=",$url[query]);

$x is an array and after explode command $x will be :

$x[0]=id
$x[1]=xx

hermzz

isnt there an easier way?

MrAlaska

Are you trying to get the name of the variable?

If so, the variable names and values are available
in an array. I don't know off hand how you can grab
it explicitly, but you can loop through all the
variables.

For instance, the following code on
test.php?id=me&hello=howdy

<?php
while (list($name, $val) = each($HTTP_GET_VARS)) {
	echo "$name: $val<br>";
}
?>

will display:

id: me
hello: howdy

Of course, you can assign values instead of echoing the results
Is that what you are trying to do?

bubblocity

you should find it in
$xx;

or $HTTP_GET_VARS[xx]; (if register_globals is turned Off)