语法错误SQLSTATE [42000] [英] Syntax error SQLSTATE[42000]
本文介绍了语法错误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 =
这篇关于语法错误SQLSTATE [42000]的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文