php - 消息 : SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

Question

以下代码在 $stmt->execute(); 处产生异常

这是一个新问题，我已经检查了其他出现此错误的列表，发现的问题已在此处清除。这是 Slim 需要报告的新问题吗？知道它可能是什么吗？非常感谢，结果证明这是一个 2 天的问题。我是密码盲 atm。

---

$gender             = $_POST['gender'];
$firstName          = $_POST['firstName'];
$lastName           = $_POST['lastName'];
$age                = $_POST['age'];
$phone              = $_POST['phone'];
$contactPreference  = $_POST['contactPreference'];
$city               = $_POST['city'];
$state              = $_POST['state'];
$country            = $_POST['country'];
$zip                = $_POST['zip'];
$adType             = $_POST['adType'];
$activity           = $_POST['activity'];
$whenDate           = $_POST['whenDate'];
$providerGender     = $_POST['providerGender'];
$providerAge        = $_POST['providerAge'];
$providerOffer      = $_POST['providerOffer'];

$db = new PDO( "mysql:host=$server;dbname=$dbname;charset=utf8", $username, $password);
$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$stmt = $db->prepare(
    'INSERT INTO customers (
                    gender,
                    firstName,
                    lastName,
                    age,
                    phone,
                    contactPreference,
                    city,
                    state,
                    country,
                    zip,
                    adType,
                    activity,
                    whenDate,
                    providerGender,
                    providerAge,
                    providerOffer
                    )
                VALUES (
                    :gender,
                    :firstName,
                    :lastName,
                    :age,
                    :phone,
                    :contactPreference,
                    :city,
                    :state,
                    :country,
                    :zip,
                    :adType,
                    :activity,
                    :whenDate,
                    :providerGender,
                    :providerAge,
                    :providerOffer
                    );'
);

$stmt->bindParam(':gender', $gender );
$stmt->bindParam(':firstName', $firstName );
$stmt->bindParam(':lastName', $lastName );
$stmt->bindParam(':age', $age );
$stmt->bindParam(':phone', $phone );
$stmt->bindParam(':contactPreference', $contactPreference );
$stmt->bindParam(':city', $city );
$stmt->bindParam(':state', $state );
$stmt->bindParam(':country', $country );
$stmt->bindParam(':zip', $zip );
$stmt->bindParam(':adType:', $adType );
$stmt->bindParam(':activity', $activity );
$stmt->bindParam(':whenDate', $whenDate );
$stmt->bindParam(':providerGender', $providerGender );
$stmt->bindParam(':providerAge', $providerAge );
$stmt->bindParam(':providerOffer', $providerOffer );

$stmt->execute();

Answer 1

额外 : 在 $stmt->bindParam(':adType:', $adType );

应该是

$stmt->bindParam(':adType', $adType );