Download Tracker

Another popular web statistic that is valuable to track is how many times an item such as a file or image has been downloaded.  This may seem a little more in-depth than our other web statistic scripts, but just take it step by step and you will be fine.  This little script will track the title of each item that is downloaded and it will track how many times it was downloaded each day.

To get started, you need a file to be downloaded and we will place all of our downloadable files in our /Downloads/ directory.  For this example, we will say that we want to download this file:

Second, create a web page called /Downloads.asp within your root directory to list all of your downloadable files.  Then, add a link on your web page like this:

<a href="includes/downloadtracker.asp?Title=MyDocument&File=document.txt">
Download My Document Here</a>


Third, create a new table called tblDownloads in your database and with these fields:
ID – Autonumber
fTitle – Text, 255
fFile – Text, 255
fDownloads – Number
fDateDownloaded – Date/Time


Fourth, create a web page called /DownloadTracker.asp, place it in your /includes/ directory, and add the below code to it.

<!--#INCLUDE VIRTUAL="/includes/dbconnection.asp" -->

DIM mySQL, strTitle, strFile, strDate, objRS
strTitle = Request("Title")
strFile = Request("File")
strDate = Date()
mySQL = "SELECT * FROM tblDownloads WHERE fTitle = ' " & strTitle & " ' & _
"AND fDateDownloaded = ' " & strDate & " ' ;"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn, adOpenKeyset, adLockPessimistic, adCmdText

objRS("fTitle") = Request("Title")
objRS("fFile") = Request("File")
objRS("fDownloads") = 1
objRS("fDateDownloaded") = Date()
DIM intCount
intCount = objRS("fDownloads")
objRS("fDownloads") = intCount + 1

Set objRS = Nothing
Set objConn = Nothing

Response.Redirect("/downloads/" & Request("File"))

Just be sure to place all of your downloadable files in your /Downloads/ directory.  That’s it!  Now you can track which items are being downloaded from your website, how often, and how many downloads occur.

< Back to ASP Scripts