(PDO）UPDATE 不会使用 WHERE 变量进行更新 - (PDO) UPDATE doesn't update with WHERE variable

(PDO) UPDATE doesn't update with WHERE variable

本文关键字：变量 WHERE 更新 PDO UPDATE | 更新日期: 2023-09-27

我在这里的问题是，一旦我有公会名称的 WHERE 它就不起作用。它根本不更新任何内容。
一旦我有了id=1(有100个公会，所以设置id=1不是一个选项(，它就会起作用。

$form           = $_POST;
$boss           = $form['bossname'];
$gname          = $form['guildname'];
$screen         = $form['screenshot'];
$log            = $form['logs'];
$defeat         = $form['defeat'];
if(isset($_POST['edit-guild'])){
    $Statement = $conn->prepare("UPDATE $boss SET `Bossname` =:boss, `GuildName` =:gname, `Screenshot` =:screen, `Link` =:link, `KillTime` =:defeattime, `KillYN` =:kill WHERE `GuildName`=:gname");
    // EXECUTING ARRAY FOR ^GUILD INFORMATION
    $Statement->execute(array(
        "boss"          => $boss,
        "gname"         => $gname,
        "screen"        => $screen,
        "link"          => $log,
        "defeattime"    => $defeat,
        "kill"          => 'Yes'
        ));
}

一旦我有 WHERE id=1，它就可以工作。

 $Statement = $conn->prepare("UPDATE $boss SET `Bossname` =:boss, `GuildName` =:gname, `Screenshot` =:screen, `Link` =:link, `KillTime` =:defeattime, `KillYN` =:kill WHERE id=1");

如前所述，您不能重复使用相同的参数。尝试给它一个不同的名称：

if(isset($_POST['edit-guild'])){
    $Statement = $conn->prepare("UPDATE $boss SET `Bossname` =:boss, `GuildName` =:gname, `Screenshot` =:screen, `Link` =:link, `KillTime` =:defeattime, `KillYN` =:kill WHERE `GuildName`=:gname2");
    // EXECUTING ARRAY FOR ^GUILD INFORMATION
    $Statement->execute(array(
        "boss"          => $boss,
        "gname"         => $gname,
        "gname2"         => $gname,
        "screen"        => $screen,
        "link"          => $log,
        "defeattime"    => $defeat,
        "kill"          => 'Yes'
        ));
}

从更新集中删除gname字段。

$Statement = $conn->prepare("UPDATE $boss SET `Bossname` =:boss, `Screenshot` =:screen, `Link` =:link, `KillTime` =:defeattime, `KillYN` =:kill WHERE `GuildName`=:gname");

如果您认为gname在更新SET中很重要，您可以尝试其他名称或尝试更改条件另一个字段的位置，例如id