语法错误SQLSTATE [42000]

问题描述:

我有语法问题我不知道如何解决它。请帮帮我。



错误:SQLSTATE [42000]:语法错误或访问冲突:1064您的SQL语法有错误;检查与您的MariaDB服务器版本对应的手册,以便在第1行的'where idpost ='2''附近使用正确的语法

I have a problem with syntax i don't have any idea how i fix it. Please help me.

Error: 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 'where idpost= '2'' at line 1

$PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$zmienna = "INSERT INTO `comments` (`iduser`, `comment`, `nick_user`) VALUES (:iduser, :comment, :nick_user) where idpost= :idpost ";
$stmt = $PDO->prepare($zmienna);
$stmt->bindValue(':idpost', $article['id'], PDO::PARAM_INT );





我的尝试:





What I have tried:

PDO::PARAM_INT
$zmienna = "INSERT INTO `comments` (`iduser`, `comment`, `nick_user`) VALUES (:iduser, :comment, :nick_user) where idpost= ".$article['id']." ";

PDO-> setAttribute(PDO: :ATTR_ERRMODE,PDO :: ERRMODE_EXCEPTION);
PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


zmienna = INSERT INTO`comment`(`iduser`,`comment`,`nick_user`)VALUES(:iduser,:comment,:nick_user)where idpost =:idpost;
zmienna = "INSERT INTO `comments` (`iduser`, `comment`, `nick_user`) VALUES (:iduser, :comment, :nick_user) where idpost= :idpost ";


stmt =
stmt =