Php formatting of numerics to save to mysql database as DECIMAL

Question

I am implementing Ckeckout Cielo and it is always returned numerical values for prices.

Monetary values are always treated as integer values, without representation of decimal places, and the last two digits are considered as cents.

Exemplo: R$ 1.286,87 é representado como 128687 e R$ 1,00 é representado como 100

I think about using the function of substr_replace to add (.) before the last two houses, as in the following example::

substr_replace(100000, '.', -2,0) = 1000.00

substr_replace(100, '.', -2,0) = 1.00

In this context, apply the substr_replace for recording decibel values in the database Mysql would be suitable for any monetary value coming from Cielo?

Answer 1

In that case the CIELO reported, would indicate the division by 100 and would abandon the idea to use substr_replace, because:

Values below 100, in the case 20 could bring a die like this:

Code

echo substr_replace(20, '.', -2,0);
//saída .20

or worst still values with a home:

echo substr_replace(2, '.', -2,0);
//saída .2 no qual o correto deveria ser 0.02

By dividing the value by 100 the value would be formatted and suitable for recording in the bank:

echo 20 / 100;
//saída 0.2
echo 2 / 100;
//saída 0.02
echo 128687 / 100;
//saída 1286.87

As far as I can tell the division solves your problem.