?? 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 + -