"Cannot pass parameter 2 by reference" Error in PHP [duplicate]

Question

When I run this code for updating my likedOne column and making it empty ("")....

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

I get this error....

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

The line is....

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

What's wrong?

Answer 1

You need to use a variable , bind_param takes only variable not values directly.

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