Mohammad
09-04-2004, 06:58 PM
I have a question :
How can I count the number of hits on a link?
thanks and goodbye
How can I count the number of hits on a link?
thanks and goodbye
|
||||
How can I count the number of hits on a link?Mohammad 09-04-2004, 06:58 PM I have a question : How can I count the number of hits on a link? thanks and goodbye miranda 09-04-2004, 07:38 PM take a link listed like this <a href="http://www.codingforums.com"> to count the number of hits to that link from your page you could do this 1. create a table named pagehits in the database for hits. this will have 2 columns hitCount 'an integar filed requestedPage ' a text field 2 create a page which will count the hits in this example it is called count-hits.asp <%Option Explicit dim objConn, objRs, SQL, strRequested, connString strRequested = Request.QueryString("requestedPage") connString = "D:\WWWRoot\Database\myAccessDatabase.mdb;" Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & connString) SQL = "SELECT hitCount from pagehits WHERE requestedPage = '" & strRequested & "'" Set objRs = Server.CreateObject("ADODB.Recordset") objRs.open SQL, objConn, 1, 2 If objRs.EOF Then objRs.AddNew objRs("requestedPage") = requestedPage End If objRs("hitCount") = (objRs("hitCount") + 1) objRs.Update objRs.close Set objRs = Nothing objConn.close Set objConn = Nothing Response.Redirect requestedPage 3 Change the link in the original page <a href="count-hits.asp?requestedPage=http://www.codingforums.com"> There you go Roy Sinclair 09-07-2004, 06:35 PM Check with your webhost to see if they've got web logging on/available. All the modern web server provide web logs detailing information about all the hits and how the server responded. If you can get that log you'll be able to count the hits for a specific page very precisely. |
| |||
EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum