SQLSTATE 42000 Syntax error or access violation 1064 You have an error in your SQL syntax PHP PDO

Question

I ve looked through all the other StackOverflow  and google  posts with the same problem  but none seemed to address my problem   I am using PDO and PHP   My code    vals   array       from       gt   email       to         gt   recipient       name       gt   name       subject    gt   subject       message     gt  message    print r  vals   try       pdo   new PDOConfig        pdo- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION       sql    SELECT   FROM messages WHERE  message  LIKE  message       q    pdo- gt prepare  sql       q- gt execute array   message    gt   vals   message          resp    q- gt fetchAll        foreach   resp as  row          throw new Exception  Please do not post the same message twice               sql    INSERT INTO messages  from  to  name  subject  message  VALUES   from   to   name   subject   message        q    pdo- gt prepare  sql       q- gt execute  vals      catch PDOException  e       echo  e- gt getMessage        and the first print r gives  Array     from       gt  abc gmail com            to         gt  lala me com            name       gt  abc            subject    gt  abc            message    gt  abc     which is expected  none are null   but it outputs the error     SQLSTATE 42000   Syntax error or access violation  1064 You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near  from  to  name  subject  message  VALUES   abc gmail com    lala me com  at line 1   No idea how to fix this  any ideas

User · Answer

Same pdo error in sql query while trying to insert into database value from multidimential array:

$sql = "UPDATE test SET field=arr[$s][a] WHERE id = $id";
$sth = $db->prepare($sql);    
$sth->execute();

Extracting array arr[$s][a] from sql query, using instead variable containing it fixes the problem.

User · Answer

from is a keyword in SQL  You may not used it as a column name without quoting it  In MySQL  things like column names are quoted using backticks  i e   from    Personally  I wouldn t bother  I d just rename the column   PS  as pointed out in the comments  to is another SQL keyword so it needs to be quoted  too  Conveniently  the folks at drupal org maintain a list of reserved words in SQL

User · Answer

ALTER TABLE    installer- gt getTable  sales quote payment     ADD  custom field one  VARCHAR  255   NOT NULL      ADD  custom field two  VARCHAR  255   NOT NULL    Add backtick i e        properly  Write your getTable name and column name between backtick

User · Answer

I ve got this exact error  but in my case I was binding values for the LIMIT clause without specifying the type  I m just dropping this here in case somebody gets this error for the same reason  Without specifying the type LIMIT  limit OFFSET  offset  resulted in LIMIT  10  OFFSET  1   instead of LIMIT 10 OFFSET 1   What helps to correct that is the following    stmt- gt bindParam   limit   intval  limit  10    PDO  PARAM INT    stmt- gt bindParam   offset   intval  offset  10    PDO  PARAM INT

[php] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

Examples related to php

Examples related to sql

Examples related to mysql

Examples related to pdo

Examples related to mysql-error-1064