⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.asp

📁 小灵通短信网站源程序
💻 ASP
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>短信息检索</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<!--#include file="conn.asp"-->
<%
   	const MaxPerPage=18
   	dim totalPut   
   	dim CurrentPage
   	dim TotalPages
   	dim i,j
   	dim idlist
   	dim title

	title=request("txtitle")
   	if not isempty(request("page")) then
      		currentPage=cint(request("page"))
   	else
      		currentPage=1
   	end if
  	if not isempty(request("selAnnounce")) then
     		idlist=request("selAnnounce")
     		if instr(idlist,",")>0 then
			dim idarr
			idArr=split(idlist)
			dim id
		for i = 0 to ubound(idarr)
	       		id=clng(idarr(i))
	       		call deleteannounce(id)
		next
     		else
			call deleteannounce(clng(idlist))
     		end if
  	end if 
   	dim sql
   	dim rs
%>

<body bgcolor="#FFFFFF">
<div align="center"><center>
    <div align="center">
      <table border=0 cellpadding=0 cellspacing=0 class=menu1 width=750 align="center" bgcolor="#eeeeee">
        <tbody> 
        <tr> 
          <td height=68 width=150><a href="http://www.it801.com" target="_blank"><img src="../images/bazhu.gif" width="150" height="78" border="0"></a></td>
          <td height=68 width=491> 
            <div align="center"><a href="http://www.it801.com" target="_blank"><img src="../images/banner.gif" width="480" height="60" border="0"></a></div>
          </td>
          <td width="109"> 
            <div align=center><font color=#000000><br>
              <a href="801news/2002621125933.htm" target="_blank">成立宗旨</a><br>
              <a 
      class=bz 
      href="javascript:window.external.addFavorite('http://www.it801.com/','801工作室')">加入书签</a><br>
              精品广告<br>
              </font></div>
          </td>
        </tr>
        </tbody> 
      </table>
    </div>
    <div align="center"> 
      <table border="0" cellpadding="0" cellspacing="0" width="750" align="center">
        <center>
          <tr> 
            <td height="2" valign="top" bgcolor="#00006A"> </td>
          </tr>
        </center>
        <tr> 
          <center>
            <td width="405" height="16" bgcolor="#E1E1E1" valign="bottom"> &nbsp; 
              ◇<a href="http://bbs.it801.com/reg.asp">注册</a> ◇<a href="http://www.it801.com">it801首页</a>◇<a href="http://download.it801.com">下载基地</a>◇<a href="http://bbs.it801.com">论坛</a></td>
          </center>
        </tr>
        <center>
          <tr> 
            <td height="2" valign="top" bgcolor="#00006A"> </td>
          </tr>
        </center>
      </table>
    </div>
    <table border="0" width="750" cellspacing="0" cellpadding="0">
      <tr>
        <td width="100%"> 
          <p align="center">&nbsp; 
          <form name="searchsoft" method="POST" action="search.asp">
            输入短句关键字: 
            <input class=smallInput type="text" name="txtitle" size="13"><input type="submit" value="查 询" name="title">
</form>
<div align="center">
<%
	if title<>"" then
	sql="select * from articles where title like '%"&trim(title)&"%' order by articleid desc"
	else
	sql="select * from articles order by articleid desc"
	end if
	Set rs= Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,1

  	if rs.eof and rs.bof then
       		response.write "<p align='center'> 还 没 有 任 何 文 章 </p>"
   	else
      		totalPut=rs.recordcount
      		if currentpage<1 then
          		currentpage=1
      		end if
      		if (currentpage-1)*MaxPerPage>totalput then
	   		if (totalPut mod MaxPerPage)=0 then
	     			currentpage= totalPut \ MaxPerPage
	  		else
	      			currentpage= totalPut \ MaxPerPage + 1
	   		end if

      		end if
       		if currentPage=1 then
           		showpage totalput,MaxPerPage,"search.asp"
            		showContent
            		showpage totalput,MaxPerPage,"search.asp"
       		else
          		if (currentPage-1)*MaxPerPage<totalPut then
            			rs.move  (currentPage-1)*MaxPerPage
            			dim bookmark
            			bookmark=rs.bookmark
           			showpage totalput,MaxPerPage,"search.asp"
            			showContent
             			showpage totalput,MaxPerPage,"search.asp"
        		else
	        		currentPage=1
           			showpage totalput,MaxPerPage,"search.asp"
           			showContent
           			showpage totalput,MaxPerPage,"search.asp"
	      		end if
	   	end if
   	rs.close
   	end if
	        
   	set rs=nothing  
   	conn.close
   	set conn=nothing
  
   	sub showContent
       	dim i
	   i=0
