PHP PDO数据不插入[重复](PHP PDO data does not inserting [duplicate])

 
 
 这个问题在这里已有答案： 
 
 
 
  
 由于在MySQL 1答案中 使用保留字作为表或列名称而导致语法错误 
 
 
 
 
Fatal error: Uncaught exception 'PDOException' with message '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 'keys) VALUES ('1','159')' at line 1' in C:\xampp\htdocs\***\index12.php:93 Stack trace: #0 C:\xampp\htdocs\***\index12.php(93): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\***\index12.php on line 93





$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
for($i = 1; $i < sizeof($counts_index);$i++){
    //echo $i.": ".$counts_index[$i]."<br/>";
    $index = $counts_index[$i];
    $sql1 = "INSERT INTO asce (idn,keys) VALUES (:idn,:keys)";
    $q1 = $dbh->prepare($sql1);
    $params1 = array(
        ':idn'=>$i,
        ':keys'=> $index
    );
    $q1->execute($params1);
}

 
 
This question already has an answer here:
 
 
 
  
 Syntax error due to using a reserved word as a table or column name in MySQL  1 answer  
 
 
 
 
Fatal error: Uncaught exception 'PDOException' with message '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 'keys) VALUES ('1','159')' at line 1' in C:\xampp\htdocs\***\index12.php:93 Stack trace: #0 C:\xampp\htdocs\***\index12.php(93): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\***\index12.php on line 93





$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
for($i = 1; $i < sizeof($counts_index);$i++){
    //echo $i.": ".$counts_index[$i]."<br/>";
    $index = $counts_index[$i];
    $sql1 = "INSERT INTO asce (idn,keys) VALUES (:idn,:keys)";
    $q1 = $dbh->prepare($sql1);
    $params1 = array(
        ':idn'=>$i,
        ':keys'=> $index
    );
    $q1->execute($params1);
}

原文：