PHP PDO插入无法正常工作，没有错误

Question

This question already has an answer here:

My PDO Statement doesn't work

(1个答案)


4年前关闭。




我有这种和平的代码，应该在mysql数据库中插入一条记录:

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) VALUES (?, ?, ?, ?, ?, ?, ?)')";
$stmt = $pdo->prepare($sql);
if (!$stmt) {
    echo "\nPDO::errorInfo():\n";
    print_r($pdo->errorInfo());
}
$stmt->execute(array('wer','wer','wer','2','wer','wer','wer'));

我没有收到任何错误，并且该记录未显示在表中。可能出什么问题了？

更新:

这是完整的工作代码，这要归功于以下答案:

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt = $pdo->prepare($sql);
if (!$stmt) {
    echo "\nPDO::errorInfo():\n";
    print_r($pdo->errorInfo());
}
$stmt->execute(array('wer','wer','wer','2','wer','wer','wer'));

最佳答案

SQL命令的末尾存在语法错误。删除多余的')。它应该是:

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) 
        VALUES (?, ?, ?, ?, ?, ?, ?)";

代替

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) 
        VALUES (?, ?, ?, ?, ?, ?, ?)')";
                                    ^^--- error here

关于PHP PDO插入无法正常工作，没有错误，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/12100239/

上一篇：php - 使用 PHP 将表单数据保存到现有的 XML 文件

下一篇：php - 将 PHP 转换为 JavaScript。将键/值存储到数组中

Answer 1

SQL命令的末尾存在语法错误。删除多余的')。它应该是:

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) 
        VALUES (?, ?, ?, ?, ?, ?, ?)";

代替

$sql = "INSERT INTO connections (column1, column2, column3, column4, column5, column6, column7) 
        VALUES (?, ?, ?, ?, ?, ?, ?)')";
                                    ^^--- error here