📄 user.asp
字号:
<!--#include file="security.asp"-->
<!--#include file="articleconn.asp"-->
<html><!--#include file="../checkpost.asp"-->
<%if session("flag")>1 then
response.write "<script>alert('您的操作权限不够！');history.back();</script>"
response.end
end if
%>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" type="text/css" href="css/css.css">
<title>会员列表</title>
<style type=text/css>
body {
background:#799AE1;
margin:0px;
font:9pt 宋体;
background-color: #eeeeee;
}
table { border:0px; }
td { font:normal 12px 宋体; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover { color:#428EFF;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
.样式1 {
font-size: 9px;
font-weight: bold;
}
.样式4 {
font-size: 9pt;
color: #345b9c;
}
.样式6 {font-size: 9pt; font-weight: bold; color: #345b9c; }
.样式8 {
font-size: 9pt;
color: #FF0000;
}
.样式10 {color: #000000}
.样式14 {font-size: 9pt; color: #FF0000; font-weight: bold; }
</style>
<%
MaxPerPage=30
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim typename
typename=""
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
dim sql
dim rs
dim rstype
dim typesql
dim typeid,typename1
if not isEmpty(request("oklook")) then
oklook=request("oklook")
else
oklook=""
end if
%>
</head>
<body leftmargin="0" topmargin="0">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"></td>
</tr>
</table>
<%
if request("userid123")="" then
if request("oklook")="" then
sql="select * from 56mdata order by id desc"
else
sql="select * from 56mdata where oklook="&request("oklook")&" order by id desc"
end if
else
sql="select * from 56mdata where userid like '%"&request("userid123")&"%'"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'> 还 没 有 任 何 会 员</p>"
else
totalPut=rs.recordcount
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,"user.asp"
showContent
showpage totalput,MaxPerPage,"user.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,"user.asp"
showContent
showpage totalput,MaxPerPage,"user.asp"
else
currentPage=1
showpage totalput,MaxPerPage,"user.asp"
showContent
showpage totalput,MaxPerPage,"user.asp"
end if
end if
end if
sub showContent
dim i
i=0
%>
<form method="POST" action="user.asp" align=" center">
<p align="center"><b>用户名：</b><input type="text" name="username123" size="20">
<input type="submit" value="查询"></p></form>
<form method="POST" action="user.asp" align=" center">
<p align="center"><b>Email：</b><input type="text" name="email" size="20" >
<input type="submit" value="查询"></p>
</form>
<p align="center"></p>
<div align="center">
<center>
<table width="816" height="148" border="0" cellpadding="0" cellspacing="1" bordercolor="#111111" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#FFFFFF" style="border-collapse: collapse">
<tr bgcolor="#CCCCCC">
<td width="43" align="center" bgcolor="#CCCCCC" height="20"><div align="center"><span class="样式6"> 帐 号 </span></div></td>
<td width="89" align="center" bgcolor="#CCCCCC" height="20"><span class="样式6">网站地址</span></td>
<td width="90" align="center" bgcolor="#CCCCCC" height="20"><span class="样式6">注册时间</span></td>
<td width="81" align="center" bgcolor="#CCCCCC" height="20"><span class="样式6">显示次数</span></td>
<td width="62" align="center" bgcolor="#CCCCCC" height="20">
<p align="center" class="样式1 样式4">点击次数</td>
<td width="68" align="center" bgcolor="#CCCCCC" height="20"><span class="样式6">请求支付</span></td>
<td width="95" align="center" bgcolor="#CCCCCC"><span class="样式6">已支付</span></td>
<td width="118" align="center" bgcolor="#CCCCCC"><span class="样式6">目前帐户</span></td>
<td width="79" align="center" bgcolor="#CCCCCC"><span class="样式6">计费模式</span></td>
<td width="80" align="center" bgcolor="#CCCCCC" height="20"><span class="样式6">删除</span></td>
</tr>
<%do while not rs.eof%>
<tr>
<td height="20" bgcolor="#eeeeee"><div align="center"><%=rs(1)%></div></td>
<td height="20" bgcolor="#eeeeee"><div align="center"><a href="<%=rs("homepage")%>" target="_blank"><%=rs("homepage")%></a></div></td>
<td height="20" bgcolor="#eeeeee" align="center"><%=rs("time")%></td>
<td height="20" bgcolor="#eeeeee" align="center"><span class="样式14"><%=rs("xs")%></span></td>
<td height="20" bgcolor="#eeeeee" align="center"><span class="样式14"><%=rs("sds")%></span></td>
<td height="20" bgcolor="#eeeeee"><div align="center"><a href="delmoy.asp?id=<%=rs(0)%>">
<%
qzsf=rs("qzf")
if qzsf<100 then
Response.write ("NO")
else
Response.write(qzsf)
end if
%>
</a></div></td>
<td bgcolor="#eeeeee"><div align="center"><span class="样式8"><strong><%=rs("y_monny")%></strong><span class="样式10">元</span></span></div></td>
<td bgcolor="#eeeeee"><div align="center">
<div align="center" class="样式8"><strong><%=(rs("sds")*0.025)%></strong><span class="样式10">元</span></div>
</div></td>
<td bgcolor="#eeeeee"><div align="center"><a href="stop.asp?id=<%=rs(0)%>&kg=<%=rs("type_h")%>">
<%
type_h=rs("type_h")
if type_h="false" then
Response.write("已暂停")
else
Response.write("停止计费")
end if
%>
</a></div></td>
<td height="20" bgcolor="#eeeeee"><div align="center"><a href="deluser.asp?id=<%=rs(0)%>">删除</a></div></td>
</tr>
<tr>
<td height="20" bgcolor="#eeeeee"> </td>
<td height="20" bgcolor="#CCCCCC"><div align="center"><span class="样式6">联系QQ</span></div></td>
<td height="20" colspan="2" align="center" bgcolor="#CCCCCC"><span class="样式6">Email</span></td>
<td height="20" bgcolor="#CCCCCC" align="center"><span class="样式6">邮政编码</span></td>
<td height="20" bgcolor="#CCCCCC"><div align="center"><span class="样式6">真实姓名</span></div></td>
<td bgcolor="#CCCCCC"><div align="center"><span class="样式6">联系电话</span></div></td>
<td height="20" colspan="3" bgcolor="#CCCCCC"><div align="center"><span class="样式6">汇款地址</span></div></td>
</tr>
<tr>
<td height="20" bgcolor="#eeeeee"> </td>
<td height="20" bgcolor="#eeeeee"><div align="center"><%=rs("oicq")%></div></td>
<td height="20" colspan="2" align="center" bgcolor="#eeeeee"><%=rs("email")%></td>
<td height="20" bgcolor="#eeeeee" align="center"><%=rs("yb")%></td>
<td height="20" bgcolor="#eeeeee"><div align="center"><%=rs("zname")%></div></td>
<td bgcolor="#eeeeee"><div align="center"><%=rs("telphone")%></div></td>
<td height="20" colspan="3" bgcolor="#eeeeee"><div align="center"><%=rs("add")%></div></td>
</tr>
<tr>
<td height="20" bgcolor="#eeeeee"> </td>
<td height="20" colspan="9" bgcolor="#CCCCCC"><div align="center"><span class="样式6">银行帐号</span></div></td>
</tr>
<tr>
<td height="20" bgcolor="#eeeeee"> </td>
<td height="20" colspan="9" bgcolor="#eeeeee"><div align="center"></div>
<div align="center"><%=rs("bank")%></div></td>
</tr>
<tr>
<td height="20" width="43" bgcolor="#eeeeee">
<p align="center"></td>
<td height="20" width="89" bgcolor="#eeeeee">
<p align="center"> </td>
<td width="90" height="20" bgcolor="#eeeeee" align="center"> </td>
<td width="81" height="20" bgcolor="#eeeeee" align="center"> </td>
<td width="62" height="20" bgcolor="#eeeeee" align="center"> </td>
<td width="68" height="20" bgcolor="#eeeeee">
<p align="center"><a href="delmoy.asp?id=<%=rs(0)%>">
</a><font color="#000000">
</font></td>
<td width="95" bgcolor="#eeeeee"><div align="center" class="样式8"></div></td>
<td width="118" bgcolor="#eeeeee"><div align="center" class="样式8"></div></td>
<td width="79" bgcolor="#eeeeee"><div align="center"><a href="stop.asp?id=<%=rs(0)%>&kg=<%=rs("type_h")%>">
</a></div></td>
<td width="80" height="20" bgcolor="#eeeeee">
<p align="center"><a href="deleteuser.asp?id=<%=rs("id")%>">
</a></td>
</tr>
<% i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
</center>
</div>
<%
end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
response.write "<p align=""center""><form method=Post action="&filename&"?typeid="&typeid&"&oklook="&request("oklook")&">"
if CurrentPage<2 then
response.write "<font color='#000080'>首页 上一页</font> "
else
response.write "<a href="&filename&"?page=1&typeid="&typeid&"&oklook="&request("oklook")&">首页</a> "
response.write "<a href="&filename&"?page="&CurrentPage-1&"&typeid="&typeid&"&oklook="&request("oklook")&">上一页</a> "
end if
if n-currentpage<1 then
response.write "<font color='#000080'>下一页 尾页</font>"
else
response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&typeid="&typeid&"&oklook="&request("oklook")&">"
response.write "下一页</a> <a href="&filename&"?page="&n&"&typeid="&typeid&"&oklook="&request("oklook")&">尾页</a>"
end if
response.write "<font color='#000080'> 页次：</font><strong><font color=red>"&CurrentPage&"</font><font color='#000080'>/"&n&"</strong>页</font> "
response.write "<font color='#000080'> 共<b>"&totalnumber&"</b>个会员 <b>"&maxperpage&"</b>个会员/页</font> "
response.write " <font color='#000080'>转到：</font><input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">"
response.write " <input class=buttonface type='submit' value='Goto' name='cndok'></span></p></form></p>"
end function
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</body>
</html>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -