官方文檔
https://www.php.net/manual/zh/pdostatement.bindparam.php
https://www.php.net/manual/zh/pdostatement.bindvalue.php

先說(shuō)結(jié)論

PDOStatement::bindParam 是引用，&$variable 在 PDOStatement::execute() 時(shí)取值（值是后置的）
PDOStatement::bindValue 是傳值，$value 在綁定時(shí)取值

示例

$sex = 'male';
$s = $dbh->prepare('SELECT name FROM students WHERE sex = :sex');
$s->bindParam(':sex', $sex); // use bindParam to bind the variable
$sex = 'female';
$s->execute(); // executed with WHERE sex = 'female'

$sex = 'male';
$s = $dbh->prepare('SELECT name FROM students WHERE sex = :sex');
$s->bindValue(':sex', $sex); // use bindValue to bind the variable's value
$sex = 'female';
$s->execute(); // executed with WHERE sex = 'male'

以上兩個(gè)案例的區(qū)別，bindParam 中 $sex 取值，是最后賦值的 'female'，而 bindValue 是執(zhí)行語(yǔ)句時(shí)的 'male'

如需轉(zhuǎn)載，請(qǐng)標(biāo)注來(lái)源謝謝: http://lukachen.com/archives/323/
http://lukachen.com 是我的個(gè)人博客，歡迎技術(shù)博客友鏈