checksearch2.asp

该软件用户可以发表

<!--#include file="conn.asp"-->
<%
var rs=Server.CreateObject("ADODB.Recordset");
var key=Request("option");
var content=Request("key");
var n=Request("select");
var sql="select top "+n+" * from main where "+key+" like '%"+content+"%' order by time desc";
rs.Open(sql,conn,3,3);
if(rs.EOF)
{
Session("err")="?ò2?μ??à1?????!";
Response.Redirect("err.asp");
}










%><style type="text/css">
<!--
@import url("css.css");
.unnamed1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #FF6600;
}
a:link,a:visited {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #3399CC;
	text-decoration: none;
}
a:hover {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #FF6600;
	text-decoration: blink;
}
body {
	background-color: #666666;
	margin-top: 0px;
	margin-left: 0px;
	margin-right: 0px;
	background-image: url(img/bg3.gif);
}
.style1 {color: #000000}
.style2 {
	color: #666666;
	font-size: 16;
}
.style3 {
	color: #CCFF66;
	font-size: 14px;
}
.style4 {color: #3399CC}
.style5 {color: #333333}
-->
</style>
<div align="center"><span class="unnamed1 style1">
</span>
  <table width="80%" height="90"  border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="39" background="img/bg4.gif">&nbsp;</td>
      <td width="265" background="img/bg4.gif"><table width="265" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="265" height="90" background="img/top.gif"><img src="img/logo.gif" width="265" height="90"></td>
          </tr>
      </table></td>
      <td width="490" background="img/bg4.gif"><table width="490" height="90"  border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="60" colspan="7" background="img/hole.gif"><table width="490" height="60"  border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="52" height="30">&nbsp;</td>
                  <td width="146" height="30" valign="bottom"><a href="new.asp">????</a></td>
                  <td width="31" height="30" valign="bottom">&nbsp;</td>
                  <td width="152" height="30" valign="bottom"><a href="admin.asp">???? </a></td>
                  <td width="30" height="30" valign="bottom">&nbsp;</td>
                  <td width="79" height="30" valign="bottom"><a href="admin.asp"> </a><a href="index.asp">??</a></td>
                </tr>
                <tr>
                  <td colspan="6"><table width="100%" height="30"  border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="20%">&nbsp;</td>
                        <td width="7%">&nbsp;</td>
                        <td width="31%"><a href="logout.asp" class="style9">
                          <%if (Session("login")==true){%>
                          </a><a href="edit.asp">???? </a>
                          <%}%></td>
                        <td width="8%">&nbsp;</td>
                        <td width="34%"><a href="search.htm"> </a><a href="logout.asp" class="style9">
                          <%if (Session("login")==true){%>
                          </a><a href="search.htm">??</a>
                          <%}%></td>
                      </tr>
                  </table></td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td width="136">&nbsp;</td>
            <td width="30"><img src="img/button.gif" width="30" height="30"></td>
            <td width="70"><div align="center"><a href="login.asp">
                <%if (Session("login")==false){%>
?? </a>
                    <%}%>
            </div></td>
            <td width="30"><img src="img/button.gif" width="30" height="30"></td>
            <td width="70"><div align="center"><a href="reg1.asp">??</a></div></td>
            <td width="30"><img src="img/button.gif" width="30" height="30"></td>
            <td width="124"><a href="logout.asp" class="style9">   
                  <%if (Session("login")==true){%>
??</a>
                <%}%></td>
          </tr>
      </table></td>
    </tr>
  </table>
  <table width="80%"  border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td background="img/bg4.gif"><div align="center"><img src="img/line.gif" width="722" height="3"></div></td>
    </tr>
  </table>
  <table width="80%"  border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="62%" height="30" background="img/bg4.gif">&nbsp;</td>
      <td width="4%" background="img/bg4.gif"><img src="img/button.gif" width="30" height="30"></td>
      <td width="18%" background="img/bg4.gif"><div align="center"><span class="style4">????</span><span class="style3"><%=Application("online")%></span><span class="style4">?</span></div></td>
      <td width="4%" background="img/bg4.gif"><img src="img/button.gif" width="30" height="30"></td>
      <td width="12%" background="img/bg4.gif">&nbsp;</td>
    </tr>
  </table>
<span class="style8">搜索结果如下:</span></div>
<%var i=0;while(!rs.EOF &&i<rs.PageSize ) {
var us=Server.CreateObject("ADODB.Recordset");
var usql="select * from user where username='"+rs("from")+"'";
us.Open(usql,conn);%>
<table width="60%" height="161" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" class="thin">
  <tr>
    <td width="15%" height="22" bgcolor="#333333" class="unnamed1"><img src="img/home.gif" width="16" height="21">访客信息</td>
    <td width="85%" bgcolor="#333333" class="unnamed1"><img src="img/ao.gif" width="16" height="18" title="<%=rs("title")%>">留言主题:<%=rs("title")%> <img src="img/oicq.gif" width="45" height="18" title="<%=us("QQ")%>">:<%=us("QQ")%> <img src="img/mail.gif" width="16" height="16" title="<%=us("email")%>">邮箱:<%=us("email")%> <a href="<%=us("home")%>"><img src="img/homepage.gif" width="47" height="18" border="0" title="<%=us("home")%>"></a>:<%=us("home")%> </a></td>
  </tr>
  <tr>
    <td bgcolor="#666666"><table width="139" height="140" border="0" cellpadding="0" cellspacing="0" bgcolor="#666666" class="unnamed1">
        <tr>
          <td height="21" valign="top" bgcolor="#666666">头像:</td>
        </tr>
        <tr>
          <td height="70" align="center" valign="top"><img src="<%=us("face")%>" title="<%=us("username")%>"> </td>
        </tr>
        <tr>
          <td height="20" bgcolor="#666666">★<%=us("nickname")%>★<img src="face/<%=us("sex")%>.gif" width="21" height="21"></td>
        </tr>
    </table></td>
    <td colspan="2"><table height="89" border="0" cellpadding="￡°" cellspacing="￡°" class="unnamed1">
      <tr>
        <td width="559" align="left"><p>留言:</p>          </td>
      </tr>
      <tr>
        <td><p><br>
          <%=rs("content")%><img src="emot/<%=rs("emot")%>" width="19" height="19"></p>          </td>
      </tr>
      <tr>
        <td height="29" align="right"><p>「<%=us("username")%>」发表于:<%=rs("time")%><br>
          --------------------------------------------------------------<br>
		 <%if(Session("login")==true){%>
		 <a href=reply.asp?id=<%=rs("id")%>>回复本贴</a>&nbsp;<a href=del.asp?id=<%=rs("id")%>>删除本贴</a>
		 <%}%>
        </p>          </td>
      </tr>
    </table></td>
  </tr>
</table>
<%
var rrs=Server.CreateObject("ADODB.Recordset");
var sql="select * from reply where title="+rs("id")+"";
rrs.Open(sql,conn,3,3);
while(!rrs.EOF)
{
%><table width="60%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" class="thin">
  <tr>
    <td width="15%" bgcolor="#333333" class="unnamed1" scope="row">回复</td>
    <td height="50" class="unnamed1"><%=rrs("content")%>&nbsp;</td>
  </tr>
  <tr>
    <td bgcolor="#333333" scope="row">&nbsp;</td>
    <td align="right" bgcolor="#333333" class="unnamed1">「<%=rrs("replyid")%>」回复于:<%=rrs("time")%><div align="right"></div></td>
  </tr>
</table>

<div align="left">
  <%

  rrs.MoveNext();
  i++;
  }rrs.Close();
  %>
  <%
us.Close();
  rs.MoveNext();
  i++;
  }
  %>
  <br>
    <span class="unnamed1"> </span>
</div>
<div align="center"><span class="unnamed1"><br>
  </span>
    <table width="80%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><div align="center"><img src="img/line.gif" width="650" height="3"></div></td>
      </tr>
    </table>
    <br>
  <br>
  <span class="unnamed1">Powered By:Kunta. Wang<br>
All Rights Rerserves&copy;</span></div>