How to covert JSON data into an array to plot a chart?

Question

I've a php query which creates the JSON data of the the data received from the SQL query that is run. The JSON data is created using this query using this query

echo json_encode($res->fetch_all(MYSQLI_ASSOC), JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT );

Now I want to plot a chart using fusionchart for which I need to convert this data into an array. I tried a sample JS code to convert the JSON data into an JS array and it worked

var data = { "timestamp": "2016-09-23", "value1": "0", "value2": "0", ........., "value49": "0", "value50": "0" };
   var arr = [];
   for (elem in data) {
        arr.push(data[elem]);
    }
    console.log(arr);

Now in the data variable I need to pass the data from php code. This is just one of the records that I entered manually. There are over a million records and I need to convert all of them. How I do this?

'There are over a million records' - not sure if that's going to work well anyway. — Nigel Ren
– Nigel Ren, Commented Mar 14, 2018 at 10:15
@nigelren Still I need to try to do it. Its a mandatory requirement. — Will
– Will, Commented Mar 14, 2018 at 10:16
Do you want to plot all the records at once or is there some sort of constraint? — Andrei
– Andrei, Commented Mar 14, 2018 at 10:17
Regarding "I'm unable to pass the $res variable directly to the data variable", of course not. $res is a result set, not an array. You need to store the result in a variable. Instead of echo json_encode($res->...), do $data = json_encode($res->..). Then you can echo the $data variable where ever you want. — M. Eriksson
– M. Eriksson, Commented Mar 14, 2018 at 10:28

vikalp · Accepted Answer · 2018-03-14 10:23:15Z

1

You can use parseJSON() function :

var obj = jQuery.parseJSON( '{ "name": "John" }' );
alert( obj.name === "John" );

answered Mar 14, 2018 at 10:23

vikalp

3302 silver badges9 bronze badges

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

1 Comment

Will Over a year ago

The problem that I'm facing is not that I cannot convert it into JS array, I'm unable to pass the $res variable directly to the data variable, so that it can convert the entire dataset into JS array at once.

Harun Diluka Heshan · Accepted Answer · 2018-03-14 11:04:00Z

1

You can just use Object.values() function to acquire values from an object.

var data = { "timestamp": "2016-09-23", "value1": "0", "value2": "0", "value49": "0", "value50": "0" };

var arr = Object.values(data);
console.log(arr);

For PHP

You can send only values and omit keys in PHP using following code. json_decode converts JSON string to an array. implode converts an array to a string.

<?php

$str = '{ "timestamp": "2016-09-23", "value1": "val1", 
        "value2": "val2", "value49": "val49", "value50": "val50" }';
$myJSON = json_decode($str, true);

echo '[' . implode(",", $myJSON) . ']';

Results:

[2016-09-23,val1,val2,val49,val50]

edited Mar 14, 2018 at 11:04

answered Mar 14, 2018 at 10:18

Harun Diluka Heshan

1,2463 gold badges19 silver badges30 bronze badges

2 Comments

Will Over a year ago

The problem that I'm facing is not that I cannot convert it into JS array, I'm unable to pass the $res variable directly to the data variable, so that it can convert the entire dataset into JS array at once.

Harun Diluka Heshan Over a year ago

@Will I changed my solution to answer back-end requirement.

Collectives™ on Stack Overflow

How to covert JSON data into an array to plot a chart?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related