我无法发现的 PHP stmt bindParam 简单错误

Question

        <?php
        include_once('dbcon.php');
            if (isset($_POST['name'])) {
                $name = $_POST['name'];
                $email = $_POST['email'];
                $phone = $_POST['phone'];
                $stmt =$pdo->prepare("INSERT INTO users(name,email,phone) VALUES (:name,:email,:phone)");
                $stmt->bindParam(':name', $name);
                $stmt->bindParam(':email', $email);
                $stmt->bindParam(':phone', $phone);
                $stmt->execute();
        }

    ?>

这是我的代码，它非常简单，数据库可以正常工作，但我试图添加另一个对它不起作用的表，结果失败了，我在第 11 行搞砸了一些东西我想，任何帮助将不胜感激，提前致谢!

---

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in E:\utsdata\2T\2809984199\GsoVerk4\register.php:11 Stack trace: #0 E:\utsdata\2T\2809984199\GsoVerk4\register.php(11): PDOStatement->execute() #1 {main} thrown in E:\utsdata\2T\2809984199\GsoVerk4\register.php on line 11

---

这是我得到的错误

Answer 1

似乎你忘了让你的 PRIMARY KEY 列 autoincrement-ing