Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PDO::PARAM for type decimal?

I have 2 database fields

`decval` decimal(5,2) `intval` int(3) 

I have 2 pdo queries that update them. The one that updates the int works ok

$update_intval->bindParam(':intval', $intval, PDO::PARAM_INT); 

but I can't update the decimal field. I've tried the 3 ways below, but nothing works

$update_decval->bindParam(':decval', $decval, PDO::PARAM_STR); $update_decval->bindParam(':decval', $decval, PDO::PARAM_INT); $update_decval->bindParam(':decval', $decval); 

It seems the problem is with the database type decimal? Is there a PDO::PARAM for a field of type decimal? If not, what do I use as a workaround?

like image 854
dmontain Avatar asked Apr 27 '10 03:04

dmontain


People also ask

What is PDO :: Param_str in PHP?

PDO::PARAM_STR (int) Represents the SQL CHAR, VARCHAR, or other string data type. PDO::PARAM_STR_NATL (int) Flag to denote a string uses the national character set.

What is bind param PHP?

bindParam is a PHP inbuilt function used to bind a parameter to the specified variable name in a sql statement for access the database record. bindValue, on the other hand, is again a PHP inbuilt function used to bind the value of parameter to the specified variable name in sql statement. 2. Execution.


1 Answers

There isn't any PDO::PARAM for decimals / floats, you'll have to use PDO::PARAM_STR.

like image 76
Alix Axel Avatar answered Sep 29 '22 18:09

Alix Axel