PHP have decimal numbers with json_encode

Question

I have an issue with some json code where decimal numbers MUST be encoded without quotes and maintain two decimal places

e.g.

{12.34, 33.40, 25.00}

My problem is that the array I have creates the numbers as string

foreach($numbers as $n)
{
  $result[] = number_format($n, 2, '.', '');
}
json_encode($result);

// result = {"12.34", "33.40", "25.00"}

I don't think you can get a value like 33.40 or 25.00 as anything but a string... ie the reason number_format always returns a string — Mark Miller
– Mark Miller, Commented Jun 21, 2014 at 23:02
Yes, it is a float type - but the resulting value is 33.4 not 33.40. You would get the same result for 33.4000 or 33.4000000 - all will strip off the unnecessary 0s and return 33.4 — Mark Miller
– Mark Miller, Commented Jun 21, 2014 at 23:07
@MarkM is right. This is not possible in PHP. Do echo 34.40;. It will display without the last zero. The same goes for var_dump. — OptimusCrime
– OptimusCrime, Commented Jun 21, 2014 at 23:08
It doesn't make much sense elsewhere either. There is a discussion on the problem here: groups.google.com/forum/#!topic/json-schema/NPIy68ZXE_k — symcbean
– symcbean, Commented Jun 21, 2014 at 23:41

Nezo · Accepted Answer · 2019-02-20 09:38:05Z

2

I had similar issie with this. This may not be the best code but it work for me. Maybe it can help you. Try this (I am using codeigniter):

function getData() {

    $data = $this->Teplomer_model->showData(); //get your data from database as return $query->result();

    //create array
    $arr = array();

    //foreach data to array
    foreach ($data as $row) {
        $arr[] = array(
        "id"                =>  $row->id_teplota,
        "datum"             =>  $row->cas_teplota,
        "teplota"           =>  $row->teplota_teplota,
        "vlhkost"           =>  $row->vlhkost_teplota
        );
    }

    //echo array as json and check if there is any numbers
    echo json_encode($arr, JSON_NUMERIC_CHECK );
}

And output:

{"id":3,"datum":"2019-02-08 14:03:31","teplota":22.33,"vlhkost":19.7},{"id":4,"datum":"2019-02-08 14:18:35","teplota":23,"vlhkost":19}

answered Feb 20, 2019 at 9:38

Nezo

989 bronze badges

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

1 Comment

FrancescoMM Over a year ago

This is perfect unless you need some numeric values as strings. Be careful. Maybe you don't want "00000123" to become 123 or VAT code or social security number or to shorten. In my town phone numbers begin with "02" and you want to keep that zero. In that case you have to build the JSON manually (as jordan121sa's reply)

OptimusCrime · Accepted Answer · 2014-06-21 22:55:48Z

2

You could do:

$result[] = (float) number_format($n, 2, '.', '');

Result:

[12.42,33.4,25]

answered Jun 21, 2014 at 22:55

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

5 Comments

Martin Over a year ago

Same thing as I have just replied to Marcel Gwerder above. Forcing the variable to float type defeats the purpose of number_format

OptimusCrime Over a year ago

What you want is impossible. It is not valid JSON to drop the quotes without the type being either int, float or double. It is simply not possible. Also, you said nothing about your problem in the initial question, so we have in fact solved what you asked us.

Martin Over a year ago

In fact what I want is for the type to be float. Also edited initial question to specify that number must have two decimal places

OptimusCrime Over a year ago

@Martin : What my code does is simply to cast the string to a float, so what you are saying is that my code is correct. According to your comments, what you want is not for the type to be float. You want something that does not exist.

FrancescoMM Over a year ago

Converting to string then to float in nonsense. To truncate decimals use round()

Marcel Gwerder · Accepted Answer · 2014-06-21 22:56:00Z

2

You can use floatval():

$result[] = floatval(number_format($n, 2, '.', ''));

answered Jun 21, 2014 at 22:56

Marcel Gwerder

8,5406 gold badges40 silver badges63 bronze badges

3 Comments

Martin Over a year ago

I have tried that, but it defeats the purpose of having number_format as I always need the two decimal digits e.g. number_format(1, 2, '.', '') // returns 1.00 floatval(number_format(1, 2, '.', '')) // returns 1

Marcel Gwerder Over a year ago

Then you wont be able to convert it to a float, because the .00 is irrelevant. You'll have to keep the string I guess...

FrancescoMM Over a year ago

Converting to string then to float in nonsense. To truncate decimals use round()

CloudJake · Accepted Answer · 2018-09-29 23:48:27Z

1

Came across a similar problem. The only way to achieve this is to build the raw json object rather than using json_encode.

$jsonStr = '{';
$lastElement = count($numbers);
$i = 1;
foreach($numbers as $n)
{
  $jsonStr .= number_format($n, 2, '.', '');
  if($i != $lastElement){
     $jsonStr .= ',';
  }
  $i++;
}
$jsonStr .= '}';
echo $jsonStr;

I know it's not the nicest way to code, but it's the only way to keep decimal points in a json object.

answered Sep 29, 2018 at 23:48

CloudJake

1564 silver badges22 bronze badges

1 Comment

FrancescoMM Over a year ago

This is the only way if you want to keep some numeric values as string (VAT code, phone?) and others as numbers.

Collectives™ on Stack Overflow

PHP have decimal numbers with json_encode

4 Answers 4

1 Comment

5 Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

5 Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related