How to create a chart in PHP using JSON data from SQL query

Question

I have a sql query which creates a pivot table. Now I've have executed this query in PHP using 'multiquery' and have converted it into JSON using 'json_encode'. The JSON data is consists of around 25million records and the format of each record is

{
timestamp: .....;
value 1: .....;
value 2: .....;
value 3: .....;
value 4: .....;
..
..
..
value n: .....;
}

Now I need to create a chart from this. How should I convert the JSON data into dynamic array so as to create a chart. I'm using dygraphs library.

Which one are you looking for? Create a chart or convert your array into json? — arnold_p
– arnold_p, Commented Mar 12, 2018 at 7:09

Thibaut · Accepted Answer · 2018-03-12 07:27:08Z

1

To convert your json to array you can use json_decode with "true" in second parameters: json_decode($json, true);

php doc

answered Mar 12, 2018 at 7:27

Thibaut

3433 silver badges13 bronze badges

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

Comments

Bùi Đức Khánh · Accepted Answer · 2018-03-12 10:03:51Z

0

You can convert JSON string to array by using json_decode() function

$newArray = json_decode($json_string, TRUE);

edited Mar 12, 2018 at 10:03

Bùi Đức Khánh

4,6987 gold badges32 silver badges46 bronze badges

answered Mar 12, 2018 at 8:57

Reshma Mathew

1

Collectives™ on Stack Overflow

How to create a chart in PHP using JSON data from SQL query

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