php round doesn't work as expected when inserting into database

Question

I have a problem with round and inserting into database. Doing the following and trying to insert $y into Mongo will insert it with multiple decimals (similar to what you see from var_export below).

How can I fix this, as I need to have exactly 2 decimals.

<?php

$y = round(348.78 + 348.78 * 19/100, 2 );

var_dump($y);
var_export ($y);

This is only to display the difference on how it gets inserted into Mongo.

float(415.05)
415.05000000000001

Try with this https://stackoverflow.com/questions/13030368/best-data-type-to-store-money-values-in-mysql — Tammy, Apr 17 '18 at 06:55
Possible duplicate of [Why Are Floating Point Numbers Inaccurate?](https://stackoverflow.com/questions/21895756/why-are-floating-point-numbers-inaccurate) — Matt Clark, Apr 17 '18 at 07:46

Eriks Klotins · Answer 1 · 2018-04-17T07:43:46.740

0

Float datatype is not a good option to represent high precision numbers. Decimal is made for that.

See here how (and why) to use decimal numbers with mongoDB

edited Apr 17 '18 at 07:43

answered Apr 17 '18 at 07:04

Eriks Klotins

4,042
1
12
26

1

You forgot the link to "here" – Binar Web Apr 17 '18 at 07:35

php round doesn't work as expected when inserting into database

1 Answers1