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?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…