MySQL Query不更新PHP数据库中的值

debugcn 发表于 Dev

DemCodeLines

我下面有一个if / else代码块，该代码块应根据情况调用具有特定参数的函数。该函数更新MySQL数据库中的特定值。但是，数据库值不会被更新。我究竟做错了什么？

以下是我的代码：

process.php

$success = false;

$homeScore = $_POST['home'];
$awayScore = $_POST['away'];
$homeTeamName = $_POST['homeTeam'];
$awayTeamName = $_POST['awayTeam'];

try {
    $win = 0;
    $loss = 0;

    // HOME TEAM
    if ($homeScore > $awayScore)
    {
        $win = 1; $loss = 0;
        updateStandings($db7, $homeTeamName, $win, $loss);
        $win = 0; $loss = 1;
        updateStandings($db7, $awayTeamName, $win, $loss);
    }
    // AWAY TEAM
    elseif ($awayScore > $homeScore)
    {
        $win = 1; $loss = 0;
        updateStandings($db7, $awayTeamName, $win, $loss);
        $win = 0; $loss = 1;
        updateStandings($db7, $homeTeamName, $win, $loss);
    }

    $success = $_SERVER['HTTP_REFERER'];
}
catch (Exception $e)
{
    $success="/error";
}
header("Location: " . $success);

function updateScore($db, $gameID, $home, $away)
{
    $db -> updateScoreForGame($gameID, $home, $away);
}
function updateStandings($db, $teamName, $win, $loss)
{
    $db -> updateLeagueStandings($teamName, $win, $loss);
}

updateLeagueStandings函数

public function updateLeagueStandings($teamName, $win, $loss) {
    try {
        $sth = $this -> db -> prepare("UPDATE teams SET wins = wins + (:winsNum), losses = losses + (:lossesNum) WHERE Name = `:teamName`");
        $sth->bindParam(':winsNum', $win, PDO::PARAM_INT);
        $sth->bindParam(':lossesNum', $loss, PDO::PARAM_INT);
        $sth->bindParam(':teamName', $teamName, PDO::PARAM_STR);
        $sth -> execute();
    } catch (Exception $e) {
        header('Location: /error');
    }
}

怎么了查询是否错误？我在PHPMyAdmin中用替换值运行了查询，它运行良好，因此不能成为查询。

味精7086