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?
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.
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.
There isn't any PDO::PARAM
for decimals / floats, you'll have to use PDO::PARAM_STR
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With