PDO准备的声明，占位符不起作用

Question

i have some problems with execute a PDO. No error, just nothing happens. The code looks like:

$stmt = $dbh->prepare("INSERT INTO `member_accounts` ('firstname','lastname','email','password') VALUES (:fname,:lname,:e,:pw)");
                 $arr = array(
                    ':fname' => $_POST['firstname'],
                    ':lname' => $_POST['lastname'],
                    ':e' => $_POST['email'],
                    ':pw' => $_POST['password'],
                    );
                 $stmt->execute($arr);

Anyone see the problem? I'm to new at PDO.. Thanks

Answer 1

Remove single quotes here

('firstname','lastname','email','password')

Right statement will be

$stmt = $dbh->prepare("INSERT INTO `member_accounts` (firstname,lastname,email,password) VALUES (:fname,:lname,:e,:pw)");

You can also use backtick(`) with column name but not single quotes.

$stmt = $dbh->prepare("INSERT INTO `member_accounts` (`firstname`,`lastname`,`email`,`password`) VALUES (:fname,:lname,:e,:pw)");