我目前的查询结果:
array(6){
[0]=> array(3){["id"]=>"1" ["count"]=>"6" ["day"]=>"15-01-01"}
[1]=> array(3){["id"]=>"2" ["count"]=>"3" ["day"]=>"15-01-01" }
[2]=> array(3){["id"]=>"3" ["count"]=>"1" ["day"]=>"15-01-01" }
[3]=> array(3){["id"]=>"1" ["count"]=>"6" ["day"]=>"15-01-02" }
[4]=> array(3){["id"]=>"2" ["count"]=>"4" ["day"]=>"15-01-02" }
[5]=> array(3){["id"]=>"3" ["count"]=>"6" ["day"]=>"15-01-02" }
}
虽然谷歌图表需要以下格式:
var data = google.visualization.arrayToDataTable([
['Date', '15-01-01', '15-01-02', { role: 'annotation' } ],
['1', 6, 6,],
['2', 3, 4,],
['3', 1, 6,],
]);
如何将我的数据转换成合适的格式?
UPDATE
我尝试这样做:
$dateArray= array();
$output= "var data = google.visualization.arrayToDataTable([";
$output .= "['Date',";
foreach($mySqlResult as $val) {
if (in_array($val['day'], $dateArray)) {
continue;
}
$dateArray[] = $val['day'];
$output .= "'".$val['day']."',";
}
$output .= " { role: 'annotation' } ],";
foreach($mySqlResult as $val) {
$output .= "['".$val['id']."',".$val['count']."],";
}
$output .= "]);";
这给了我下面的结果:
"var data = google.visualization.arrayToDataTable(
[['Date','15-01-01','15-01-02', { role: 'annotation' } ],
['1',6,],['2',3,],['3',1,],['1',6,],['2',4,],['3',6,],]);"
需要还没什么。如何创建每个ID与所有计数行:
['1', 6, 6,],['2', 3, 4,],['3', 1, 6,],
2016-02-17
julie
+1
你已经尝试什么到目前为止 –
+1
你能证明你的代码,什么是 –
+0
@SharmaVikram我添加链接到谷歌柱形图 –