parse string element in JSON array to integer

Question

 $con = new DBConnector();
 $sth =  $con->Query("SELECT medicinename as label, factor as data FROM medicine_master_tbl limit 4");
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
         $rows[] = $r;
      }
echo json_encode($rows);

there is no problem with my query,but the returned value is ..

[{"label":"rrp","data":"5"},{"label":"t","data":"34"},{"label":"tt","data":"4"},{"label":"nutrachin","data":"45"}]

i need the json array as like below..

[{"label":"rrp","data":5},{"label":"t","data":34},{"label":"tt","data":4},{"label":"nutrachin","data":45}]

which the data is considered as string in this array , i need to be parse it as integer .. thanks in advance.

According to the php docs it should be output how you want it, what do you get if you var_dump/print_r $r inside the while? — atmd
– atmd, Commented Jan 8, 2015 at 9:26

Saren Arterius · Accepted Answer · 2015-01-08 09:26:59Z

2

An easy one.

while ($r = mysql_fetch_assoc($sth)) {
     $r["data"] = intval($r["data"]);
     $rows[] = $r;
}

answered Jan 8, 2015 at 9:26

Saren Arterius

1,3401 gold badge11 silver badges16 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:43:37Z

1

Ideally your database connector would allow you to specify what type of data you are returning in the row, if factor is a numeric type. For instance, PDO and mysqlnd can return native types (see How to get numeric types from MySQL using PDO?).

However, you can do the following:

while ($r = mysql_fetch_assoc($sth)) {
    $r['data'] = intval($r['data']);
    $rows[] = $r;
}

This way, your JSON encoding will have an integer.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jan 8, 2015 at 9:27

cmbuckley

43k10 gold badges83 silver badges95 bronze badges

Collectives™ on Stack Overflow

parse string element in JSON array to integer

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related