checksearch.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")="找不到相关记录！";
Response.Redirect("err.asp");
}










%><style type="text/css">
<!--
@import url("css.css");
body {
	background-image: url(img/bg3.gif);
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.unnamed1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #FF6633;
	text-decoration: none;
}
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: none;
}
.style1 {font-size: 18px}
.style5 {font-size: 12px}
.style6 {font-size: 12px; text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif;}
.unnamed2 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #CC6600;
	text-decoration: none;
}
.unnamed11 {	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #FF6633;
	text-decoration: none;
}
.style8 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #FFFFFF; text-decoration: none; }
.style3 {	color: #CCFF66;
	font-size: 14px;
}
.style4 {color: #3399CC}
.style9 {color: #333333}
-->
</style>
<div align="center">
  <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>
  <p class="unnamed1 style1"><span class="style8">???÷?á1?è???:</span></p>
</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">·??íD??￠</td>
    <td width="85%" bgcolor="#333333" class="unnamed1"><img src="img/ao.gif" width="16" height="18" title="<%=rs("title")%>">á????÷ìa:<%=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")%>"></p>          </td>
      </tr>
      <tr>
        <td height="29" align="right"><p>??<%=us("username")%>?1·￠±íóú:<%=rs("time")%><br>
          --------------------------------------------------------------<br>
		 <%if(Session("login")==true){%>
		 <a href=reply.asp?id=<%=rs("id")%>>???′±?ìù</a>&nbsp;<a href=del.asp?id=<%=rs("id")%>>é?3y±?ìù</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%" rowspan="2" bgcolor="#333333" class="unnamed1" scope="row">???′</td>
    <td class="unnamed1"><%=rrs("content")%>&nbsp;<img src="emot/<%=rrs("emot")%>"></td>
  </tr>
  <tr>
    <td align="right" bgcolor="#333333" class="unnamed1">??<%=rrs("replyid")%>?1???′óú:<%=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>
  <table width="80%"  border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td><div align="center"><img src="img/line.gif" width="650" height="3"></div></td>
    </tr>
  </table>
  <div align="center"></div>
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td><div align="center" class="unnamed1"><br>
Powered By:Kunta. Wang<br>
All Rights Rerserves&copy;</div></td>
    </tr>
</table>
<span class="unnamed1">  </span>