count downloads script

I would like to create a script that will be able to track downloads from my page. eg. the user clicks to a link to download.php?id=1 and the script gives the file that haves id 1 in a mysql database, and counts the hit.

Is there any script capable to do this?

[Join us @ facebook]

Well here is your script :

Code:

<?php

//Avoid fake hits

if ( ! isset($id) )
{
    exit;
}

//This $db stuff can be changed to whatever you use for integration with mySql

/*
Table structure :

id -> id of download
file -> filename with path
hits -> how many times downloaded

*/

$db = new DB_Class();
$db->query("SELECT file FROM downloads WHERE id = '$id' LIMIT 1");
$db->next();
$URL = $db->Record[0];

$db->query("UPDATE LOW_PRIORITY downloads SET hits = hits + 1 WHERE id = '$id' LIMIT 1");

$f = fopen($URL, "rb"); 
$content_len = filesize($URL); 
$content_file = fread($f, $content_len); 
fclose($f); 

@ob_end_clean(); 
@ini_set('zlib.output_compression', 'Off'); 

//Some error reporting:
if ( ! file_exists ( $URL ) )
{
     die ( "The file you asked does not exists" );
}

header("Cache-Control: no-store, no-cache, must-revalidate");                  
header("Cache-Control: post-check=0, pre-check=0", true);                      
header("Pragma: no-cache");                                                    
header("Expires: 0");
header("Content-disposition: attachment; filename=" . basename( $URL ));  
header("Content-type: application/force-download");

echo $content_file; 
?>

Thanks Nikolas. I really apreciate this

[Join us @ facebook]

Welcome my friend

What that script does is store the count in a database. It takes the count amount from database, adds 1 to the number of hits, and then stores it back into the database. (Just explaining to people who dont understand how it works)

[Guest]

[62.885]

Googlebot, nathan.joshua, Yahoo crawler