series中的数据是json格式
series: | |
[{"name":"cdn","data":[1,2,3]},{"name":"idc","data":[4,5,6]}] |
那么我们可以在后端生成一个数组在js里打印一个json数据
series:
<?php echo $a?>
从数据库中循环查询并生成name data键的二维数组
foreach ($types as $key => $type){
$montharr[$key]['name'] = $type['oProductCode'];
for ($month= 1;$month<=$maxmonth; $month++){
if($month<10){
$month=sprintf("%02d",$month);
} //位数不足前补零
$result= $this->model->selectQcloudCostcount($syear,$type['oProductCode'],$month);
$num = $result['0']['oTotalAmount'] ? $result['0']['oTotalAmount'] : 0;
$num = intval ($num)/100; //转换格式、单位
$montharr[$key]['data'][$month]=$num;
}
注意data中要去掉键
$montharr[$key]['data']=array_values($montharr[$key]['data']);
注意data里的值为int型
$num = intval ($num)
转载于:https://blog.51cto.com/q2012/2059453