Mysql-php getting JSON problems

Now my problem is that I'm using Highchart, where one of its properties is series, to use to external data. I'm going to use PHP to get data from the database using JSON.

The data format in the Serise property is

[{        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: 'New 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]    }, {        name: 'Berlin',        data: [-0.9, 0.6, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0]    }, {        name: 'London',        data: [3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8]    }]

But in the database to get data is this, a field corresponding to a name, all the data under the field corresponds to data, the question is how to get the data, because stitching into such a JSON array, it is not very good to find. In addition, I use JS directly to obtain the form of TD data, assembled into the format of the JSON, directly in the series to raise the JS method, found no. Is it because it either puts the data directly in the field, or puts the data behind name, data, and so on, instead of putting the data in this format into the series.

Reply content:

Now my problem is that I'm using Highchart, where one of its properties is series, to use to external data. I'm going to use PHP to get data from the database using JSON.

The data format in the Serise property is

[{        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: 'New 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]    }, {        name: 'Berlin',        data: [-0.9, 0.6, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0]    }, {        name: 'London',        data: [3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8]    }]

But in the database to get data is this, a field corresponding to a name, all the data under the field corresponds to data, the question is how to get the data, because stitching into such a JSON array, it is not very good to find. In addition, I use JS directly to obtain the form of TD data, assembled into the format of the JSON, directly in the series to raise the JS method, found no. Is it because it either puts the data directly in the field, or puts the data behind name, data, and so on, instead of putting the data in this format into the series.

你把这段代码打印出来试试（结果和你的示例的结果是一样的），跟这个数组格式一样的再json_encode一下就得到了要求的格式了。

你的评论提到的问题应该是一个MySQL的问题，我一般是这么操作的。

$sql = mysql_query('我是SQL请求语句');while ($item = mysql_fetch_array($sql)) { $data[]['name'] = $item['name']; //balba}

大概就是这个样子，用while循环获取。

