php - PHP Select Dropdown 通过 mysql 过滤下一个下拉列表

Question

两张桌子......团队和球员。一旦通过 MYSQL 选择了一个团队，玩家下拉列表应该只显示那些在 Player 表中具有 TeamID 的玩家。一旦做出团队选择，我不确定如何“刷新/过滤”玩家下拉列表。

<td colspan="2">
<!--Teams should display from the Team table-->
<select name="myselectboxteams"> 
<option hidden selected>Select a team...</option>
<?php
    $sqlteams = "SELECT TeamName, TeamID FROM Team ORDER BY TeamName";
    $result = mysqli_query($link, $sqlteams);
    while ($row = mysqli_fetch_array($result)) {
        $teamid = $row["TeamID"];
        $teamname = $row["TeamName"];
        echo "<option value=\"{$teamid}\">{$teamname}</option>";
    }
?>
</select>    
</td>
</tr>
<tr>
<td><label for="PlayerID">Player ID:</label>
<td>
<!--Teams should display from the Player table-->
<select name="myselectboxplayer"> 
<option hidden selected>Select a player...</option>
<?php
    $sqlplayer = "SELECT PlayerID, FirstName, LastName, TeamID FROM Player ORDER BY PlayerID";
    $result = mysqli_query($link, $sqlplayer);
    while ($row = mysqli_fetch_array($result)) {
        $playerid = $row["PlayerID"];
        $playerfirstname = $row["FirstName"];
        $playerlastname = $row["LastName"];
        echo "<option value=\"{$playerid}\">{$playerfirstname} {$playerlastname} </option>";
    }
?>
</select>    
</td>

标签： phpmysqldropdown