PDOStatement :: execute():SQLSTATE [HY093]:无效的参数号 [英] PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number

问题描述

我正在尝试使用PDO进行更新，但出现一个错误，提示我无法检测出问题所在.

I´m trying to do an update with PDO and I´m getting an error that Im not detecting where the problem is.

错误是这样: PDOStatement :: execute():SQLSTATE [HY093]:无效的参数编号:参数未在$ updateCategory-> execute();中定义

The error is this: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in $updateCategory->execute();

有人知道为什么会这样吗?

Someone there have any idea why this is happening?

$urledit = $_GET['edit'];
$f['name'] = $_POST['name'];
$f['content'] = $_POST['content'];
$f['tags'] = $_POST['tags'];
$f['date'] = $_POST['date'];


$updateCategory = $pdo->prepare("UPDATE categories SET name=:name, url=:url, content=:content, tags=:tags, date=:date WHERE id=:urledit");  
$updateCategory->bindValue(':name', $f['name']);
$updateCategory->bindValue(':url', $f['url']);
$updateCategory->bindValue(':content', $f['content']);
$updateCategory->bindValue(':tags', $f['tags']);
$updateCategory->bindValue(':date', $f['date']);
$updateCategory->bindValue(':id', $urledit);
$updateCategory->execute();
echo 'Update Sucessed!';

推荐答案

在查询中将:urledit更改为:id.所有绑定值必须在查询中匹配.

Change :urledit to :id in your query. All the bind values must match in the query.

这篇关于PDOStatement :: execute():SQLSTATE [HY093]:无效的参数号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！