当我尝试执行以下查询时,我会收到以下警告。
错误
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters in E:xampphtdocsmsdcaattendance.php on line 142
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number in E:xampphtdocsmsdcaattendance.php on line 142
查询
$name = $_GET['name'];
$stmt = $pdo->prepare("SELECT `st_id`, `st_name` FROM `students` WHERE st_name LIKE ? or st_phone LIKE ? AND atd_year = :year");
$param = array("%$name%", "%$name%");
$stmt-> bindValue(':year', $_GET['yid']);
$stmt-> execute($param);
在这里可能导致问题是什么?任何帮助将不胜感激。谢谢。
您的问题正是错误消息所说的,您在同一查询中使用位置参数(?
)和命名参数(:year
),不允许使用。您需要始终使用一个或另一个,例如
$name = $_GET['name'];
$stmt = $pdo->prepare("SELECT `st_id`, `st_name` FROM `students` WHERE st_name LIKE ? or st_phone LIKE ? AND atd_year = ?");
$param = array("%$name%", "%$name%", $_GET['yid']);
$stmt-> execute($param);
或使用命名参数:
$name = $_GET['name'];
$stmt = $pdo->prepare("SELECT `st_id`, `st_name` FROM `students` WHERE st_name LIKE :name or st_phone LIKE :phone AND atd_year = :year");
$param = array(':name' => "%$name%", ':phone' => "%$name%", ':year' => $_GET['yid']);
$stmt-> execute($param);