防刷新记数器
作者:Admin 时间:08-07-07 点击:
防刷新,好用
<%
Dim lngVisitorNumber '保存来访者数量
On Error Resume Next
lngVisitorNumber = 0
Set conn_cun = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("counters.mdb")
conn_cun.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
SET Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "Select * From counters" , conn_cun,1,3
IF CSTR(Month(Rs("DATE"))) <> CSTR(Month(DATE())) THEN
Rs("DATE") = DATE()
Rs("YESTERDAY") = RS("TODAY")
Rs("BMONTH") = Rs("MONTH")
Rs("MONTH") = 1
Rs("TODAY") = 1
Rs.Update
ELSE
IF CSTR(Day(RS("DATE"))) <> CSTR(Day(DATE())) THEN
Rs("DATE") = DATE()
Rs("YESTERDAY") = Rs("TODAY")
Rs("TODAY") = 1
Rs.Update
END IF
END IF
If Session("lngSessionVisitorNum") = "" Then
lngVisitorNumber = lngVisitorNumber + 1
Session("lngSessionVisitorNum") = lngVisitorNumber
Rs("TOTAL")=Rs("TOTAL") + 1
Rs("TODAY") =Rs("TODAY") + 1
Rs("MONTH")=Rs("MONTH") + 1
Rs.Update
end if
Response.write"本站浏览总人数:"
MyCounter( Rs("TOTAL") )
Response.write "<br>"
Response.write"今日浏览总人数:"
MyCounter( Rs("TODAY") )
Response.write "<br>"
Response.write"昨日浏览总人数:"
MyCounter( Rs("YESTERDAY") )
Response.write "<br>"
Response.write"本月浏览总人数:"
MyCounter( Rs("MONTH") )
Response.write "<br>"
Response.write"上月浏览总人数:"
MyCounter( Rs("BMONTH") )
Response.write "<br>"
N=now
D2 = DateValue(N)
D1 =#11/8/2002# ' 开始统计日期(月/日/年)
Response.write"开站至今天:"
MyCounter( DateDiff("d", D1, D2) )
Response.write "<br>"
D3 = DateDiff("d", D1, D2)
Response.write"平均一日人数:"
MyCounter( Rs("TOTAL")\D3 )
conn_cun.CLOSE
Function MyCounter( counter )
Dim S, i, G
S = CStr( counter )
For i = 1 to Len(S)
G = G & "<IMG SRC=./images/" & Mid(S, i, 1) & ".gif Align=middle>"
Next
Response.write G
End Function
%>
数据表counters字段名及类型
id 自动编号
total 累计计数 数字
today 今日累计 数字
yesterday 昨日累计 数字
month 本月累计 数字
bmonth 上月累计 数字
date 开始统计日期 日期
另外,你还有准备 0.gif - 9.gif 10个图片放在当前子目录images下