Re: PHP 4.2.2 Float->Mysql addition problem
| From: | Andrei | Date: | Fri, 03 Feb 2006 13:14:16 +0000 |
| Subject: | Re: PHP 4.2.2 Float->Mysql addition problem | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-229803@lists.php.net to get a copy of this message | ||
Welcome,
Please note that using bc function variables will be of type string. So a code working with numeric values like:
$a = 1;
if( $a )
{
...} it's ok but with bc functions: $a = 14.5; $b = -14.5; $c = bcadd( $a, $b ); if( $c ) { ... } will not work as expected ( if( "0" ) is interpreted like a string that is not null and so condition is interpreted as true. Andy Barry wrote:
Barry wrote:Andrei wrote:No problem anymore. solved it. but parsing it to an other function it doesnt work. oh well, at least it's calculating ^-^ Thanks for help :) BarryThanks Andy sounds great. Changed DB to decimal 10.2 Tried it, but using bcadd i get a value of 0.00. If you have som sample code lying around somewhere that would be great, or do you know what happened? BarryWhen working with floats with php/mysql I had problems too... When summing amounts I had errors so my solution was using decimal (20, 10) type into mysql for storing amounts and when using sums in php I used bc functions. This way u get exact calculations (depending on bcscale() parameter.