Link redirection: How to log hits?

Anon

Hi,

I installed a script on my server that creates new shorter urls. The original urls are in a database named redirects and the new links have the following format:

http://www.mydomain.com/jump.php?id=1

I am new to php and MySQL, but I was wondering how I would go about also tracking the number of hits to each of the new shorter urls? Does anyone have any advice to get me started?

Thanks!

jamie_webstart

add another field called 'hits' to your database of urls, then before you do the redirect, use:

mysql_query("UPDATE hits=hits+1 WHERE id=$id");

HTH,

Jamie

Anon

Thanks Jamie, I will give it a try!

Jen

Anon

Hi,

This is the script that I am using for my redirection. I was wondering where I insert this line in order to update the "hits" field: mysql_query("UPDATE hits=hits+1 WHERE id=$id");

<?
$db_name = "yourdatabasename";
$table_name = "redirects";
$pathstring = getenv("HTTP_HOST") == "localhost" ? getenv("PATH_INFO") : $PHP_SELF ;

$id = $id;

$connection = mysql_connect("localhost", "yourdatabasename", "yourpassword")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "SELECT id, address FROM $table_name";
$sql .= " WHERE id = " . $id . ";";
$result = mysql_query($sql,$connection) or die("Couldn't execute query.");

while ($row = @mysql_fetch_array($result))
{
$id = $row["id"];
$address = $row["address"];
}

print "<HEAD>\n";
print "<SCRIPT language=\"JavaScript1.1\">\n";
print "\n";
print "</SCRIPT>\n";
print "<NOSCRIPT>\n";
print "<META http-equiv=\"Refresh\" content=\"0; URL=".$address."\">\n";
print "</NOSCRIPT>\n";
print "</HEAD>\n";
print "<BODY>\n";
print "Click <A href=\"".$address."\">here</A> to continue.\n";
print "</BODY>\n";
print "\n";
?>

I tried it in a few different places but just couldn't get it to work.

Thanks,

Jen

lyonhaert

perhaps the query string should instead be:
"UPDATE $table_name SET hits = hits + 1 WHERE id = $id"
also, remove the $id = $id; line, it's totally unnecessary.
for the actual redirection even, remove all of those print statements and use this php statement:
header("location: $address");

in this case however, the value of $address <b>must</b> begin with 'http://' to work right. if it doesn't, or it varies in the database rows, you could use this:

$pre_addy = (strcmp(substr($address, 0, 7), 'http://') == 0)? 'http://':'';
header("location: ".$pre_addy.$address);