PDOException: SQLSTATE[42000]
У меня такой код:
<?php
$Code = $_POST['Code'];
$email = $_SESSION['E-Mail'];
echo "Code".$Code;
var_dump($Code);
//Проверки
if ($Code = '') {
http_response_code(500);
exit();
} else {
if ($Code == $_SESSION['Verification_Code']) {
$dsn = 'mysql:host=localhost;dbname=tsecret1_users;';
$opt = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
$pdo = new PDO($dsn, 'tsecret1_Sys', 'i$Q5-9J~.2m.', $opt);
$sql = "UPDATE ? SET `parameters`='EmailVerified' WHERE `parameters` = 'EmailIsNotVerified'";
$query = $pdo->prepare($sql);
$query->execute([$email]);
error_log($query, 0);
echo '<h1 align="center">|!| Ваш E-Mail уде Подтвержден |!|</h1>';
}
}
?>
Ошибка на этой строке: $query = $pdo->prepare($sql);, PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? SET `parameters`='EmailVerified' WHERE `parameters` = 'EmailIsNotVerified'' at line 1 in /home/tsecret1/Test-Server/AUTH/Ver_Email.php:36 Stack trace: #0 /home/tsecret1/Test-Server/AUTH/Ver_Email.php(36): PDO->prepare('UPDATE ? SET `p...') #1 {main} thrown in /home/tsecret1/Test-Server/AUTH/Ver_Email.php on line 36