adding decimal values with php

Question

I have this code:

$sum=0;
while($row=oci_fetch_row($que))
{

$sum+=$row[8];
}

echo number_format((float)$sum,2,",","").'<br>';

there are 3 rows with values '7.01' '43.76' '11.64' echo prints 61.00 instead of 62.41. Why? The corresponding to mySql code works like a charm..... SOLVED..... How to convert a string to float with "tail"? thanks guys for your time

A value from the oracle db. I think its varchar type.

user3201410
– user3201410

2014-03-20 19:30:07 +00:00
Commented Mar 20, 2014 at 19:30 — user3201410
– user3201410, Commented Mar 20, 2014 at 19:30

AbraCadaver · Accepted Answer · 2014-03-20 19:11:27Z

1

Floating point arithmetic. See Floating point precision and Why don’t my numbers add up?

echo serialize(7.01);
echo serialize(43.76);
echo serialize(11.64);;

Try BC Match Functions or round to 2 decimal places first:

echo round(7.01, 2) + round(43.76, 2) + round(11.64, 2);
//$sum += round($row[8], 2);

edited Mar 20, 2014 at 19:11

answered Mar 20, 2014 at 19:04

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Neo Over a year ago

The references helped me understand a lot.

Collectives™ on Stack Overflow

adding decimal values with php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related