search.asp

自做的购物网站

      <TD vAlign=top width=606> 
      <TABLE border=0 cellPadding=0 cellSpacing=0 width=570 height="41">
        <TBODY> 
        <TR> 
              <TD> 
            <TABLE border=0 cellPadding=0 cellSpacing=0 width=570>
              <TBODY> 
              <TR> 
                      <TD colSpan=3> <TABLE border=0 cellPadding=0 cellSpacing=0>
                          <TBODY>
                            <TR> 
                              
                      <TD rowSpan=2 width=468><div align="center"><iframe src="admin/Ad.asp" width=570 height=120 border=0 frameborder=0 framespacing=0 marginheight=0 marginwidth=0 noResize scrolling=no vspace="0"></iframe></div></TD>
                            </TR>
                          </TBODY>
                        </TABLE></TD>
                    </TR>
                    <TR> 
                      
                <TD colSpan=3> 
                  <table border=0 cellpadding=0 cellspacing=0 width=570>
                    <tbody> 
                    <tr> 
                      <td><img height=35 src="images/pics2/wp_sbox_01.gif" 
                        width=5></td>
                      <td background=images/pics2/wp_sbox_02.gif width=596> 
                        <form action="search.asp" method="post" name="form" id="form">
                          <table width="550" border=0 align=left cellpadding=0 cellspacing=0>
                            <tbody> 
                            <tr> 
                              <td width=95><font color=#666666><img 
                              height=20 src="images/pics2/wp_sbox_search_pp2.gif" 
                              width=94></font></td>
                              <td width="84" align=right> 
                                <div align="center"> 
                                  <input type="text" name="hw_name" size="20" class=input>
                                </div>
                              </td>
                              <td width="85" align=right> 
                                <%
sql = "select * from sort"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "请先添加栏目。"
response.end
else%>
                                <select name="sort_id" size="1">
                                  <option selected value="">所有</option>
                                  <% dim selclass
selclass=rs("sort_id")
do while not rs.eof
%>
                                  <option value="<%=trim(rs("sort_id"))%>"><%=trim(rs("sort_name"))%></option>
                                  <%rs.movenext
loop
end if
rs.close
%>
                                </select>
                              </td>
                              <td width=62> 
                                <div align="center"> 
                                  <input type="image" border="0" name="imageField" src="IMAGES/pics2/wp_sbox_bt_search.gif" width="51" height="19">
                                </div>
                              </td>
                              <td width=30> 
                                <div align="right"><img src="IMAGES/pics2/icon_money.gif" width="19" height="13"></div>
                              </td>
                              <td width=42 valign="middle"> 
                                <div align="center">原价</div>
                              </td>
                              <td width=15> 
                                <div align="right"><img src="IMAGES/pics2/icon_unisex.gif" width="14" height="13"></div>
                              </td>
                              <td width=60> 
                                <div align="center">会员价</div>
                              </td>
                              <td width=15> 
                                <div align="right"><img src="IMAGES/pics2/icon_heart.gif" width="14" height="12"></div>
                              </td>
                              <td width=60> 
                                <div align="center">贵宾价</div>
                              </td>
                            </tr>
                            </tbody> 
                          </table>
                        </form>
                      </td>
                      <td><img height=35 src="images/pics2/wp_sbox_03.gif" 
                        width=5></td>
                    </tr>
                    </tbody> 
                  </table>
                </TD>
                    </TR>
                  </TBODY>
                </TABLE></TD>
            </TR>
            <TR> 
              <TD height=6></TD>
            </TR>
          </TBODY>
        </TABLE>
        
      <table width="570" border="0" cellpadding="0" cellspacing="0">
        <tr> 
            
          <td height="2" width="14%" valign="top" background="images/pics2/top_bg.gif">&nbsp;</td>
            <td height="2" width="60%" background="images/pics2/top_bg.gif" valign="top">&nbsp;</td>
            <td height="2" width="4%" align="right" valign="top"><img src="images/pics2/join.gif" width="56" height="41"></td>
            <td height="2" width="10%" align="right" valign="top"><a href="ding1.asp"><img src="images/pics2/avarta_bu.gif" width="128" height="41" border="0"></a></td>
            <td height="2" width="12%" align="right" valign="top"><a href="ding2.asp"><img src="images/pics2/item_bu.gif" width="129" height="41" border="0"></a></td>
          </tr>
          <tr> 
            <TD height=6></TD>
          </tr>
        </table>
        
      <TABLE border=0 cellPadding=0 cellSpacing=0 width=570>
        <TBODY> 
        <TR> 
              
          <TD width="606"><img src="IMAGES/pics2/commoditysearch.gif" width="570" height="24"></TD>
            </TR>
            <TR> 
              <TD height="67"><table border="0" width="75%" cellspacing="0" cellpadding="0" height="5" align="center">
                  <br>
                <%
                if request.form("sort_id")="" then%>
                <%hw_name=request("hw_name")
    sql="select * from hw where hw_name like '%"&hw_name&"%' order by hw_id DESC"
    rs.open sql,conn,3,3
    %>
                <%else%>
                <%sort_id=request.form("sort_id")
    hw_name=request("hw_name")
	sql="select * from hw where  hw_name like '%"&hw_name&"%' and sort_id="&request.form("sort_id")
  sql=sql&" order by hw_id DESC"
    rs.open sql,conn,3,3 
	end if
    if rs.eof then
    %>
                  <tr> 
                    <td width="100%">没有你要找的商品，请先确定商品的类别</td>
                  </tr>
                  <%else%>
                  <tr> 
                    <td>&nbsp;</td>
                  </tr>
                  <%do while not rs.eof %>
                  <tr> 
                    <td><a href="views.asp?hw_id=<%=rs("hw_id")%>"> <b class="dz1"> 
                      <%
name=rs("hw_name")
name=replace(name,hw_name,"<font color=red>"&hw_name&"</font>")
response.write name
%>
                      </b> </a></td>
                  </tr>
                  <%rs.movenext
loop
end if
rs.close
%>
                </table> </TD>
            </TR>
          </TBODY>
        </TABLE></TD>
    </TR>
    <TR> 
      <TD colSpan=3 height=28>&nbsp;</TD>
    </TR>
  </TBODY>
</TABLE>
<!--#include file="copy.asp"-->