更新正确输入的代码上的枚举值 - Update enum value on correctly entered code

Update enum value on correctly entered code

本文关键字：枚举代码更新输入 | 更新日期: 2023-09-27

卡了一会儿。我正在尝试做的是在验证码匹配时将 Enum 行的值更新为 yes。这里的代码..提前谢谢。

<?php
session_start();
include ('dbconnect.php');
$verify_code = $_POST['vercode'];
// To protect MySQL injection (more detail about MySQL injection)
$verify_code = mysqli_real_escape_string($conn, $verify_code);
//Select SQL query against table
$query = "SELECT Verify_Code FROM Member WHERE Verify_Code = '$verify_code';";
$result = mysqli_query($conn, $query) or die(mysqli_error());
while($row = mysqli_fetch_array($result)){
$update_query = "UPDATE Member SET Verified = 'yes' WHERE Verify_Code = '$verify_code';";
echo $update_query;
//header("Location:TwitchMain.php");
}
?>

回

声语句带回更新成员集已验证 = "是"，其中 Verify_Code = "Q#icm";这是正确的代码。

您根本不需要运行 SELECT 查询！只需运行更新查询，如果数据库中有具有此验证码的成员，他就会被更新：

$verify_code = $_POST['vercode'];
$sql = "UPDATE Member SET Verified = 'yes' WHERE Verify_Code = ?";
if ($stmt = $conn->prepare($sql)) {
    $stmt->bind_param("s", $verify_code);
    $stmt->execute();
}