PDO错误:"SQLSTATE [HY000]:一般错误"更新数据库时 [英] PDO error: " SQLSTATE[HY000]: General error " When updating database

问题描述

使用PDO更新数据库时出现错误. 我是PDO的新手，所以问题可能很小，我只是不明白. 关于错误的有趣的事情，该命令可以正常工作，并且数据库确实得到了更新. 但是它仍然向我返回错误.

I am getting an error when updating a database using PDO. I am new to PDO so maybe the problem is a small one and I just don't understand. Funny thing about the error, the command works fine and the database does actually get updated. But it still returns an error back at me.

代码:

try {
    $stmt = $pdo->prepare("UPDATE $page SET $section = :new_content WHERE $section = '$old_content'");
    $stmt->execute(array(
        'new_content' => $new_content
    ));
    $result = $stmt->fetchAll();
    echo "Database updated!";
}
catch(PDOException $e) {
    echo 'ERROR UPDATING CONTENT: ' . $e->getMessage();
}

错误: 错误更新内容:SQLSTATE [HY000]:常规错误

Error: ERROR UPDATING CONTENT: SQLSTATE[HY000]: General error

我真的不知道问题出在哪里，因为它非常怪诞，而且我找不到任何遇到相同问题的人.

I literally have no idea where the problem could be because its very vaque and I haven't been able to find anyone with the same problem.

推荐答案

您不像在

$result = $stmt->fetchAll();

带有更新或插入查询.删除此语句应该可以解决问题.

with update or insert queries. Removing this statement should rectify the problem.

这篇关于PDO错误:"SQLSTATE [HY000]:一般错误"更新数据库时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！