24小时只记录一次IP

最新推荐文章于 2025-04-10 17:00:02 发布

原创最新推荐文章于 2025-04-10 17:00:02 发布 · 673 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#date #sql #function #数据库

<%
'获取IP地址的类
Private Function getIP()
Dim strIPAddr
If Request.ServerVariables("HTTP_X_FORWARDED_FOR") = "" OR InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), "unknown") > 0 Then
strIPAddr = Request.ServerVariables("REMOTE_ADDR")
ElseIf InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ",") > 0 Then
strIPAddr = Mid(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), 1, InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ",")-1)
ElseIf InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ";") > 0 Then
strIPAddr = Mid(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), 1, InStr(Request.ServerVariables("HTTP_X_FORWARDED_FOR"), ";")-1)
Else
strIPAddr = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
End If
getIP = Trim(Mid(strIPAddr, 1, 30))
End Function

   uip=getIP() '获得客户端IP
   set rs=server.createobject("adodb.recordset")
   sql="select * from IP where ip= '"&uip&"'" '查询数据库中获得IP的记录
   rs.open sql,conn,1,3
   if rs.eof Then    '判断是否存在记录
   rs.close
   '添加新的页面记录
   sql="select * from IP"
   rs.open sql,conn,3,2
   rs.addnew
   rs("ip") = uip
   rs("date") = Now()
   rs.update
   rs.close
   set rs = Nothing
   '这里写上你对相关网站添加一次点击
   Else
   s_date = rs("date")
   rs.close
   If datediff("d",s_date,Now()) <> 0 Then  '判断记录时间和现在的差几天如果不等于0天也就不是同一天
   '这里写上你对相关网站添加一次点击
   End If
   End If

%>