阅读背景:

如何从数据库中获取数据到PHP MySQL中另一个选项的一个选择选项?

来源:互联网 

I have this code:

我有这个代码:

<html>
<body>
<form method="post" action="">
Category:   <select name="category">
<option>Choose Category</option>
<?php 
include("connect.php");
$select="SELECT * FROM category";
$result=mysqli_query($link,$select) or die (mysqli_error($link));

    while($row=mysqli_fetch_array($result))
    {

    echo "<option value='$row[category]'>".$row['category'];

    }
?>
</select>

<br>
Subcategory:<select name="category">
<?php
include("connect.php");

$category=@$_POST['category'];

if($category=="Friuts")
{
    $select="SELECT * FROM subcategory WHERE $category='$category'";
    $result=mysqli_query($link,$select) or die (mysqli_error($link));

    while($row=mysqli_fetch_array($result))
    {

    echo "<option value='echo $row[subcategory]'>".$row['subcategory'];

    }
}


?>

</select>
<br>

<input type="submit" value="Open" name="submit">
</form>
</body>
</html>
<html>
<body>
<fo



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: