Another popular web statistic to track is the number of Daily Hits your website receives. There are several ways to accomplish this using a global.asa file, text file, database, or by using Google Analytics. In this example, we are using an include file to record the hits in a database.
To do this, create a page called /DailyHits.asp and place it in your /includes/ directory with the code below:
<!--#include virtual="/includes/connection.asp" -->
<%
DIM mySQL, objRS
mySQL = "SELECT * FROM tblDailyHits WHERE DateVisited = #" & Date() & "#;"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn, adOpenKeyset, adLockPessimistic, adCmdText
DIM iRecordCount
iRecordCount = 0
IF objRS.EOF THEN
objRS.AddNew
ELSE
objRS.MoveFirst
iRecordCount = objRS("Hits")
END IF
objRS("Hits") = iRecordCount + 1
objRS.Update
%>
<p>We have <% =objRS("Hits") %> hits today.</p>
<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
Next, we add our /DailyHits.asp include file to every page on our website as seen below:
<!-- #include virtual="/includes/dailyhits.asp" -->
<p>The rest of your page here.</p>
Now, you have a count of how many Daily Hits you are receiving on your website.