我创建了一个下拉菜单,当单击下拉栏中类别上的选项时,它可以链接到我的产品页面,但我未能链接它们,有人知道我的代码中的问题是什么吗?
enter code here
$link=mysql_connect("localhost","root","")or die("Can't Connect...");
mysql_select_db("fyp",$link) or die("Can't Connect to Database...");
$query="select * from category ";
$res=mysql_query($query,$link);
while($row=mysql_fetch_assoc($res))
{
echo "<option value='product.php category=".$roww['$cat_id']."'>".$row['cat_nm'];///here is the problem
$qq = "select * from subcat where parent_id=".$row['cat_id'];
$ress = mysql_query($qq,$link) or die("wrong delete subcat query..");
while($roww = mysql_fetch_assoc($ress))
{
echo "<option value='".$roww['subcat_id']."'> ---> ".$roww['subcat_nm'];//here is the problems
}
}
mysql_close($link);
?>
输入图片描述
尝试使用mysqli代替mysql, mysql已被弃用(建议)
$link=mysqli_connect("localhost","root","")or die("Can't Connect...");
mysqli_select_db($link,"fyp") or die("Can't Connect to Database...");
$query="select * from category";
<select onselect='goUrl(this.value)' id="cval" name="cval">
$res=mysqli_query($link,$query);
while($row=mysqli_fetch_assoc($res))
{
echo "<option value='".$row['cat_id']."'>".$row['maincatname']."</option>";
$qq = "select * from subcat where parent_id=".$row['cat_id'];
$ress = mysqli_query($link,$qq) or die("wrong delete subcat query..".mysqli_error($link));
while($roww = mysql_fetch_assoc($ress))
{
echo "----><option value='".$roww['subcat']."'>".$roww['subcatname']."</option>";
}
}
</select>
mysqli_close($link);
?>
<script>
function goUrl(catgry)
{
window.location.href='product.php?category='+catgry;
}
</script>
这样做,给url你想直接到值和添加onchange()
到<select>
。您错过了?
,哪个服务器作为查询参数,
echo "<option value='product.php category=".$roww['$cat_id']."'>".$row['cat_nm'];///here is the problem
^
应该是
echo "<option value='product.php?category=".$roww['$cat_id']."'>".$row['cat_nm'];///here is the problem
^
和
<select onchange="this.options[this.selectedIndex].value && (window.location = this.options[this.selectedIndex].value);">
<option value="">Select...</option>
<option value="product.php?category=".$roww['$cat_id']."">Product 1</option>
<option value="product.php?category=".$roww['$cat_id']."">Prosuct 2</option>
</select>
试试这个
$link=mysql_connect("localhost","root","")or die("Can't Connect...");
mysql_select_db("fyp",$link) or die("Can't Connect to Database...");
$query="select * from category ";
$res=mysql_query($query,$link);
while($row=mysql_fetch_assoc($res))
{
echo "<option value='product.php category=".$row['$cat_id']."'>".$row['cat_nm'];///here is the problem
$qq = "select * from subcat where parent_id=".$row['cat_id'];
$ress = mysql_query($qq,$link) or die("wrong delete subcat query..");
while($roww = mysql_fetch_assoc($ress))
{
echo "<option value='".$roww['subcat_id']."'> ---> ".$roww['subcat_nm'];//here is the problems
}
}
mysql_close($link);
?>