编辑:有人回答了。使用注释寻求帮助。
所以我正在创建自己的社交网络,名为Dabox!并编制了一份登记表。我通过输入用户名、密码和电子邮件进行了测试。
我把我的用户名作为test,我的密码为test,电子邮件为test@dabox.xyz。我测试了一下,结果是:
INSERT INTO users (username, password, email) VALUES (test, test, test@dabox.xyz)SQLSTATE[23000]: Integrity constraint violation: 1062 for key 'PRIMARY'.
我的代码是:<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "daboxdb";
$user = ($_POST['user']);
$pass = ($_POST['pass']);
$mail = ($_POST['email']);
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO users (username, password, email)
VALUES ('$user', '$pass', '$mail')";
// use exec() because no results are returned
$conn->exec($sql);
echo "New record created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
我不知道是什么问题。你能帮我吗? 检查您的ID列,这将作为主键。您试图插入重复的数据