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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux