Error with bindValue with the PDO class

Question

I have the following php script that does not work with bindValue, but works if I put the params into the SQL string(i.e. if I use the commented line instead of the 6 lines later, it works).

<?php

$PDOconnessione = new PDO("mysql:host=127.0.0.1;dbname=eser_php-jquery","root","root");
/*$query = $PDOconnessione->prepare("INSERT INTO appartamento (Tipologia, Prezzo, CodCitta, Descrizione)
                                    VALUES ('" . $_GET["tipologia"] . "','" . $_GET["prezzo"] . "','" . $_GET["citta"] . "','" . $_GET["descrizione"] . "')" ); */


$query = $PDOconnessione->prepare("INSERT INTO appartamento (Tipologia, Prezzo, CodCitta, Descrizione)
                                    VALUES (:tipologia, :prezzo, :codcitta, :descrizione)");

$query->bindValues(':tipologia', $_GET["tipologia"]);
$query->bindValues(':prezzo', $_GET["prezzo"]);
$query->bindValues(':codcitta', $_GET["citta"]);
$query->bindValues(':descrizione', $_GET["descrizione"]);

$query->execute();

echo $PDOconnessione->lastInsertId();

$PDOconnessione = null;

?>

It's the first time that I try to use this method, so it's probably a simple error, but what is it?

score 3 · Accepted Answer · edited May 23 '17 at 11:43

3

The method name is bindValue, not bindValues. Had you enabled error reporting, you'd have found this out easily.

edited May 23 '17 at 11:43

Community

1
1

answered Feb 23 '14 at 11:59

Amal Murali

75,622
18
128
150

Error with bindValue with the PDO class

1 Answers1