数组的参数多于 PDO 准备好的语句会导致错误

发布于 2024-09-16 04:17:19 字数 625 浏览 19 评论 0原文

如果必须执行多个查询。有些参数重叠，有些则不重叠。

我想创建一个数组，其中包含所有查询的所有参数的数据。

我想如果数组包含准备好的语句不包含的值，它会忽略它们，但它给了我这个错误：

无效参数数量：数量绑定变量与数字不匹配代币数量

就是我的意思：

$data = array( 'a' => $a, 'b' => $b, 'c' => $c, 'd' => $d);

$data['e'] = "e";
$STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )");
$STH->execute($data);

$data['f'] = "f";
$STH = $this->PDO->prepare("INSERT INTO table2 ( fieldA, fieldD, fieldF ) VALUES (:a, :d, :f )");
$STH->execute($data);

有没有办法允许这样做？或者每次都必须创建不同的数组？

原文

If Have to execute several queries. Some of the parameters overlap, some do not.

I wanted to create one array containing the data for all the params for all the queries.

I figured if the array contains values that the prepared statement does not, it would ignore them but its giving me this error:

Invalid parameter number: number of
bound variables does not match number
of tokens

here is what I mean:

$data = array( 'a' => $a, 'b' => $b, 'c' => $c, 'd' => $d);

$data['e'] = "e";
$STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )");
$STH->execute($data);

$data['f'] = "f";
$STH = $this->PDO->prepare("INSERT INTO table2 ( fieldA, fieldD, fieldF ) VALUES (:a, :d, :f )");
$STH->execute($data);

Is there a way to allow this? or do have to create a different array each time?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

や莫失莫忘 2024-09-23 04:17:19

不，这不受支持。

顺便说一句，在维护方面，我总是觉得使用 bindParam 方法会产生更具可读性的代码。像这样...

$STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )");
$STH->bindParam(':a', 'a');
$STH->bindParam(':b', 'b');
$STH->bindParam(':e', 'e');
$STH->execute();

No, that's not supported.

BTW, when it comes to maintaining I always felt using the bindParam method results in much more readable code. Like this...

$STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )");
$STH->bindParam(':a', 'a');
$STH->bindParam(':b', 'b');
$STH->bindParam(':e', 'e');
$STH->execute();

回复收藏 0 原文

~没有更多了~