我只是想知道下面的代碼是否最有效地使用 php/sql 中的數據庫信息填充下拉列表。 //GET ALL SONGS FROM DATABASE $query = $dbConn->query("SELECT track_id, track_title FROM track"); echo '<select class="feild" name="songDrop">';//MAKE THE DROPDOWN echo '<option value="none">Choose the Song to add</option>'; // Loop through the query results, displaying the options one by one while ($row = $query->fetch_assoc()) { echo '<option value="'.$row['track_id'].'">'.$row['track_title'].'</option>'; } echo '</select>';
1 回答
慕田峪7331174
TA貢獻1828條經驗 獲得超13個贊
嘗試這個 ：
//GET ALL SONGS FROM DATABASE
$query = $dbConn->query("SELECT track_id, track_title FROM track");
echo '<select class="feild" name="songDrop">';//MAKE THE DROPDOWN
echo '<option value="none">Choose the Song to add</option>';
// Loop through the query results, displaying the options one by one
while ($row = mysqli_fetch_array($query)) {
echo '<option value="'.$row['track_id'].'">'.$row['track_title'].'</option>';
}
echo '</select>';
- 1 回答
- 0 關注
- 115 瀏覽
添加回答
舉報
0/150
提交
取消