php – SQLSTATE [HY093]:插入mysql db期间的pdo语句
发布时间:2020-12-13 13:44:05 所属栏目:PHP教程 来源:网络整理
导读:这是我的 PHP代码实现插入到db: ?phprequire_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($_P
这是我的
PHP代码实现插入到db:
<?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.php,其中存储了db_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”不匹配:选择一个或另一个. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |