在mysqli中编辑记录时，在下拉列表中显示以前选择的值

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据库中的选项值
$sql = "SELECT id, name FROM options";
$result = $conn->query($sql);

// 生成下拉列表
echo "<select name='option'>";
while ($row = $result->fetch_assoc()) {
    $id = $row['id'];
    $name = $row['name'];
    $selected = ($id == $_POST['option']) ? 'selected' : ''; // 判断是否为以前选择的值

    echo "<option value='$id' $selected>$name</option>";
}
echo "</select>";

// 更新数据库记录
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $option = $_POST['option'];

    // 更新数据库中的记录
    $sql = "UPDATE table SET option='$option' WHERE id=1";
    if ($conn->query($sql) === TRUE) {
        echo "记录更新成功";
    } else {
        echo "记录更新失败: " . $conn->error;
    }
}

$conn->close();
?>