php - 带有 MySQL 链接的 HTML/PHP 表单选择选项

Question

我按照此处的上一个问题获得了一个下拉列表，其中包含指向 MySQL 的链接。它在没有表单的情况下工作，但在有表单的情况下，所有 room_id 都分散在一行中，而不是在下拉框中。关于如何解决它的任何想法？谢谢

//Creates a form for room_id
echo "<form action=''>";
echo "<select name='room_id'>";
//Creates drop down box to show the current rooms vacant
$sql = "SELECT * FROM room";
$sql.= " WHERE room_vacant = 1";
$stmt = $dbh->query($sql);
echo "<select name='room_id'>";
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "<option value='" . $row['room_id'] . "'>" . $row['room_id'] . "</option>";
} //Closes drop down box
echo "</select>";

//Submit button
echo "<input type='submit' value='Submit'>";

//Closes form
echo "</form>";

Answer 1

原因是您回显了两次选择。删除一个。

//Creates a form for room_id
echo "<form action=''>";
echo "<select name='room_id'>";
//Creates drop down box to show the current rooms vacant
$sql = "SELECT * FROM room";
$sql.= " WHERE room_vacant = 1";
$stmt = $dbh->query($sql);
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "<option value='" . $row['room_id'] . "'>" . $row['room_id'] . "</option>";
} //Closes drop down box
echo "</select>";

//Submit button
echo "<input type='submit' value='Submit'>";

//Closes form
echo "</form>";