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

📄 searchresult.asp

📁 一个不完整的硬件报价管理系统
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="inc/const1.asp"-->
<!--#include file="inc/const2.asp"-->
<!--#include file="inc/char.asp"-->
<html>
<head> 
<title>搜索结果----+----<%=lybtitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="css.asp"--></head>
</head>
<body topmargin="1" bgcolor="<%=bodybgcolor%>">
<!--#include file="top.asp"--><br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="650" align="center">
  <tr>
    <td width="100%"><font color="#800000">查询结果:</font><br>
 </td>
  </tr>
</table>
<%
dim keyword
keyword=trim(request.form("keyword"))
classid=request("classid")
set rs=server.createobject("adodb.recordset")
if classid="留言内容" then
sql="select * from guest where guestcontent like '%"&keyword&"%'"
else
sql="select * from guest where guestname like '%"&keyword&"%'"
end if
rs.open sql,conn,1,3
i=0
do while not rs.eof 
%>
<hr noshade width="650" color="#C0C0C0" size="1"> <table width="650"  bgcolor="<%=tablebgcolor%>"  cellspacing="0" cellpadding="0" border="1"  style="border-collapse: collapse" cellpadding="0" bordercolor="<%=bordercolor%>" align="center">                     
  <tr>                      
    <td bgcolor="<%=tablebgcolor%>" valign="top" rowspan="3" width="110" height="1" align="center">                      
      <table width="100%" border="0" cellspacing="0" cellpadding="0" height="164" bgcolor="<%=tablebgcolor%>" style="border-collapse: collapse" bordercolor="#111111">                     
        <tr>                      
          <td width="10" height="164"> </td>                     
          <td height="164" valign="top" bgcolor="<%=tablebgcolor%>"><br>
          <%if  rs("guestname")=admin_name then%>
          <img src="pic/teammo.gif">
          <%end if%>
          <span STYLE="position:relative; width:105; height:25; filter:glow(Color=<%=bordercolor%>,Strength=4); margin-left:2px">
          <p align="center"><font color="#FFFFFF"><%=rs("guestname")%></font></p>
            </span>
            <p align="center"><img src="images/<%=rs("face")%>"> </p>                     
            <% if rs("from")<>"" then %>                     
            來自:<%=rs("from")%>                          
            <%end if%>     <br>                    
          </td>                     
        </tr>                     
      </table>                     
    </td>                     
    <td height="18" bgcolor="<%=infobg%>">&nbsp;<img src="pic/posttime.gif"> 发表于:<%=rs("guestdate")%>&nbsp;<img src="images/blank.gif" width="110" height="1">                     
            <%if rs("email")<>"" then %>                     
            <a href="mailto:<%=rs("email")%>">                      
            <%end if %>                     
            <img src="pic/email.gif"  border="0">E-MAIL</a>&nbsp;<%if rs("homepage")<>"" then%>                     
            <a href="<%=rs("homepage")%>" target="blank">                      
            <%end if%><img src="pic/home.gif" border="0">主页</a>&nbsp;
            <% if rs("oicq")<>"" then%>                     
            <a href="http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=rs("oicq")%>" target="blank">                      
            <%end if%>                     
            <img src="pic/qq.gif"  border="0"></a>Q&nbsp;Q&nbsp;                    
            <a href="edit.asp?time=<%=rs("guestdate")%>"><img src="pic/edit.gif" border="0">编辑</a>                      
            &nbsp;</td>                     
  </tr>                     
  <tr>                      
    <td valign="top">                      
      <table width="100" align="center" style="table-layout: fixed" height="100%" cellspacing="0" cellpadding="0">                                       
<tr>                                        
<td style="word-break: break-word; font-size: 10pt"  width="511" bgcolor="<%=tablebgcolor%>" valign="top"><pre style="padding-left:4px;MARGIN-TOP:2px;MARGIN-BOTTOM:2px;MARGIN-LEFT:2px;MARGIN-RIGHT:2px;word-wrap: break-word">
<%
secretly=trim(rs("secretly"))
if secretly<>"" then
%>
<br>
<br>
<img src="images/hidden.gif"><font color="#800000">此留言为悄悄话,版主请进入管理后查看</font>
<br>
<%else%>
<%
guestcontent=ubbcode(rs("guestcontent"))
guestcontent=replace(guestcontent,chr(13),"<br>")
%>    

<p class="font">
<%if len(guestcontent)>88 or rs("guestreply")<>"" then %>
<%=guestcontent%>
<%else%> 
<br>
<br><%=guestcontent%><br><br><br></pre>
 
<%end if%>  
<%end if%>  
       <%if rs("guestreply")<>"" then %>
<p class="font"> <img border="0" src="images/Replynow.gif"><font color="#FF0000">回复:</font><p class="font"><%=ubbcode(rs("guestreply"))%> </p>
<p><font color="#666666">&nbsp; 回复时间:<%=rs("redate")%></font></p>       
            <%end if%></td></tr>                                 
</table>               
    </td>               
  </tr>               
  <tr>                
    <td height="1" valign="bottom" bgcolor="<%=infobg%>">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="537" bordercolorlight="#183EAD" bordercolordark="#183EAD">
      <tr>
        <td width="516" height="18"><img src="images/ip.GIF" width="15" height="13">IP:<%=left(rs("ip"),9)%>*<img src="images/blank.gif" width="200" height="1">
        </td>
        <td width="15">
        <p align="right"><a title="返回网页顶部" href="#top"><img src="images/gotop.gif" border="0" ></a></td>
      </tr>
    </table>
    </td>               
  </tr>               
</table>          
<%
rs.movenext
i=i+1
loop
%>


<div align="center">
  <center>
  <table border="0" width="88%">
    <tr>
      <td>
<p>&nbsp;共有<%=i%>条记录</p>

      </td>
    </tr>
    <tr>
      <td>

<p align="center"><a href="search.asp">继续搜索&gt;&gt;</a></td>
    </tr>
  </table>
  </center>
</div>
<p>
<br><!--#include file="bottom.asp"-->
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
  </body></html>

⌨️ 快捷键说明

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