为Highcharts图表格式化数据 [英] Format data for Highcharts chart

问题描述

  xAxis：{$ b $}我试图从mysql创建Highcharts图表，我有这样的代码： b类别：[<？php echo implode（$ column，'，'）; >] 
} 
  

列已从mysql中抓取：

  $ column = array（）; 
 $ column [] = $ row ['blabla']; 
  

我实际得到的是：

  xAxis：{
类别：[data1，data2，data3，data4，data5] 
} 
  

但它必须是这样的：

  xAxis：{
 categories：[data1，data2，data3，data4，data5] 
} 
  

我可以如何格式化它？

json_encode 会将您的字符串数组格式化为JSON对象，包括转义等，然后可以通过以下方式传递给HighCharts：

  xAxis：{
类别：<？php echo json_encode（$ column）; ？> 
} 
  

I'm trying to create Highcharts chart from mysql, I have code like this:

 xAxis: {
   categories: [<?php  echo  implode($column, ','); ?>]
 }

and column has been grabbed from mysql:

  $column = array();
  $column[] = $row['blabla'];

What I am actually getting is:

 xAxis: {
   categories: [data1,data2,data3,data4,data5]
 }

but it has to be like this:

 xAxis: {
   categories: ["data1","data2","data3","data4","data5"]
 }

How can I format it like that?

解决方案

json_encode will format your array of strings as a JSON object, including escaping, etc., which can then be passed into HighCharts with the following:

xAxis: {
    categories: <?php echo json_encode($column); ?>
}

这篇关于为Highcharts图表格式化数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！