多个关联下拉框值的变化

mac2022-06-30  23

<!--#include file="conn.asp"--><!--#include file="webconfig.asp"--><!--#include file="fuction.asp"--><html><head><title><%=webname%>--高级搜索</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link href="images/css.css" rel="stylesheet" type="text/css"></head><style>td{font-size:9pt;line-height:120%;color:#353535} body{font-size:9pt;line-height:120%}

a:link          { color: #000000; text-decoration: none }a:visited       { color: #000000; text-decoration: none }a:active        { color: #000000; text-decoration: none }a:hover         { color: #336699; text-decoration: none; position: relative; right: 0px; top: 1px }</style><body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onMouseOver="window.status='【<%=webname%>】<%=weburl%> 如果您喜欢本站,别忘了把本站介绍给您的好友哦!:)';return true"><!--#include file="webtop.asp"--><table width="760" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#EDECEC">  <tr>     <td bordercolor="#FFFFFF" bgcolor="#FFFFFF">       <table border="0" align="center" cellpadding="0" cellspacing="0" width="480">        <tr>           <td valign="top"> <br>            <div align="center">              <p><font color="#FF0000"><b><img src="images/logo/logo_1.gif" width="108" height="99"></b></font></p>              <p><font color="#FF0000"><b>商品高级搜索</b></font> </p>              <table border="0" cellspacing="0" cellpadding="1" align="center" width="489">                <tr>                   <td>                     <table width="60%" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#FFFFFF">                      <form name="form2" method="post" action="research.asp">                        <tr>                           <td width="36%" style="padding-left:6px">                             <div align="center">关 健 字:</div>                          </td>                          <td width="64%"  style="padding-left:6px">                             <input name="searchkey" type="text" id="searchkey">                          </td>                        </tr>                        <tr>                           <td style="padding-left:6px" width="36%">                             <div align="center">查找方式:</div>                          </td>                          <td style="padding-left:6px" width="64%">   <script> var selects111=[];<%dim i set rs=server.createobject("adodb.recordset") rs.open "select * from Pingpai order by pingpaiorder",conn,1,1 '有大类%> selects111['2']=new Array(<% if rs.recordcount>0 then     for i=1 to rs.recordcount  if i=rs.recordcount then %>  new Option('<%=trim(rs("pingpainame"))%>','<%=trim(rs("pingpainame"))%>'));<%  else%>  new Option('<%=trim(rs("pingpainame"))%>','<%=trim(rs("pingpainame"))%>'),<%  end if  rs.movenext  next else %>  new Option('',''));<% end ifrs.closeset rs=nothing

 set rs=server.createobject("adodb.recordset") rs.open "select * from shihe order by shiheorder",conn,1,1 '有大类%> selects111['3']=new Array(<% if rs.recordcount>0 then     for i=1 to rs.recordcount  if i=rs.recordcount then %>  new Option('<%=trim(rs("shihename"))%>','<%=trim(rs("shihename"))%>'));<%  else%>  new Option('<%=trim(rs("shihename"))%>','<%=trim(rs("shihename"))%>'),<%  end if  rs.movenext  next else %>  new Option('',''));<% end ifrs.closeset rs=nothing%>

function showselect(){if (document.form2.action.value=="2") { T_select.style.display = ""; //加入内容  with (document.form2){   if(action.value) {    selectname.options.length=0;    for(var i=0;i<selects111[action.value].length;i++){     selectname.add(selects111[action.value][i]);    }   }  }}else{ T_select.style.display = "none";} }</script>                            <table border="0" cellspacing="0" cellpadding="0">                              <tr>                                <td>                                   <select name="action" id="action" onChange="showselect();">                                    <option value="1" selected>商品名称</option>                                    <option value="2">品牌</option>                                    <option value="3">内容简介</option>                                  </select>                                </td>                                <td>                                   <table border="0" cellspacing="0" cellpadding="0" id=T_select style="DISPLAY: none">                                    <tr>                                       <td>                                         <select name="selectname">                                        </select>                                      </td>                                    </tr>                                  </table>                                </td>                              </tr>                            </table>                          </td>                        </tr>                        <tr>                           <td style="padding-left:6px" width="36%">                             <div align="center">价格范围:</div>                          </td>                          <td style="padding-left:6px" width="64%">                             <select name="jiage" id="jiage">                              <option value="20">20元以下</option>                              <option value="30">30元以下</option>                              <option value="50" selected>50元以下</option>                              <option value="100">100元以下</option>                              <option value="500">500元以下</option>                              <option value="1000">1000元以下</option>                              <option value="10000">10000元以下</option>                              <option value="100000">100000元以下</option>                            </select>                          </td>                        </tr>                        <tr>                           <td height="18" style="padding-left:6px" width="36%">                             <div align="center">商品分类:</div>                          </td>                          <td style="padding-left:6px" width="64%">                             <%set rs=server.CreateObject("adodb.recordset")    rs.open "select * from shop_anclass order by anclassidorder",conn,1,1    %>                            <select name="anclassid">                              <option value="0">查讯所有分类</option>                              <%do while not rs.eof%>                              <option value="<%=rs("anclassid")%>"><%=trim(rs("anclass"))%></option>                              <%rs.movenext    loop    rs.close    set rs=nothing%>                            </select>                          </td>                        </tr>                        <tr>                           <td height="18" colspan="2" style="padding-left:6px">                             <div align="center">                               <input type="image" border="0" name="submit" src="images/kscx.gif" width="54" height="18" onClick="return checkk();">                            </div>                          </td>                        </tr>                      </form>                    </table>                  </td>                </tr>              </table>              <br>            </div>          </td>        </tr>      </table>      <br>    </td>  </tr></table><!--#include file="service1.asp"--><!--#include file="copyright.asp"--></body></html><SCRIPT LANGUAGE="JavaScript"><!--function checkspace(checkstr) {  var str = '';  for(i = 0; i < checkstr.length; i++) {    str = str + ' ';  }  return (str == checkstr);}function checkk(){   if(checkspace(document.form2.searchkey.value)&&((document.form2.action.value=="3")||(document.form2.action.value=="1")))  { document.form2.searchkey.focus(); alert("请输入查讯关键字!"); return false;  }   document.form2.submit();}

//--></script>

转载于:https://www.cnblogs.com/hotsoho.net/archive/2004/10/19/54374.html

相关资源:conn连接方法大全
最新回复(0)