mysql - 使用 PDO 将行插入 MYSQL 表不起作用

Question

当我尝试使用 PDO 向 MYSQL 表中插入一行时，它似乎不起作用。我没有收到任何错误消息，但根本没有添加该行。这是我的代码:

$hostname = "localhost";
$database = "website";
$username = "leon";
$password = "*censored*";
$connect = new PDO("mysql:host=$hostname; dbname=$database; charset=utf8", $username, $password) or die("Can't connect!");
$sql = "INSERT INTO members(email, password, gender, firstname, middlename, lastname, zipcode, address, residence, telephone, activation)VALUES(:email, :encryptedpassword, :gender, :firstname, :middlename, :lastname, :zipcode, :address, :residence. :telephone, :activation)";
$register_user=$connect->prepare($sql);
$register_user->execute(array(':email'=>$email,
                  ':encryptedpassword'=>$encryptedpassword,
                  ':gender'=>$gender,
                  ':firstname'=>$firstname,
                  ':middlename'=>$middlename,
                  ':lastname'=>$lastname,
                  ':zipcode'=>$zipcode,
                  ':address'=>$address,
                  ':residence'=>$residence,
                  ':telephone'=>$telephone,                   
                  ':activation'=>$activation));

如有任何帮助，我们将不胜感激!

Answer 1

这里:

VALUES(:email, :encryptedpassword, :gender, :firstname, :middlename, :lastname, :zipcode, :address, :residence. :telephone, :activation)";

:residence. 后面有一个点，而不是逗号 :residence,