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

📄 sou.asp

📁 用ASP写的一个论坛的程序 数据库是ACCESS 很简单
💻 ASP
字号:
<!-- #include file="conn.asp" -->
<!-- #include file="function.asp" -->
<!-- #include file="pub.asp" -->
<!-- #include file="config.asp" -->

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>你搜索的是:<%=request.QueryString("msgtitle")%></title>
<link href="css/msg.css" rel="stylesheet" type="text/css">
<script  language="javascript">
function ck()
{
if (document.form1.tb.value=="")
 {
 window.alert("请输入贴吧名称!");
 return true;
 }
 else
 {
 document.form1.submit();
  return true;
 }
}

function xunz(n)
{
	if (n==0)
	 {
		document.form1.tb.value="";
		 return true;
	 }
	if (n==1)
	 {
		document.form1.tb.value="";
		document.form1.tb.value="请输入贴吧名称";
		 return true;
	 }
	if (n==2)
	 {
		document.form1.tb.value="";
		document.form1.tb.value="请输入要搜索贴子名称";
		 return true;
	 }
	if (n==3)
	 {
		document.form1.tb.value="";
		document.form1.tb.value="请输入作者名称";
		 return true;
	 }
}
</script>

</head>

<body topmargin="10" >
<%
	   msgtitle=request.QueryString("msgtitle")
	   bti=request.QueryString("bti")
	   if msgtitle="" or bti="" then
	   response.Redirect "http://" & request.servervariables("server_name")
	   end if
	   username=session("username")
	   ql=session("ql")
	   if username="" then
	   username="匿名发表"
	   end if
	   qlstring=""
%>

<table width="100%"   border="0">
  <tr>
    <td>      
	
	<table width="80%"  border="0">
	<form name="form1" method="post" action="find.asp">
      <tr>
        <td><input type="text" name="tb" onClick="xunz(0)" value="请输入贴吧名称">
          <input type="button" name="sb" value="搜索" onClick="ck()" onKeyPress="ck()">
          <input type="reset" name="Submit" value="重置">           
          <a href="login.asp" target="_self">登录</a> | <a href="reg.asp" target="_self">注册</a> | <a href="help.asp" target="_blank">帮助</a></td>
      </tr>
      <tr>
        <td>
		  <input name="radiobutton" type="radio" value="jl" onClick="xunz(1)" checked>
		  进入贴吧		  <input type="radio" name="radiobutton" value="sstz" onClick="xunz(2)">
		  帖子搜索		  <input type="radio" name="radiobutton" value="sszz" onClick="xunz(3)">
		  按作者搜索		</td>
      </tr>
	   </form>
    </table>
	  
	<table width="100%"  border="0" cellspacing="0">
      <tr>
        <td colspan="6">&nbsp;</td>
        </tr>
      <tr>
        <td colspan="5" class="tback">下面是关于&nbsp;"<%=request.QueryString("msgtitle")%>"&nbsp;的搜索结果...</td>
        <td width="23%" align="right" class="tback">&nbsp;</td>
      </tr>
      <tr>
        <td class="td1">点击</td>
        <td class="td1">回复</td>
        <td class="td1">标题</td>
        <td class="td1">作者</td>
        <td colspan="2" class="td1">最后回复</td>
      </tr>
     
	  <%
 
		If Len(Trim(Request("page")))=0 Then  '返回目标页码的判断
		page=1 
		Else 
		page=CInt(Trim(Request("page"))) 
		End If
		set rs=Server.CreateObject("ADODB.RecordSet") 
		if bti=0 then
		sql="select  * from  msg  where msgtitle like '%"&msgtitle&"%' order by replytime desc "
		end if
		if bti=1 then
		sql="select  * from  msg  where author='"&msgtitle&"' order by replytime desc "
		end if
		rs.open sql,conn,1,1
		rs.PageSize=20
        if not rs.eof then '--------------
		    rs.AbsolutePage=page
			for k=1 to rs.PageSize
				    if (k mod 2)=0 then
						bg="td1"
						else
						bg="td2"
					end if

	
%>       
        <tr>
        <td width="7%" class=<%=bg%>><%=rs("hits")%></td>
        <td width="6%" class=<%=bg%>><%=rs("replyn")%></td>
        <td width="36%" class=<%=bg%>><a href="msgshow.asp?tiebaname=<%=rs("tiebaname")%>&msgtitle=<%=rs("msgtitle")%>&id=<%=rs("id")%>" target="_blank"><%=rs("msgtitle")%></a></td>
        <td width="24%" class=<%=bg%>><%=rs("author")%>&nbsp;<%=rs("msgtime")%></td>
        <td colspan="2" class=<%=bg%>><%=rs("replyer")%>&nbsp;<%=qlstring%></td>
        </tr>
	   <%
		rs.movenext
		if rs.EOF Then Exit For
		next
 end if
         '--------------
  
 %>
 <tr>
          <td colspan="6" class=tback>
		  
		  <%
  if page <>1 then
     Response.Write "<a class=tback href=sou.asp?page=1&msgtitle="&msgtitle&"&bti="&bti&">首页</a> "
  end if
  tmppage = page - 1 
  if tmppage <= 0 then 
     tmppage = 1 
  else
     Response.Write"<a class=tback href=sou.asp?page="&tmppage&"&msgtitle="&msgtitle&"&bti="&bti&">上一页</a>"
  end if
  tmppage = page + 1 
  if tmppage >rs.PageCount then 
     tmppage = page
  else
     Response.Write " <a class=tback href=sou.asp?page="&tmppage&"&msgtitle="&msgtitle&"&bti="&bti&">下一页</a> "
  end if 
  if Cstr(page) <> Cstr(rs.PageCount) and Cstr(rs.PageCount) <> 0 then
    Response.Write "<a class=tback  href=sou.asp?page="&rs.PageCount&"&msgtitle="&msgtitle&"&bti="&bti&">尾页</a>"
  end if
  if Cstr(rs.PageCount) <> 0 then
  Response.Write "  第<font color='#CCCCCC'>" & page & "/"&rs.PageCount&"</font>页"
  end if
 
%>
		  
		  
		  </td>
        </tr>
    </table>	
		<p>&nbsp;</p>
    <p>&nbsp;</p></td>
  </tr>
</table>

</body>
</html>

⌨️ 快捷键说明

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