php - 警告:PDOStatement::execute(): SQLSTATE[HY093]: 参数号无效:参数未在中定义

Question

我试图用 php 和 mysql 调用存储过程并收到上述错误消息？有人知道我做错了什么吗？

try{
   $conn = new PDO('mysql:host=localhost;dbname=holidaybookingapp', '', '');
}
catch (PDOException $exception) 
{
   echo "Oh no, there was a problem" . $exception->getMessage();
}

    $startDate="2017-05-23";
    $endDate="2017-05-23";
    $empID= "2";

    $sql='CALL spAddNewHoliday(:EmployeeID,:StartDate,:EndDate)';
    $stmt = $conn->prepare($sql);

    $stmt = $conn->prepare("CALL spAddNewHoloiday(?,?,?)");

    $stmt->bindParam('employeeID',$empID, PDO::PARAM_STR);
    $stmt->bindParam('StartDate1',$startDate, PDO::PARAM_STR);
    $stmt->bindParam('EndDate1',$endDate, PDO::PARAM_STR);
    //$array=array($empID, $startDate,$endDate);

    $stmt->execute(); // call the stored procedure

Answer 1

去掉第二个prepare()，占位符要匹配同名

$startDate="2017-05-23";
$endDate="2017-05-23";
$empID= "2";

$sql='CALL spAddNewHoliday(:EmployeeID,:StartDate,:EndDate)';
$stmt = $conn->prepare($sql);

$stmt->bindParam('EmployeeID',$empID, PDO::PARAM_STR);
$stmt->bindParam('StartDate',$startDate, PDO::PARAM_STR);
$stmt->bindParam('EndDate',$endDate, PDO::PARAM_STR);

$stmt->execute(); // call the stored procedure