[PDO] - Using bindParam() third parameter : data_type

From: Date: Tue, 09 May 2006 16:09:20 +0000
Subject: [PDO] - Using bindParam() third parameter : data_type
Groups: php.db 
Request: Send a blank email to php-db+get-41838@lists.php.net to get a copy of this message
Hi all, I am currently working on PDO. Exactly on the bindParam() function. The third parameter data_type seems to be here to force the type of the value ? But when I try : $sql = "INSERT INTO produit (idproduit, nom, marque)
        VALUES (NULL, :nom, :marque)";
$stmt = $dbh->prepare($sql); $nom = 'Testarossa'; $marque = 'Ferrari' ; $stmt->BindValue(':marque',$marque) ; $stmt->BindParam(':nom',$nom,PDO::PARAM_INT) ; $stmt->execute(); $nom = '250 GTO' ; $stmt->execute(); ?> I was expecting to have either a PHP error or an interger in my database. But in my DB I have : 22 Testarossa Ferrari 23 250 GTO Ferrari It mean that it didn't change if I have the third parameter or not. Or perhaps I miss something. Can someone tole me more ? Or just can someone told me where I can find information about it. Regards, Cyruss

« previous php.db (#41838) next »