PHP PDO bindParam陷入困境 [英] PHP PDO bindParam was falling in a foreach

问题描述

我有一个像这样的循环:

I had a loop like that :

foreach($Fields as $Name => $Value){
    $Query->bindParam(':'.$Name, $Value, PDO::PARAM_STR);
}

没有什么复杂的.但是，每个值都设置为数组中的最后一个值($Fields).

Nothing complicated. However, each value was set to the last one in the array ($Fields).

我该如何解决?

推荐答案

但是，感谢这个人.我发现您需要像这样先通过&引用传递值:

However, thanks to this guys. I found out that you need to pass the value by reference with a & before like that :

foreach($Fields as $Name => &$Value){
    $Query->bindParam(':'.$Name, $Value, PDO::PARAM_STR);
}

这让我发疯了.

PHP.net 的实际报价:

Vili 2010年5月28日12:01

Vili 28-May-2010 12:01

这有效(按引用的$ val):

This works ($val by reference):

<?php
foreach ($params as $key => &$val){
    $sth->bindParam($key, $val);
}
?>

这将失败(按值$ val，因为bindParam需要& $ variable):

This will fail ($val by value, because bindParam needs &$variable):

<?php
foreach ($params as $key => $val) {
    $sth->bindParam($key, $val);
}
?>

这篇关于PHP PDO bindParam陷入困境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！