php - "Cannot pass parameter 2 by reference"PHP错误

Question

这个问题在这里已经有了答案:

PHP error: "Cannot pass parameter 2 by reference" (2 个回答)

How to resolve 'cannot pass parameter by reference' error in PHP? [duplicate] (2 个回答)

关闭 5年前。

当我运行此代码以更新我的 likeOne 列并使其为空 ("")....

    $sql11 = $conn->prepare("UPDATE UserData SET likedOne=? WHERE username=?");
    $sql11->bind_param('ss',"",$Username);
    $Username = "netsgets";
    $sql11->execute();

我收到此错误....

1 Fatal error: Cannot pass parameter 2 by reference in /xxx/xxx/xxx/test.php on line 36. 

这条线是....

$sql11->bind_param('ss',"",$Username);

怎么了？

Answer 1

你需要使用一个变量，bind_param只取变量而不是直接取值。

   $likedone ="";
   $sql11->bind_param('ss',$likedone,$Username);