ad_search.asp

商品订单管理：商品分类管理 添加与修改商品 管理订单 投诉订单 反馈信息 商品留言管理 管理网站用户：管理用户 管理后台管理员 新闻公告管理：新闻添加（支持图片新闻） 修改删除 首页公告设置 网站常规

<!--#include file="conn.asp"-->
<link href=img/css.css rel=STYLESHEET type=text/css>
</head>
<script>
  function user(id) { window.open("ad_viewuser.asp?user_id="+id,"","height=400,width=600,left=190,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");} 
</script>
<script language="javascript">
function openScript(url, width, height){
	var Win = window.open(url,"openScript",'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script>
<%
if session("admin_name")="" then response.end
set rs=server.createobject("adodb.recordset")
%>
<div align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="5">
    <%user_name=request("user_name")
    set rs=server.createobject("adodb.recordset")
    sql="select * from [user] where username like '%"&user_name&"%' order by id DESC"
    rs.open sql,conn,3,3
    if rs.eof then
    %>
                <tr> 
                  <td width="380">Sorry ,the UserName you are searching is not found. </td>
                </tr>
 <%else%>
  <tr bgcolor="#FFFFFF"> 
          <td width="7%" height="15" align="center">ID
            <div align="center"></div>
          </td>
          <td width="9%" height="15" align="center">UserName 
            <div align="center"></div>
          </td>
          <td width="14%" height="15" align="center">Email 
            <div align="center"></div>
          </td>
          <td width="11%" height="15" align="center">Zipcode 
            <div align="center"></div>
          </td>
          <td width="18%" height="15" align="center"> 
            <div align="center">Address</div>
          </td>
          <td width="11%" height="15" align="center">register</td>
          <td width="8%" height="15" align="center">Class</td>
          <td width="10%" height="15" align="center">Delete</td>
          <td width="12%" height="15" align="center">Upgrade to VIP</td>
        </tr>  
               
                <tr> 
                  <td>　</td>
                </tr>
                <%do while not rs.eof %>             
 <tr bgcolor="#FFFFFF"> 
          <td width="7%" height="15" align="center"><%=rs("id")%> 
            <div align="center"></div>
          </td>
          <td width="9%" height="15" align="center"><a href="javascript:openScript('ad_modify.asp?user_name=<%=rs("username")%>',450,300)"><%=rs("username")%> </a>

            <div align="center"></div>
          </td>
          <td width="14%" height="15" align="center"><%=rs("usermail")%> 
            <div align="center"></div>
          </td>
          <td width="11%" height="15" align="center"><%=rs("user_postcode")%> 
            <div align="center"></div>
          </td>
          <td width="18%" height="15" align="center"> 
            <div align="center"><%=rs("user_adds")%></div>
          </td>
          <td width="11%" height="15" align="center"><%=rs("regtime")%></td>
          <td width="8%" height="15" align="center"><%=rs("user_type")%></td>
          <td width="10%" height="15" align="center"><a href="ad_viewuser.asp?user_id=<%=rs("id")%>&action=deluser">Delete</a></td>
          <td width="12%" height="15" align="center"><a href="ad_sheng.asp?user_id=<%=rs("id")%>&action=up">Upgrade</a> / <a href="ad_sheng.asp?user_id=<%=rs("id")%>&action=down">Degrade</a>
          </td>
        </tr>

<%rs.movenext
loop
end if
rs.close
%>
</table>
</div>
 <form method="POST" action="ad_search.asp">
                            <table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
                              <tr> 
                                <td align="center">Search UserName:<input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="user_name" size="15" class=input>
								<input type="submit" name="imageField2" value="Search" ></td>
                              </tr>
                            </table>
                          </form>