求限制同一ip在一个小时内只能访问同一网页40次的代码
下面的那位兄弟能说具体点怎么用吗 ? 最好用cookie实现
我新手
第1个回答 2010-12-13
Set RS = Server.CreateObject("ADODB.Recordset")
Set RS1 = Server.CreateObject("ADODB.Recordset")
sql="select * from record where datediff("n",logintime,now())<=60"
sql1="select *from record"
RS.open sql,cn,1,1
times=RS.recordcount
RS.close
set RS=nothing
if times< 40 then
rs1.open sql1,cn,1,3
rs1.addnew
rs1("result")=getIP
rs1("logintime")=now()
rs1.update
rs1.close
set rs1=nothing
else
response.write "在限定时间内登录超过40次。"
end if本回答被提问者采纳
Set RS1 = Server.CreateObject("ADODB.Recordset")
sql="select * from record where datediff("n",logintime,now())<=60"
sql1="select *from record"
RS.open sql,cn,1,1
times=RS.recordcount
RS.close
set RS=nothing
if times< 40 then
rs1.open sql1,cn,1,3
rs1.addnew
rs1("result")=getIP
rs1("logintime")=now()
rs1.update
rs1.close
set rs1=nothing
else
response.write "在限定时间内登录超过40次。"
end if本回答被提问者采纳