语法错误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 =