PHP json encode encoding numbers as strings

Question

I am having one problem with the PHP json encode function  It encodes numbers as strings  e g    array  id    gt  3    becomes       id    3          When js encounters these values  it interprets them as strings and numeric operations fail on them  Does anyone know some way to prevent json encode from encoding numbers as strings  Thank you

User · Answer

rows   array    while  r   mysql fetch assoc  result          r  id     intval  r  id           rows      r    print json encode  rows

User · Answer

For sake of completeness  as I can t add comments yet   let me also add this detail as another answer    Edit  To be read after realizing that the source data  i e  in the OP s case  database result set  could be the problem  by returning numeric columns as strings   and json encode   in fact was not the source of the problem   Manual pages of both  mysql fetch array       Returns an array of strings that corresponds to the fetched row        and  mysql  fetch  row       Returns an numerical array of strings that corresponds to the fetched   row   clearly states that  the entries in the returned array will be strings    I was using the DB class in phpBB2  yes I know  it s obsolete    and  sql fetchrow    method of that class uses  mysql fetch array      Not realizing that  I also ended up finding this question  and understanding the problem      As Pascal Martin stated above in his follow-up comments  I believe a solution that takes care of the  incorrect type  problem at the source  i e  by using the  mysql field type    function and doing the casting right after fetch   or other fetch methods like  object     would be the better in general

User · Answer

So Pascal MARTIN isn t getting enough credit here  Checking for numeric values on every JSON return is not feasable for an existing project with hundreds of server side functions    I replaced php-mysql with php-mysqlnd  and the problem went away  Numbers are numbers  strings are strings  booleans are boolean

User · Answer

I also had the same problem processing data from the database  Basically the problem is that the type in the array to convert in json  is recognized by PHP as a string and not as integer  In my case I made a query that returns data from a DB column counting row  The PDO driver does not recognize the column as int  but as strings  I solved by performing a cast as int in the affected column

User · Answer

I ve done a very quick test     a   array       id    gt  152       another    gt   test        ananother    gt  456      json   json encode  a   echo  json    This seems to be like what you describe  if I m not mistaken    And I m getting as output      id  152  another   test   ananother  456    So  in this case  the integers have not been converted to string    Still  this might be dependant of the version of PHP we are using   there have been a couple of json encode related bugs corrected  depending on the version of PHP     This test has been made with PHP 5 2 6   I m getting the same thing with PHP 5 2 9 and 5 3 0   I don t have another 5 2 x version to test with  though  -   Which version of PHP are you using   Or is your test-case more complex than the example you posted    Maybe one bug report on http   bugs php net  could be related   For instance  Bug  40503   json encode integer conversion is inconsistent with PHP     Maybe Bug  38680 could interest you too  btw

User · Answer

Note that since PHP 5 3 3  there s a flag for auto-converting numbers  the options parameter was added in PHP 5 3 0     arr   array   row id    gt   1    name    gt   George     echo json encode   arr  JSON NUMERIC CHECK         row id  1  name   George

User · Answer

Well  PHP json encode   returns a string   You can use parseFloat   or parseInt   in the js code though   parseFloat  122 5       returns 122 5 parseInt  22       returns 22 parseInt  22 5       returns 22

User · Answer

Like oli arborum said  I think you can use a preg replace for doing the job  Just change the command like this     json   preg replace       d          1    json

User · Answer

I m encountering the same problem  PHP-5 2 11 Windows   I m using this workaround   json   preg replace        d          1    json      which replaces all  non-negative  integer  numbers enclosed in quotes with the number itself    42   becomes  42     See also this comment in PHP manual

User · Answer

I  likewise was reading from a DB  PostgreSQL  and everything was a string  We loop over each row and do things with it to build up our final results array  so I used    result arr     array  db row  name     int  db row  count       within the loop to force it to be an integer value  When I do json encode  result arr  now  it correctly formats it as a number  This allows you to control what is and is not a number coming from your database   EDIT   The json encode   function also has the ability to do this on the fly using the JSON NUMERIC CHECK flag as a second argument to it  You need to be careful using it though as shown in this users example in the documentation  copied below   http   uk3 php net manual en function json-encode php 106641   lt  php    International phone number json encode array  phone number    gt    33123456789    JSON NUMERIC CHECK     gt    And then you get this JSON     phone number  33123456789

User · Answer

Casting the values to an int or float seems to fix it   For example    coordinates   gt  array        float   ap- gt latitude       float   ap- gt longitude

User · Answer

try   arr   array  var1    gt  100   var2    gt  200    json   json encode   arr  JSON NUMERIC CHECK    But it just work on PHP 5 3 3  Look at this PHP json encode change log  http   php net manual en function json-encode php refsect1-function json-encode-changelog

User · Answer

You can use  int  if any issue occurs   It will work fine

User · Answer

json encode serializes some data structure in JSON format to be send across the network  Therefore all content will be of the type string  Just like when you receive some parameter from   POST or   GET   If you have to make numeric operations on the values sent  just convert them to int first  with the intval   function in PHP or parseInt   in Javascript  and then execute the operations

User · Answer

Just run into the same problem and was the database returning the values as strings   I use this as a workaround    a   array       id    gt   row  id     1       another    gt            ananother    gt           json   json encode  a     That is multiplying the value by 1 to cast it into a number  Hope that helps someone

User · Answer

The following test confirms that changing the type to string causes json encode   to return a numeric as a JSON string  i e   surrounded by double quotes   Use settype arr  var     integer   or settype  arr  var     float   to fix it     lt  php  class testclass       public  foo   1      public  bar   2      public  baz    Hello  world       testarr   array   foo    gt  1   bar    gt  2   baz    gt   Hello  world      json obj txt   json encode new testclass      json arr txt   json encode  testarr    echo   lt p gt Object encoding  lt  p gt  lt pre gt      json obj txt     lt  pre gt    echo   lt p gt Array encoding  lt  p gt  lt pre gt      json arr txt     lt  pre gt        Both above return ints as ints  Type the int to a string  though  and    settype  testarr  foo     string     json arr cast txt   json encode  testarr   echo   lt p gt Array encoding w  cast  lt  p gt  lt pre gt      json arr cast txt     lt  pre gt       gt

User · Answer

it is php version the problem  had the same issue upgraded my php version to 5 6 solved the problem

[php] PHP json_encode encoding numbers as strings

Examples related to php

Examples related to javascript

Examples related to json