SQLSTATE[HY093] ：插入 mysql 数据库期间的 pdo 语句

这是我实现插入数据库的php代码：

<?php

require_once "includes/db_data_inc.php";

try 
{
    $DBH = new PDO("mysql:host=$db_host;dbname=$db_name",$db_user,$db_pass);

    $DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $cathy = new patient($_POST['name'],
                         $_POST['surname'],
                         $_POST['address'],
                         $_POST['birth-place'],
                         $_POST['province'],
                         $_POST['dt'],
                         $_POST['gender'],
                         $_POST['select']);

    $STH = $DBH->prepare("INSERT INTO users (name, 
                                            surname, 
                                            address, 
                                            birth_place,
                                            province,
                                            dt,
                                            sex,
                                            case) value (:name
                                                        :surname,
                                                        :address,
                                                        :birth_place,
                                                        :province,
                                                        :dt,
                                                        :sex,
                                                        :case)");

    $STH->execute((array)$cathy);

}
catch (PDOException $pdoe) 
{
    error_log($pdoe->getMessage());
    die("An error was encountered!");
}

?>

这里是db_data_inc.phpdb_info 的存储位置以及创建对象病人的位置

    $db_host = 'localhost';

$db_name = 'main_db';

$db_user = 'root';

$db_pass = 'root';

/* Create an object patient */

class patient
{
    public $name;
    public $surname;
    public $address;
    public $birth_place;
    public $province;
    public $birth_date;
    public $sex;
    public $case;

    function __construct($nm,$sur,$addr,$bp,$pr,$bd,$sx,$cs)
    {
        $this->name = $nm;
        $this->surname = $sur;
        $this->address = $addr;
        $this->birth_place = $bp;
        $this->province = $pr;
        $this->birth_date = $bd;
        $this->sex = $sx;
        $this->case = $cs;
    }

}

我收到此错误：

[10-Feb-2012 21:14:29] SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

但我没有意识到原因......为什么我收到这个错误？有人可以帮助我吗？错误在哪里？

在您的查询中您使用:dt作为占位符，但在类构造函数中使用$this->birth_date.

一旦转换，这将创建一个索引为 ' 的数组birth_date'，与命名参数不匹配"dt": 选其一。