Hit counter for links....

[imk]

is there a modification or can somone find or suggest a way to do this,

i want to start up a rap directory and want to have profiles on rap sites....so i want a counter that will count the amount of clicks going from my site to each other rap site...anyone?

????????????

[Andrew Green]

quick and dirty version:

Setup a table in your database:


create table linklog (linklogid integer not null auto_increment primary key, name text, link text, description text)


Create a file to log and redirect clicks:

link.php

<?php

if($_GET['goto'])
{
require_once('./global.php');
global $db;

$goto = $_GET['goto'];

$db->query("UPDATE linklog SET linkcount=linkcount+1 WHERE link='$goto'");

header("Location: $goto");
}
?>



then instead of linking to "http://google.com", link to "link.php?goto=http://google.com"

To pull a count out of the database:

In your directory file you would do something like this:


$output = "";
$linklist = $db->query_read("SELECT * FROM linklog");
while($link = $linklist)
{
$url = $link['link'];
$count = $link['linkcount'];
$description = $link['description'];
$name = $link['name'];
$output .= "<p><a href='$url'>$name</a> ($count) - $description</p>";
}