%>
      <div align="center"><center>
                <table border="1" cellspacing="0" width="95%" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellpadding="0">
                  <tr> 
                    <td width="46" align="center" bgcolor="#D0D0D0" height="20"><strong>ID</strong></td>
                    <td width="90%" align="center" bgcolor="#D0D0D0"><strong>短信息检索</strong></td>
                  </tr>
                  <%do while not rs.eof%>
                  <tr> 
                    <td height="23" width="46">
                      <p align="center"><%=rs("articleid")%>
                    </td>
                    <td width="90%">
                      <p><a href="send.asp?id=<%=rs("articleid")%>" title="<%=rs("title")%>" target=_blank><%=rs("title")%></a> 
                    </td>
                  </tr>
                  <%
	i=i+1
	      if i>=MaxPerPage then exit do
	      rs.movenext
	loop
%>
                </table>
      </center></div>
<%
   end sub 

function showpage(totalnumber,maxperpage,filename)
  dim n
  if totalnumber mod maxperpage=0 then
     n= totalnumber \ maxperpage
  else
     n= totalnumber \ maxperpage+1
  end if
  response.write "<p align='center'>&nbsp;"
  if CurrentPage<2 then
    response.write "<font color='#000080'>首页 上一页</font>&nbsp;"
  else
    response.write "<a href="&filename&"?page=1>首页</a>&nbsp;"
    response.write "<a href="&filename&"?page="&CurrentPage-1&">上一页</a>&nbsp;"
  end if
  if n-currentpage<1 then
    response.write "<font color='#000080'>下一页 尾页</font>"
  else
    response.write "<a href="&filename&"?page="&(CurrentPage+1)&">"
    response.write "下一页</a> <a href="&filename&"?page="&n&">尾页</a>"
  end if
   response.write "<font color='#000080'>&nbsp;页次:</font><strong><font color=red>"&CurrentPage&"</font><font color='#000080'>/"&n&"</strong>页</font> "
    response.write "<font color='#000080'>&nbsp;共<b>"&totalnumber&"</b>个短句 <b>"&maxperpage&"</b>个短句/页</font> "
       
end function


%>
    </div></td>
  </tr>
</table>
    <table align=center border=0 cellpadding=0 
cellspacing=0 width=750 class="unnamed2">
      <tbody> 
      <tr> 
        <td height=65 width="712"> 
          <div align="center"> 
            <hr align="center" size="1">
            | <a href="../tech/2002624162639.htm" target="_blank">检索帮助</a> | <a href="../Operation/2002624161957.htm">联系我们</a> 
            | <a href="../801bbs/reg.asp">我要注册</a> | <a href="http://bbs.it801.com">论坛</a> 
            | <a href="http://download.it801.com">下载基地</a> | <a href="http://www.it801.com/sms">手机短信</a> 
            |<br>
            <br>
            工作室成员:网际飞鱼、霸猪、冰阳、流浪狗、笨狐狸、小老鼠</div>
        </td>
      </tr>
      </tbody> 
    </table>
    <div align="center"></div>
  </center>
</div>
</body>
</html>

⌨️ 快捷键说明

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