Error Insert in bank using PDO: "Only variables should be passed by reference" [duplicate]

Question

Error Insert in bank using PDO: "Only variables should be passed by reference" [duplicate]

Navigation

#1 by (1 votes)

1

I'm passing insert parameters to the database using PDO and O.O, but giving the Insert command using the $stm->bindParam(1, $usuario->getnivel()); parameters returns error saying that I should only pass variables to insert.

Follow the code below:

  public function cadastrar(Cadastro $usuario) {
        $stm = $this->pdo->prepare('INSERT INTO usuarios (nivel,username,senha) VALUES (?,?,?)');   
        $stm->bindParam(1, $usuario->getnivel());
        $stm->bindParam(2, $usuario->getusername());
        $stm->bindParam(3, $usuario->getsenha());
        $stm->execute();
}

php pdo

asked by anonymous 26.03.2016 / 17:53

1 answer

Unity 3D-How to make a game [closed] Generation of GNRE Guides for the state of RJ

score 1 · Accepted Answer

bindParam() does not accept values or returns methods only accepts variables or constants, in which case it is best to change bindValue()

$stm->bindValue(1, $usuario->getnivel());
$stm->bindValue(2, $usuario->getusername());
$stm->bindValue(3, $usuario->getsenha());

More details at: What's the difference between bindParam and bindValue?