尝试在PHP中按ID从SQL中拉出整行

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

$id = $_GET['id']; // 假设从URL参数中获取ID值

// 构建SQL查询语句
$sql = "SELECT * FROM users WHERE id = ?";

// 使用预处理语句
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $id); // "i"表示参数为整数类型
$stmt->execute();

$result = $stmt->get_result();
$row = $result->fetch_assoc();

if ($row) {
    echo "ID: " . $row['id'] . "<br>";
    echo "姓名: " . $row['name'] . "<br>";
    echo "年龄: " . $row['age'] . "<br>";
    // 其他列...
} else {
    echo "未找到匹配的行";
}