PHP Script to log link clicks

What you could try doing is a sort of redirect thing:
Page

So, in redirect.php, have something that counts how many times that page was visited (might want to check where it's from too) as well is anything else you want to add to the database then at the very end, redirect to the page it's supposed to go to.

All this happens in about 2 seconds so, users don't really notice it much.

Not entirely sure how it would be done, but I have seen similar things inplemented several times, even here at TWF.

Logging what you want is up to you, and can't really help too much on that but, I can say that at the end, all you really need is the following:

You just need to write a little redirect script in PHP then send all links via that script. In code redirect.php would look something like this:

<?PHP

// decode the location you want to visit
$loc = base64_decode($_GET['loc']);

// update the number of times this particular location has been visited in your database
$sql = "UPDATE page_visits SET visits=visits+1 WHERE loc=".$loc." LIMIT 1";
$result = mysql_query($sql);

header('Location: '.$loc);

?>

Then you call redirect.php like this:

">Visit Google

You'll obviously need to have a MySQL database setup with a table called page_visits with columns for visits and loc.

I also encoded the url to make it look neater and less prone to parsing errors. I base64_encoded it because I like to be secretive sometimes.

Disclaimer: This is untested code and if it wipes you computer and starts global armageddon you can't blame me!