📄 count_list.asp
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0
%>
<!--#include file="../../include/db_conn.asp" -->
<!--#include file="../checkuser.asp" -->
<%
method=Request.QueryString("method")
pageno=Request.QueryString("pageno")
htmltitle="网站访问情况"
htmlname=linkcounlist&"?flag=1"
set count=server.CreateObject("ADODB.Connection")
count.Open connstr
set rs=server.CreateObject("ADODB.Recordset")
if method="clearall" then
sqltext="delete from ys_webcount"
count.Execute sqltext
end if
%>
<html>
<head>
<title><%=htmltitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../include/styles.css" rel="stylesheet" type="text/css">
</head>
<body topmargin=5>
<table width="100%" align=center>
<tr>
<td valign="top" align="left" width="100%">
<form name="form1">
<table width="100%" height="20" border="0">
<tr>
<td style="font-size:12px;"></td>
<%sqltext="select * from ys_webcount order by countdate desc"
'Response.Write sqltext
rs.Open sqltext,count,1,1
%>
<td><font color="navy" style="font-size:14px"><b><%=htmltitle%></b>(共有<font color=red><%=rs.RecordCount%></font>人次访问)</font></td>
<td align="right">
</td>
</tr>
</table>
<table width="100%" height="20" border="0">
<tr>
<%
colzs=2
rowzs=30
rs.PageSize=colzs*rowzs
if pageno="" then
pageno=1
else
pageno=cint(pageno)
end if
if rs.PageCount>0 then rs.AbsolutePage=pageno
%>
<td class=t1 align="left" width=200>
<a href="Javascript:window.location.reload()">[刷新列表]</a>
<a href="Javascript:delrec()">[清空记录]</a>
</td>
<td align="right">
<%if rs.PageCount>1 then%>
[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]
<%if pageno>1 then%>
<a class=r href="<%=htmlname%>&pageno=1">首页</a>
<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">上页</a>
<%end if
if pageno<rs.PageCount then%>
<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">下页</a>
<a class=r href="<%=htmlname%>&pageno=<%=rs.PageCount%>">末页</a>
<%end if%>
<%end if
%>
</td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" bordercolorlight="#CCCCCC">
<tr bgcolor="#225597" align="center">
<td height="29"></td>
<td><font color="#FFFFFF">登录时间</font></td>
<td><font color="#FFFFFF">IP地址</font></td>
<td><font color="#FFFFFF"> </font></td>
<td><font color="#FFFFFF">登录时间</font></td>
<td><font color="#FFFFFF">IP地址</font></td>
<td></td>
</tr>
<%
i=1
do while i<=rowzs and not rs.EOF
if (i mod 2)=0 then
Response.Write("<tr bgcolor=fefefe>")
else
Response.Write("<tr bgcolor=efefef>")
end if
for j=1 to colzs
if not rs.EOF then
%>
<td width=30 height="20" align=right><%=((pageno-1)*colzs*rowzs+(i-1)*colzs+j)%></td>
<td width="150" align=right><%=rs("countdate")%> </td>
<td width="120" align=right><%=trim(rs("countip"))%></td>
<%
rs.MoveNext
else
%>
<td width=30> </td>
<td width="120" align=left></td>
<td width="120" align=right></td>
<%
end if
next
%>
<td></td>
</tr>
<%
i=i+1
loop
%>
</table>
<tr><td>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<tr><td><hr size=1></td></tr>
<tr><td align=right>
[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]
<%if pageno>1 then%>
<a class=r1 href="<%=htmlname%>&pageno=1">[首页]</a>
<a class=r1 href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>
<%end if
if pageno<rs.PageCount then%>
<a class=r1 href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>
<a class=r1 href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>
<%end if
rs.Close
%>
</td></tr>
</table>
</td></tr>
</form>
</td></tr><table>
</body>
</html>
<script language="Javascript">
function delrec()
{
if (confirm('您确认要清空网站访问记录吗？')==true)
{
window.location.href="<%=htmlname%>&method=clearall"
return false;
}
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -