bindValue is giving error when registering

Navigation
0

Colleagues,

I have the following code: 

include_once("conexao.php");
$sql = $conexao->prepare("INSERT INTO compras_clientes(Produtos) VALUES(:COD_PRODUTOS)");        
$sql->bindValue(":COD_PRODUTOS",$produto,PDO::PARAM_STR);
$sql->execute();

However when running, you are giving the error:

  

Fatal error: Call to a member function bindValue () on boolean ...

I also tried this way: 

$sql->bindValue(":COD_PRODUTOS","produto1");

But the error persists ... Would anyone know what it could be?

    
asked by anonymous 19.06.2016 / 18:09

1 answer

0

The solution is below: 

 $sql = $mysqli_conn->prepare("INSERT INTO compras_clientes(Produtos) VALUES(?)"); 
    $sql->bind_param('s', $produto);
$sql->execute();
    
19.06.2016 / 18:32
Error rendering PartialView in a View Help in cURL, resending form