Log Amount of Clicks

[Dysan]

Every time a link is clicked, how do I keep a record of the number of clicks a link has received, and store the results in a database?

[bokeh]

Just write a clickthru script:

if((!empty($_GET['url'])) and (preg_match('/^(?:f|ht)tps?:\/\/[^\/]+\.[^\/]+(\/[^\'"]*|)$/i', $_GET['url'])))
{
    /*
      Connect to DB here
    */
    $url = mysql_real_escape_string(preg_replace('/^http:\/\/(www\.)?([^\/]+).*$/i', '\2', $_GET['url']));
    $query = "INSERT INTO `$tablename` (`url`, `clicks`) VALUES ('$url', 1) \n".
             "ON DUPLICATE KEY UPDATE `clicks` = `clicks` + 1";
    mysql_query($query)
    header('Location: '.$_GET['url']);
}