php - SQL/PHP-语法错误或访问冲突: 1064 You have an error in your SQL syntax; [closed]

Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center。




7年前关闭。




我有一个数据库，我正在尝试更新它的一行，但是我一直收到此错误。在以前的程序中，我使用了相同的功能，所以我看不到出了什么问题，这让我发疯了!如果有人能看到任何东西或帮助我，将不胜感激!

这是更新功能:

public function update($member){
   if ($member == null){
      throw new Exception("Member ID Required");   }  

    $id = $member->getId();
    if ($id == null){
        throw new Exception("Member ID Required");
    }
    $sql = "UPDATE member SET
        firstName = :firstName,
        lastName = :lastName,
        dob = :dob,
        email = :email,
        gender = :gender,
        skillLevel = :skillLevel,
        Where id = :id";

    $params = array(
        'id' => $member->getId(),
        'firstName' => $member->getFirstName(),
        'lastName' => $member->getLastName(),
        'dob' => $member->getDOB(),
        'email' => $member->getEmail(),
        'gender' => $member->getGender(),
        'skillLevel' => $member->getSkillLevel(),
    );
      $stmt = $this->link->prepare($sql);
    $status = $stmt->execute($params);
    if ($status != true){
        $errorInfo = $stmt->errorInfo();
        throw new Exception("Could Not Add Member: " . $errorInfo[2]);
    }
    return $stmt->rowCount();
    }

这是编辑页面，它正在从中获取数据

<?php

require_once('member.php');
require_once('MemberDAO.php');
require_once('editFormValidator.php');

$validator = new editFormValidator();

if ($validator->validate($_POST)){
$i = $_POST['memberID'];
$firstName = $_POST['firstName'];
$lastName = $_POST['lastName'];
$dob = $_POST['dob'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$skillLevel = $_POST['skillLevel'];
$skillLevelString = implode(", ", $skillLevel);
$member = new Member ($i,$firstName, $lastName, $dob, $email, $gender,     $skillLevelString);
$dao = new MemberDAO();
$dao->update($member);
header ('Location: viewMember.php');
}
else{
require_once 'editMember.php';
}
?>

这是完整的错误:

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 'Where id = '4'' at line 8' in /Applications/XAMPP/xamppfiles/htdocs/ChessClub/MemberDAO.php:115 Stack trace: #0 /Applications/XAMPP/xamppfiles/htdocs/ChessClub/MemberDAO.php(115): PDOStatement->execute(Array) #1 /Applications/XAMPP/xamppfiles/htdocs/ChessClub/edit.php(20): MemberDAO->update(Object(Member)) #2 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/ChessClub/MemberDAO.php on line 115

最佳答案

您在这里有多余的逗号:

skillLevel = :skillLevel,

关于php - SQL/PHP-语法错误或访问冲突: 1064 You have an error in your SQL syntax; [closed]，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/14673307/

上一篇：php - 引导抛出异常时，Zend Framework显示自定义错误

下一篇：javascript - 将事件处理程序分配给提交按钮将引发SyntaxError : missing exponent error in Firebug

相关文章：

php - 根据行动改变观点是不好的做法吗？

sql - 如何使用 Access SQL VBA 在 where 子句中正确使用两个 Not Exists 语句？

java - 无法从 Java 中的 SQL 打印信息

mysql - 更新表，其中列名设置为变量 mysql

sql - 在一个更新查询中更新 100k 条记录

php - Symfony 原则连接表

php - 扩展 mysqli_result

php - 通过 PHP 将不规则 XML 导入 MySQL

MySQL 无法匹配字符串

mysql - 如何让id不存在则插入，存在则更新？

Answer 1

您在这里有多余的逗号:

skillLevel = :skillLevel,