php - PDO 中的 "Invalid parameter number"

Question

我在 PDO 中做一个准备好的语句。我收到下面写的错误，我不知道我的错误在哪里。

Error!: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

代码:

$qA=array();
$lastName=$_POST['cours'];

if(trim($_POST["nomActivity"]) != ""){
  $nomActivity= filter_var($_POST['nomActivity'], FILTER_SANITIZE_STRING);
  $qA[] = "a.title = :title";
}
if(trim($_POST["nPlace"]) != ""){
  $nPlace= filter_var($_POST['nPlace'], FILTER_SANITIZE_NUMBER_INT);
  $qA[] = "a.nPlace = :nPlaceA";
} 
if(isset($_POST['date'])){
  $date = $_POST['date'];
  $qA[] = "a.date = :date";
}

$stmtA = $con->prepare("UPDATE activity a SET " . implode(", ", $qA) . " where a.title= :lastN");

if(trim($_POST["nomActivity"]) != ""){
  $stmtA->bindParam(":title", $nomActivity);
} 
if(trim($_POST["nPlace"]) != ""){
  $stmtA->bindParam(":nPlaceA", $nPlace);
} 
if(trim($_POST["date"]) != ""){
  $stmtA->bindParam(":date", $date);
}
if(trim($_POST["cours"]) != ""){
  $stmtA->bindParam(":lastN", $lastName);
} 

$stmtA->execute();

Answer 1

看来你错过了正确的类(class)检查

  if(trim($_POST["nomActivity"]) != ""){
    $nomActivity= filter_var($_POST['nomActivity'], FILTER_SANITIZE_STRING);
    $qA[] = "a.title = :title";
  }
  if(trim($_POST["nPlace"]) != ""){
    $nPlace= filter_var($_POST['nPlace'], FILTER_SANITIZE_NUMBER_INT);
    $qA[] = "a.nPlace = :nPlaceA";
  } 
  if(isset($_POST['date'])){
    $date = $_POST['date'];
    $qA[] = "a.date = :date";
  }

  // this one
  if(isset($_POST['cours'])){
    $lastName=$_POST['cours'];
  } else {
    $lastName = 'your_default_value';
  }

而且你总是有 :lastN 来赋值

  $stmtA->bindParam(":lastN", $lastName);