Simple Download Counter

DOS · 02-16-2005, 01:22 PM

Does anyone know where I could find a simple counter that counts the number of times a link is clicked and displays it?

kwvarga · 02-17-2005, 06:47 AM

link to
download.php?file=url/to/file;

download.php

Code:

<?php
$file = $_GET['file'];
//connect to mysql
$q = "SELECT * FROM downloads";
$r = mysql_query($q) or die(mysql_error());
if (mysql_num_rows($r) < 1) {
  $q = "INSERT INTO downloads (url, times) VALUES('$file', '1')";
} else {
  $q = "UPDATE downloads (url, times) VALUES('$file', times + 1) where url = '$file'";
}
$r = mysql_query($q) or die(mysql_error());
?>

view.php

Code:

<?php
//mysql connect stuff
$file = "file.exe";
$q = "SELECT * FROM downloads WHERE url = '$file'";
$r = mysql_query($q);
$row = mysql_fetch_array($r);
echo "File has been downloaded $row[1] times";
?>

try that