📄 user2.asp

📁 网上购物系统 asp+sql server 2005
💻 ASP
字号:
<!--#include file="../include/dbopenbd.asp"-->
<!--#include file="checkadmin.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="manage.css" type="text/css">
</head>
<BODY background="../images/admin/back.gif">

<form name=form1 action=user1.asp method=post>
<input type=hidden name=search value="yes">
<input type=hidden name=sql value="">
</form>
<%
session("sql")=""
if request("search")="ok" then
  sql=""
  if request("userid")<>"" then sql=sql & " and userid like '%"&buyoktxtcheck(request("userid"))&"%'"
  if request("HomePhone")<>"" then sql=sql & " and HomePhone='"&buyoktxtcheck(request("HomePhone"))&"'"
  if request("ZipCode")<>"" then sql=sql & " and ZipCode='"&buyoktxtcheck(request("ZipCode"))&"'"
  if request("userqq")<>"" then sql=sql & " and userqq='"&buyoktxtcheck(request("userqq"))&"'"
  if request("username")<>"" then sql=sql & " and username like '%"&buyoktxtcheck(request("username"))&"%'"
  if request("usermail")<>"" then sql=sql & " and usermail like '%"&buyoktxtcheck(request("usermail"))&"%'"
  if request("address")<>"" then sql=sql & " and address like '%"&buyoktxtcheck(request("address"))&"%'"
  if request("IP")<>"" then sql=sql & " and IP like '%"&buyoktxtcheck(request("IP"))&"%'"
  if request("Status")<>"" then sql=sql & " and Status ='"&buyoktxtcheck(request("Status"))&"'"
  If isNumeric(request("TotalLogin1")) then sql=sql & " and TotalLogin>="&request("TotalLogin1")
  If isNumeric(request("TotalLogin2")) then sql=sql & " and TotalLogin<="&request("TotalLogin2")
  if request("SignDate")<>"" then sql=sql & " and Datediff(d,SignDate,getdate())<="&request("SignDate")

  session("sql")=sql
  response.Redirect("user1.asp")
end if
%>
<table width="98%" border="1"  style="border-collapse: collapse; border-style: dotted; border-width: 0px"  bordercolor="#333333" cellspacing="0" cellpadding="2">

<form name=search action=user2.asp method=post>
<input type=hidden name='search' value='ok'>

<tr><td colspan=2 class=td height=18>搜索会员</td></tr>

<tr><td width=20% align=center> 根据会员注册ID
</td><td><input type=text name=userid size=25 maxlength=20></td></tr>
<td width=20% align=center>根据会员姓名
</td><td><input type=text name=username size=25 maxlength=20></td></tr>
<td width=20% align=center>根据会员电子邮箱
</td><td><input type=text name=usermail size=25 maxlength=100></td></tr>
<td width=20% align=center>根据会员联系电话
</td><td><input type=text name=HomePhone size=25 maxlength=20></td></tr>
<td width=20% align=center>根据会员联系地址
</td><td><input type=text name=address size=25 maxlength=100></td></tr>
<td width=20% align=center>根据会员邮政编码
</td><td><input type=text name=ZipCode size=25 maxlength=8></td></tr>
<td width=20% align=center>根据会员QQ号码
</td><td><input type=text name=userqq size=25 maxlength=9></td></tr>
<td width=20% align=center>根据会员注册时间
</td><td><input type="radio" name="SignDate" value="1">今天 &nbsp; <input type="radio" name="SignDate" value="2">昨天 &nbsp; <input type="radio" name="SignDate" value="7">一周内 &nbsp; <input type="radio" name="SignDate" value="30">一月内 &nbsp; <input type="radio" name="SignDate" value="">全部 &nbsp; </td></tr>
<td width=20% align=center>根据会员登陆次数
</td><td><input type=text name=TotalLogin1 size=4 maxlength=3>次至<input type=text name=TotalLogin2 size=4 maxlength=3>次</td></tr>
<td width=20% align=center>根据会员IP上次登陆IP
</td><td><input type=text name=IP size=25 maxlength=15></td></tr>
<td width=20% align=center>根据会员状态
</td><td><input type="radio" name="Status" value="1">正常 <input type="radio" name="Status" value="0">锁定/审核中</td></tr>
<tr><td colspan=2><INPUT name=action TYPE="submit" value="开始搜索"></td></tr>
</table>
<br>※提示：支持模糊搜索，可根据一个或多个条件进行搜索，非搜索条件可空出。


</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -