ASP+ACCESS 记录IP访问次数
发布网友
发布时间：2022-04-09 14:45
共4个回答
懂视网
时间：2022-04-09 19:06
access.log：
192.168.1.247 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.246 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.245 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.243 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.247 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.247 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.245 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.246 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.246 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.247 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.245 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.245 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.246 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.243 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
192.168.1.247 - - [02/[ul/2015:23:44:59 [0800] "GET /[HTTP/1.1 200 19"
答案：
[wangyuanyuan@vpn shell]$ awk ‘{print $1}‘ access.log |sort -n|uniq -c|sort -rn|head
5 192.168.1.247
4 192.168.1.246
4 192.168.1.245
2 192.168.1.243
本文出自 “linux” 博客，转载请与作者联系！
访问日志access.log统计ip和每个地址访问的次数
标签：awk
热心网友
时间：2022-04-09 16:14
在页面打开的时候，首先执行一个数据查询，看看表内是否有这个IP地址的记录。
如果没有，"insert into Ip_Table(IP,Cishu,Time) values('&Request.Servervariables("HTTP_X_FORWARDED_FOR")
&','1','&DateTime.Now()&')"
如果有，"Update Ip_Table where Cishu='&原次数+1&'，time='&DateTime.Now()&'"
然后在执行查询。
select * from Ip_Table where Ip = '&Request.Servervariables("HTTP_X_FORWARDED_FOR&'
然后显示出Cishu和Time，就可以了。
热心网友
时间：2022-04-09 17:32
2、表调用： select count(*) from iplog where ip='x.x.x.x'
select top 1 time from iplog where ip='x.x.x.x' order by Time
sql = "select count(*) from iplog where ip='"+request.ip+"'"
热心网友
时间：2022-04-09 19:07
