在下拉php mysql中列出枚举值

ALTER TABLE users ADD COLUMN gender ENUM('male', 'female', 'other');

<?php
// 连接MySQL数据库
$conn = new mysqli('localhost', 'username', 'password', 'database');

// 查询枚举值
$sql = "SHOW COLUMNS FROM users WHERE Field = 'gender'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();

// 解析枚举值
$enum_values = explode(',', str_replace("'", '', substr($row['Type'], 5, -1)));

// 生成下拉列表
echo<select name="gender">';
foreach ($enum_values as $value) {
    echo<option value="' . $value . '">' . $value . '</option>';
}
echo '</select>';
?>