Total Hits using Database ASP Script

Total Hits using Database ASP Script - ASP Web Pro

Active Server Pages Programming by ASP Web Pro

ASP Scripts

TOTAL HITS WITH DATABASE

Another popular web statistic to track is the number of total hits your website receives. There are several ways to accomplish this using a global.asa file, text file, or a database. In this example, we are using an include file to record the data in an MS Access database.

The first thing you need to do is create a totalhits.asp page with the code below:

<%
DIM mySQL, objRS
mySQL = "SELECT * FROM tblTotalHits"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn, adOpenKeyset, adLockPessimistic, adCmdText

DIM iRecordCount
objRS.MoveFirst
iRecordCount = objRS("Hits")
objRS("Hits") = iRecordCount + 1
objRS.Update
%>

Our website has received <% =objRS("Hits") %> total hits.

<%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Next, we add our totalhits.asp include file to every page in our website as seen below:

Note: If you are using an HTML Editor like FrontPage or Dreamweaver, you can save time by placing your include file in your shared border or template. Then, your dailyhits.asp file will autmatically be included in every page that uses that shared border or template.

<HTML><HEAD>
<TITLE>ASP Web Pro</TITLE>
</HEAD>

<BODY>

The rest of your page here.

</BODY>
</HTML>

Now, you have a count of how many Total Hits your website has received.

< Back to ASP Scripts

Main Menu
Home
ASP Scripts
ASP Tutorials
JavaScripts
Awards
Contact Us

Email This Page

Other Resources
ASP Web Hosting
Search Engine Submission
Programming Help

Your browser does not support inline frames...However, you can click <a href="http://www.RentACoder.com/RentACoder/misc/LinkToUs/ScrollingBidRequests.asp?blnHideChannelSubscribe=true&blnLaunchLinkInNewWindow=true&blnFullTitle=true&txtFromURL=AId_74675"> here</a> to see the related document.

Other ASP Web Sites

Site Map

Last Updated:
09 May 2008