redirect after passing url

Anon

Hey

I have a click counter where I pass a URL on the end of a link as a query string, i.e.:

/clicks.php?url=$url

The 'clicks.php' page then gets the url, writes it to a table and then I need it to redirect to the clicked site. My code is below:

$sql="INSERT INTO clicktab VALUES ($url)";
$conn = mysql_connect($db_host,$db_user,$db_pass);
$db = mysql_select_db($db_name,$conn);
$result = mysql_query($sql)

header("location: http://$url");

The problem is that I get a 'Cannot Connect To Server' message. The url goes onto the table fine but has a "%20" tagged on to the end which is altering the url and making it invalid.

Any ideas as to how I can prevent this addition at the end?

[deleted]

Use the trim() function in the start of the script (before you setting it into the database and redirect!):
$url = trim($url);

Regards,

Johan

Anon

No, didn't work I'm afraid.

As I said, the url goes onto the table correctly from the SQL statement as:

www.mysite.com

so this must mean that $url="www.thesite.com"

When I use trim($url) I still get the Page Cannot Be Displayed error with the url reading:

www.mysite.com/stats/click.php?url=www.thesite.com%20

Can't figure where this %20 comes from - any ideas?

ame12

Hmmm... seems to me like the space must be there somehow. Try passing in a dummy arg to see this this is the case, like redirecting to:

http://thesite.com?fakearg=18

See if the space still gets tacked on. You can should/also use rawurlencode on the argument you're passing in...

Also, try just setting the URL variable manually to see if this exhibits the same behavior.

$u = "http://thesite.com";
header("location: ".rawurlencode(trim($u)));

Dave

===========================================
http://badblue.com/helpphp.htm
Free small footprint web server for Windows

PHP, file-sharing, Access/Excel transcoding

Anon

Well, there was whitespace in the passed url variable.

I have so far tried using trim($url), chop($url), and rtrim($url) both at the top of my redirect script AND on the previous page just after the $url is taken from its table. Each time the result STILL contains the whitespace.

I've had this kind of grief with PHP before where a seemingly simple function call doesn't do anything at all (i.e. $str_replace() and especially $sort()).

Please help me!

badman

hello
it is working for me!what i have done is put a link with a url as querystring, here is the code
// bb.php

<body>
<a href='aa.php?url=www.hotmail.com' >click url</a>";

</body>

//aa.php
header("Location: http://$url");

try this...
if this works then you can add the database related stuff before sending header.
cheers!