查看完整版本: 多重條件組合查詢(一)

多重條件組合查詢(一)

<P><BR>現在我們設想要建一個查詢系統,讓用戶即可根据訂單編號,也可根据類別,或者根据价格,或者其中的各自組合來實現快速查詢,代號如下:&nbsp; <BR>下面此部分是顯示查詢條件的窗体&nbsp; </P>
<P>&lt;html&gt;&nbsp; <BR>&lt;?&nbsp; <BR>$linkstr=mysql_connect("localhost","root","sa");&nbsp; <BR>mysql_select_db("cx",$linkstr);&nbsp; <BR>?&gt;&nbsp; <BR>&lt;[url=http://whatis.ctocio.com.cn/searchwhatis/425/5948925.shtml]script[/url] language="JavaScript"&gt;&nbsp; <BR>function variable()&nbsp; <BR>{&nbsp; <BR>if (document.search.select1.value!="1")&nbsp; <BR>{&nbsp; <BR>if (document.search.no.value=="")&nbsp; <BR>{&nbsp; <BR>window.alert("請輸入訂單號碼!");&nbsp; <BR>return false;&nbsp; <BR>}&nbsp; <BR>else&nbsp; <BR>{&nbsp; <BR>if (document.search.type.value=="")&nbsp; <BR>{&nbsp; <BR>window.alert("請選擇配件類別!");&nbsp; <BR>return false;&nbsp; <BR>}&nbsp; <BR>}&nbsp; <BR>}&nbsp; <BR>else&nbsp; <BR>{&nbsp; <BR>if (document.search.select2.value!="1")&nbsp; <BR>{&nbsp; <BR>if (document.search.price.value=="")&nbsp; <BR>{&nbsp; <BR>window.alert("請輸入价格!");&nbsp; <BR>return false;&nbsp; <BR>}&nbsp; <BR>}&nbsp; <BR>}&nbsp; <BR>}&nbsp; <BR>&lt;/script&gt;&nbsp; <BR>&lt;br&gt;&nbsp; <BR>&lt;center&gt;&lt;[url=http://whatis.ctocio.com.cn/searchwhatis/451/5947951.shtml]font[/url] size="5"&gt;&lt;b&gt;多重條件組合查詢&lt;/b&gt;&lt;/font&gt;&lt;/center&gt;&nbsp; <BR>&lt;br&gt;&nbsp; <BR>&lt;body&gt;&nbsp; <BR>&lt;form action="searchjg.php" [url=http://whatis.ctocio.com.cn/searchwhatis/229/5948729.shtml]method[/url]="[url=http://whatis.ctocio.com.cn/searchwhatis/229/6026229.shtml]POST[/url]" name="search" onsubmit="return variable(this.value)"&gt;&nbsp; <BR>&lt;[url=http://whatis.ctocio.com.cn/searchwhatis/456/6028456.shtml]table[/url] align="center" border="1" width="400"&gt;&nbsp; <BR>&lt;tr&gt;&nbsp; <BR>&lt;td align="left" width="100"&gt;訂單編號&lt;/td&gt;&nbsp; <BR>&lt;td align="left" width="300"&gt;&lt;input type="[url=http://whatis.ctocio.com.cn/searchwhatis/162/6092662.shtml]text[/url]" name="no"&gt;&lt;/td&gt;&nbsp; <BR>&lt;/tr&gt;&nbsp; <BR>&lt;tr&gt;&nbsp; <BR>&lt;td align="left" width="200"&gt;&nbsp; <BR>&lt;select name="select1"&gt;&nbsp; <BR>&lt;option selected value="1"&gt;&nbsp; <BR>&lt;option value="2"&gt;或者&nbsp; <BR>&lt;option value="3"&gt;而且&nbsp; <BR>&lt;/select&gt;類別為&nbsp; <BR>&lt;/td&gt;&nbsp; <BR>&lt;td align="left" width="200"&gt;&nbsp; <BR>&lt;select name="type"&gt;&nbsp; <BR>&lt;option selected&gt;&nbsp; <BR>&lt;?&nbsp; <BR>$querystring="select distinct type from orders ";&nbsp; <BR>$result=mysql_query($querystring,$linkstr);&nbsp; <BR>while (list($type)=mysql_fetch_row($result))&nbsp; <BR>{&nbsp; <BR>echo "&lt;option value="$type"&gt;".$type;&nbsp; <BR>}&nbsp; <BR>?&gt;&nbsp; <BR>&lt;/select&gt;&nbsp; <BR>&lt;/tr&gt;&nbsp; <BR>&lt;tr&gt;&nbsp; <BR>&lt;td&gt;&nbsp; <BR>&lt;select name="select2"&gt;&nbsp; <BR>&lt;option selected value="1"&gt;&nbsp; <BR>&lt;option value="2"&gt;或者&nbsp; <BR>&lt;option value="3"&gt;而且&nbsp; <BR>&lt;/select&gt;价格位在&nbsp; <BR>&lt;/td&gt;&nbsp; <BR>&lt;td&gt;&lt;select name="price"&gt;&nbsp; <BR>&lt;option selected&gt;&nbsp; <BR>&lt;option value="1"&gt;50以下&nbsp; <BR>&lt;option value="2"&gt;50~200?&nbsp; <BR>&lt;option value="3"&gt;200以上&nbsp; <BR>&lt;/select&gt;的配件&nbsp; <BR>&lt;/td&gt;&nbsp; <BR>&lt;/tr&gt;&nbsp; <BR>&lt;table width="400" align="right"&gt;&nbsp; <BR>&lt;tr&gt;&nbsp; <BR>&lt;td&gt;&nbsp; <BR>&lt;input type="submit" name="submit" value="開始查詢"&gt;&nbsp; <BR>&lt;/td&gt;&nbsp; <BR>&lt;/tr&gt;&nbsp; <BR>&lt;/table&gt;&nbsp; <BR>&lt;/table&gt;&nbsp; <BR>&lt;/form&gt;&nbsp; <BR>&lt;/body&gt;&nbsp; <BR>&lt;/html&gt;<BR></P>