To stitch the contents of the database into JSON in the following format, ask the gods to use code to illustrate
[' Jan ', ' Feb ', ' Mar ', ' Apr ', ' may ', ' June ', ' Jul ', ' April ', ' Sep ', ' Oct ', ' Nov ', ' Dec ']
and such a format
[{ name: ' Tokyo ', data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6] }, { name: ' N EW York ', data: [ -0.2, 0.8, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5] }]
The JSON format I formed when I did this was wrong
Hile ($row 2= Sybase_fetch_array ($result)) {$arr []=array ($row 2[' outdate ']);}
The spelling of the format is more "[]"
Reply to discussion (solution)
$arr []= $row 2[' outdate '];
$arr [] = $row 2[' outdate ');
Each array is a pair of []
$arr []= $row 2[' outdate '];
[{ name: ' Tokyo ', data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6] }, { name: ' N EW York ', data: [ -0.2, 0.8, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5] }]
This format with JS code how to splice?
$ar = Array ( ' name ' = ' Tokyo ', ' data ' = = Array (7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3 , 18.3, 13.9, 9.6), ), Array ( ' name ' = = ' New York ', ' data ' = = Array (-0.2, 0.8, 5.7, 11.3, 17.0, 22.0 , 24.8, 24.1, 20.1, 14.1, 8.6, 2.5),) , Echo Json_encode ($ar);
[{"Name": "Tokyo", "Data": [7,6.9,9.5,14.5,18.2,21.5,25.2,26.5,23.3,18.3,13.9,9.6]},{"name": "New York", "Data": [- 0.2,0.8,5.7,11.3,17,22,24.8,24.1,20.1,14.1,8.6,2.5]}]