search.asp

本源代码为大学生购物网的源代码,欢迎大家的下载,学习与交流

<TABLE width="760" class=page border=0 align="center" cellPadding=0 cellSpacing=0>
  <TBODY>
    <TR> 
      <TD>
<!--#include file="top.asp"-->
<TABLE width=760 border=0 align=center cellSpacing=0 cellPadding=0>
  <TBODY>
    <TR> 
     <TD vAlign=top  width=173><!--#include file="left.asp"-->
         </TD><td bgcolor="#59be48" width="1"></td>

      <TD vAlign=top>
<%
if request.form("keyword")="" then
response.write "<script language='javascript'>" & VbCRlf
response.write "alert('请输入您要搜索的关键字!');" & VbCrlf
response.write "history.go(-1);" & vbCrlf
response.write "</script>" & VbCRLF
else
keyword =request.form("keyword")
Set rs= conn.execute("select * from goods_info where goods_name like '%"&keyword&"%'  order by goods_id desc" ) 
if rs.eof or rs.bof then
%>
        <div align="center">
        <TABLE cellSpacing=1 cellPadding=0 width="550" border=0 bgcolor="#59BE48">
          <TBODY>
            <TR> 
              <TD bgColor=#E4F4E1 height=21> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                  <TBODY>
                    <TR> 
                      <TD align=middle width=25>
						<img border="0" src="images/news.gif" width="15" height="15"></TD>
                      <TD>对不起！</TD>
                      <TD width=90>　</TD>
                    </TR>
                  </TBODY>
                </TABLE></TD>
            </TR>
            <TR> 
              <TD align="center" bgcolor="#FFFFFF">没有找到任何商品！</TD>
            </TR>
          </TBODY>
        </TABLE>
</div>
<%else%>
        <div align="center">
        <TABLE cellSpacing=1 cellPadding=0 width="550" border=0 bgcolor="#59BE48">
          <TBODY>
            <TR> 
              <TD bgColor=#E4F4E1 height=21> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                  <TBODY>
                    <TR> 
                      <TD align=middle width=25>
						<img border="0" src="images/news.gif" width="15" height="15"></TD>
                      <TD>商品搜索</TD>
                      <TD width=90>　</TD>
                    </TR>
                  </TBODY>
                </TABLE></TD>
            </TR>
            <TR> 
              <TD align="center"><table width="100%" border="0" cellpadding="4" style="border-collapse: collapse">
<% do while not rs.eof%>
                  <tr> 
                    <td height=18 bgcolor="#FFFFFF" >&nbsp; ·<a href="goods_info.asp?goods_id=<%=rs("goods_id")%>" target="_blank"><%=rs("goods_name")%></a></td>
                    <td align="right" bgcolor="#FFFFFF" ><font color="#999999">(<%=rs("goods_date")%>)</font></td>
                    <% 
rs.movenext 
loop 
rs.close 
set rs=nothing 
%>
                  </tr>
                </table></TD>
            </TR>
          </TBODY>
        </TABLE>
</div>
<%end if%>
<%end if%>
        </TD>
    </TR>
  </TBODY>
</TABLE>
<!--#include file="bottom.asp"--></TD>
            </TR>
          </TBODY>
        </TABLE>