📄 member_manage.asp
字号:
<!--#include file="conn.asp" -->
<!--#include file="admin_dn.asp" -->
<%
if Trim(Request.QueryString("w"))="search" then
search=trim(request("search"))
if request("select")="userid" then sql="select * from user where userid='"&search&"' order by id desc"
if request("select")="sf" then sql="select * from user where sf='"&search&"' order by id desc"
if request("select")="dat" then sql="select * from user where dat=#"&search&"# order by id desc"
if request("se")="all" then sql="select * from user order by id desc"
if request("se")="dat" then sql="select * from user where dat=#"&date&"# order by id desc"
session("sql")=sql
end if
if sql="" or sql=empty then
if session("sql")="" then
sql="select * from user order by id desc"
else
sql=session("sql")
end if
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link href="image/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<p>用户管理</p>
<form name="form1" method="post" action="member_manage.asp?w=search">
<table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="23%"><strong>用户查询</strong></td>
<td width="77%"> </td>
</tr>
<tr>
<td height="24">查询条件：</td>
<td><input name="search" type="text" id="search" size="15"></td>
</tr>
<tr>
<td>查询项目：</td>
<td><select name="select">
<option value="userid">用户名</option>
<option value="sf">用户等级</option>
<option value="dat">注册时间</option>
</select>
<input type="submit" name="Submit" value="搜索"></td>
</tr>
</table>
</form>
<p align="center"> </p>
<p align="center"> -<a href="member_manage.asp?w=search&se=all">显示所有用户</a>- -<a href="member_manage.asp?w=search&se=dat">显示今天注册用户</a>-</p>
<p> </p>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="13%" bgcolor="#EBEBEB"><div align="center">用户名</div></td>
<td width="11%" bgcolor="#EBEBEB"><div align="center">账号金额</div></td>
<td width="20%" bgcolor="#EBEBEB"><div align="center">电子邮件</div></td>
<td width="22%" bgcolor="#EBEBEB"><div align="center">所在省会</div></td>
<td width="10%" bgcolor="#EBEBEB"><div align="center">查看购物车</div></td>
<td width="13%" bgcolor="#EBEBEB"><div align="center">注册时间</div></td>
<td width="11%" bgcolor="#EBEBEB"><div align="center">删除</div></td>
</tr>
<%
pp=20
rs.open sql,conn,1,1
if not rs.eof then
count=rs.recordcount
if count=empty then
count=0
end if
if count/pp>(count\pp) then
totalpage=(count\pp)+1
else
totalpage=(count\pp)
end if
end if
pagecount=cint(request.querystring("topage"))
if pagecount<=0 then pagecount=1
if pagecount>totalpage then pagecount=totalpage
if not rs.eof then
rs.movefirst
rs.move (pagecount-1)*pp
i=0
while not rs.eof and i<pp
i=I+1
%>
<tr bgcolor="#F6F6F6">
<td><div align="left"><a href="user_list.asp?id=<%=rs("id")%>"><%= rs("userid") %></a></div></td>
<td><div align="left"><font color="#FF0000"><%= rs("je") %></font></div></td>
<td><div align="left"><%= rs("email") %></div></td>
<td><font color="#990000"><%= rs("province") %></font></td>
<td><div align="center"><a href="order_view.asp?sel=userid&search=<%=rs("userid")%>">查看</a></div></td>
<td><div align="center"><font color="#FF0000"><%= rs("dat") %></font></div></td>
<td><div align="center"><a href="member_del.asp?userid=<%=rs("userid")%>"><img src="image/4.jpg" width="16" height="16" border="0"></a></div></td>
</tr>
<% rs.movenext
wend
end if
rs.close %>
<tr>
<td colspan="7" bgcolor="#EBEBEB"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="46%">一共有:<%= count %> 条 一共:<%= totalpage %> 页 当前: <%= pagecount %> 页</td>
<td width="54%"><div align="center">
<%
if totalpage>1 then
if totalpage-pagecount>0 then
%>
<a href="user_reg.asp?topage=<%=pagecount+1%>"><font color="#990000">下一页</font></a>
<%
end if
if pagecount<>1 and totalpage-pagecount>0 then
response.write "<font color=#FFFFFF>/</font>"
end if
if pagecount<>"1" then %>
<a href="user_reg.asp?topage=<%=pagecount-1%>"><font color="#990000">上一页</font></a>
<%
end if
end if
%>
</div></td>
</tr>
<tr bgcolor="#FAFAFA">
<td colspan="2"><div align="center">
<% for ss=1 to totalpage %>
|<a href="member_manage.asp?topage=<%=ss%>"><font color="#990000"> <%=ss%></font></a>
<% next %></div></td>
</tr>
</table></td>
</tr>
</table>
<p> <font color="#FF0000">注</font>：点用户姓名将可以查询用户提交的详细资料</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -