语法错误SQLSTATE [42000] [英] Syntax error SQLSTATE[42000]

查看:209
本文介绍了语法错误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屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