php代码如下:
<!-- 类别选择框 -->
<form method ="get" action="/show_by_Price.php" target="showframe">
<select name="categories" onchange="submit()">
<option value="pleaseChoose" selected="selected">Please Choose</option>
<option value="Electronic">Electronic</option>
<option value="Book" >Book</option>
<option value="Fashion">Fashion</option>
</select>
</form>
<b font='Times New Roman'>Price:</b>
<br>
<!-- 产品价格选择框 -->
<form method ="get" action="/show_by_Price.php" target="showframe">
<select name="price" onchange="submit()">
<option value="Please_Choose" selected="selected">Please Choose</option>
<option value="hight">more than 2000</option>
<option value="middle" >1000~2000</option>
<option value="low">less than 1000</option>
</select>
</form>show_by_Price.php关键处理代码如下:
if ($_GET[categories]=='pleaseChoose'){
if ($_GET[price]=='Please_Choose'){
//$result_price=null;
echo Please_choose ;
}
else {
if ($_GET[price]=='hight'){
echo p_H ;
$result_price = mysql_query("SELECT * FROM Product where Price>2000");
}
elseif ($_GET[price]=='middle'){
echo p_M ;
$result_price = mysql_query("SELECT * FROM Product where Price<2000 && Price>1000");
}
else{
echo p_L ;
$result_price = mysql_query("SELECT * FROM Product where Price<1000");
}
}
}
else
{
if ($_GET[price]=='Please_Choose'){
echo C_P ;
$result_price = mysql_query("SELECT * FROM Product where Category='$_GET[categories]'");
}
else{
if ($_GET[price]=='hight'){echo C_H;
$result_price = mysql_query("SELECT * FROM Product where Price>2000 and Category='$_GET[categories]'");
}
elseif ($_GET[price]=='middle'){echo C_M;
$result_price = mysql_query("SELECT * FROM Product where (Price<2000 && Price>1000 )and Category='$_GET[categories]'");
}
else{echo C_L;
$result_price = mysql_query("SELECT * FROM Product where Price<1000 and Category='$_GET[categories]'");
}
}
}
为什么两个框都选择的是Please Choose的时候 ,执行的是echo p_L ;
$result_price = mysql_query("SELECT * FROM Product where Price<1000");
而不是echo Please_choose ;
求高手指点
<!-- 类别选择框 -->
<form method ="get" action="/show_by_Price.php" target="showframe">
<select name="categories" onchange="submit()">
<option value="pleaseChoose" selected="selected">Please Choose</option>
<option value="Electronic">Electronic</option>
<option value="Book" >Book</option>
<option value="Fashion">Fashion</option>
</select>
</form>
<b font='Times New Roman'>Price:</b>
<br>
<!-- 产品价格选择框 -->
<form method ="get" action="/show_by_Price.php" target="showframe">
<select name="price" onchange="submit()">
<option value="Please_Choose" selected="selected">Please Choose</option>
<option value="hight">more than 2000</option>
<option value="middle" >1000~2000</option>
<option value="low">less than 1000</option>
</select>
</form>show_by_Price.php关键处理代码如下:
if ($_GET[categories]=='pleaseChoose'){
if ($_GET[price]=='Please_Choose'){
//$result_price=null;
echo Please_choose ;
}
else {
if ($_GET[price]=='hight'){
echo p_H ;
$result_price = mysql_query("SELECT * FROM Product where Price>2000");
}
elseif ($_GET[price]=='middle'){
echo p_M ;
$result_price = mysql_query("SELECT * FROM Product where Price<2000 && Price>1000");
}
else{
echo p_L ;
$result_price = mysql_query("SELECT * FROM Product where Price<1000");
}
}
}
else
{
if ($_GET[price]=='Please_Choose'){
echo C_P ;
$result_price = mysql_query("SELECT * FROM Product where Category='$_GET[categories]'");
}
else{
if ($_GET[price]=='hight'){echo C_H;
$result_price = mysql_query("SELECT * FROM Product where Price>2000 and Category='$_GET[categories]'");
}
elseif ($_GET[price]=='middle'){echo C_M;
$result_price = mysql_query("SELECT * FROM Product where (Price<2000 && Price>1000 )and Category='$_GET[categories]'");
}
else{echo C_L;
$result_price = mysql_query("SELECT * FROM Product where Price<1000 and Category='$_GET[categories]'");
}
}
}
为什么两个框都选择的是Please Choose的时候 ,执行的是echo p_L ;
$result_price = mysql_query("SELECT * FROM Product where Price<1000");
而不是echo Please_choose ;
求高手指点
为什么只要有任何一个框 选择的是 Please Choose 就会出错?
其中一个选择了就会提交,这我知道,但是比如说 我选了category 是Book,Price不做选择,那为什么$_GET[price]会等于low呢?
出来的结果就是等于$_GET[price] 为low !
不好意思啊,刚开始学的php,
之前一直没弄明白,您说的是什么意思,刚刚试了下,非常感谢,
这个问题困扰我多时了!