📄 showsearchdomaincontent.asp

📁 直接解压即可都是asp源码超经典的啊
💻 ASP
字号:


<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<% 
id=session("userid")
username=session("username")
if id="" or username="" and session("login")<>"login" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from sysuser where sysuser='"& username &"' and id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>

<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">


<body bgcolor="#FFFFFF">
<div align="center">
  <center>
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
  <tr>
    <td bgcolor="#EAF1FB">　</td>
  </tr>
  <tr>
    <td bordercolor="#FFFFFF"><form name="form1" method="post" action="showsearchdomaincontent.asp">
        <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#f1f1f1">
          <tr> 
            <td bgcolor="#EAF1FB">域名查询： 
              <input name="domain" type="text" id="domain" size="15"> </td>
            <td bgcolor="#EAF1FB">按订单号： 
              <input name="keyword" type="text" id="keyword" size="10"> </td>
            <td bgcolor="#EAF1FB"><input type="submit" name="Submit" value="搜索"></td>
          </tr>
        </table>
      </form>
      <br>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="25%"><div align="center" class="f1">订单号</div></td>
          <td width="25%"><div align="center" class="f1">会员名</div></td>
          <td width="25%"><div align="center" class="f1">开设日期</div></td>
          <td width="25%"><div align="center" class="f1">是否结算</div></td>
        </tr>
      </table>
      <br>
      <% 
	  domain=request.form("domain")
	  keyword=right(request.form("keyword"),1)
myself=request.servervariables("path_info")
Set rs = Server.CreateObject("ADODB.Recordset")
if keyword="" and domain<>"" then
sql="select * from domainshopping where domain1='"&domain&"' or domain2='"&domain&"' or domain3='"&domain&"' or domain4='"&domain&"' or domain5='"&domain&"' or domain6='"&domain&"' or domain7='"&domain&"' order by id desc"
end if
if keyword<>"" and domain<>"" then
sql="select * from domainshopping where domain1='"&domain&"' or domain2='"&domain&"' or domain3='"&domain&"' or domain4='"&domain&"' or domain5='"&domain&"' or domain6='"&domain&"' or domain7='"&domain&"' and id="&keyword&""
end if
if domain="" and keyword<>""  then
sql="select * from domainshopping where id="&keyword&""
end if
if domain="" and keyword=""  then
sql="select * from domainshopping order by id desc"
end if
rs.open sql,conn,3,3
if rs.eof then 
response.write"<div align=center>暂没有此域名的订单。</div>"
else

 rs.Pagesize=10
page=clng(request("page"))

if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
do while not rs.eof
%>
	<table width="100%" border="0" cellpadding="3" cellspacing="0">
        <tr bordercolor="#f1f1f1" bgcolor="#f1f1f1"> 
          <td width="25%" bgcolor="#EAF1FB">
            <div align="center"><a href="showdomainapgent.asp?id=<%=rs("id")%>"><%=rs("id")%></a></div>
          </td>
          <td width="25%" bgcolor="#EAF1FB"><div align="center"><%=rs("user_name")%></div></td>
          <td width="25%" bgcolor="#EAF1FB"><div align="center"><%=rs("date")%></div></td>
          <td width="25%" bgcolor="#EAF1FB"><div align="center"><span class="f1"><%=rs("bolo")%></span>
		  <% if session("admintyp")="技术管理员" then %>
		   &nbsp;<a href="domainshoppingcontent.asp?cmd=del&id=<%=rs("id")%>"><img src="images/cross.jpg" alt="删除此主机" width="16" height="16" border="0"></a></div>
<% else
response.write""
end if
%>
</td>
        </tr>
      </table>
	  <table width="100%" height="2" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td></td>
        </tr>
      </table>
      <% i=i+1
	  if i>10 then exit do
	  rs.movenext
	        loop
			%>
      <br>
      <div align="center">
        <center>
      <table width="100%" border="0" cellpadding="3" cellspacing="0">
        <tr> 
            <td> <%
if page<>1 then %> <div align="center"><a href=<%=myself%>?page=1>第一页</a> 
                <a href=<%=myself%>?page=<%=(page-1)%>>上一页</a> 
                <%
end if
if page<>rs.pagecount then
%>
                <a href=<%=myself%>?page=<%=(page+1)%>>下一页</a> 
                <a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a> 
                <% end if %>
                <font style="font-size:9pt">&nbsp;页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div></td>
        </tr>
      </table>
	    </center>
    </div>
	  <% end if %>
	   </td>
  </tr>
</table>
  </center>
</div>
</body>
</html>
<% 
if session("admintyp")="技术管理员" then  
if request.QueryString("cmd")="del" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from domainshopping where id="& request.QueryString("id") &""
rs.open sql,conn,3,3
rs.delete
response.Redirect("domainhoppingcontent.asp")
end if
end if
%>
<% 
end if
rs.close
set rs=nothing
set conn=nothing
%>
⌨️ 快捷键说明

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