Chart.js数据数组使用PHP，MySQL。如何从JSON数组定义数据源？ [英] Chart.js data array using PHP, MySQL. How to define datasource from JSON array?

问题描述

这是我的第一个问题。请为任何错误道歉。

This is my first question. Kindly apologize for any errors.

我正在尝试使用带有PHP和MySQL数据的chart.js绘制图表。我打算绘制的图表是一个简单的垂直条形图，birth_year与出生人数的比较。当我显示数组$ BIRTH_YEAR和$ COUNTS时，我可以看到值。我能够直到json_encode（$ data_array）。当我尝试在javascript上使用这个编码数组时，我没有得到任何输出，一个空白页面！这是我的代码。

I am trying to draw a chart using chart.js with PHP and MySQL data. The graph I intend to draw is a simple vertical barchart, birth_year vs number of people born. When I display the arrays $BIRTH_YEAR and $COUNTS, I could see the values. I was able to get to the point till json_encode($data_array). When I try to use this encoded array on javascript, I do not get any output, a blank page! Here is my code.

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$data[] = array(
    $row['BIRTH_YEAR']=>$row['counts'],
);
$BIRTH_YEAR[]=$row['BIRTH_YEAR'];
$COUNTS[]=$row['counts'];
}

// JSON arrays for labels and counts
$js_labels = json_encode($BIRTH_YEAR,true);
$js_cols = json_encode($COUNTS,true);


var barChartData = {
        labels : '<?php echo $js_labels; ?>',
                    datasets : [
            {
                fillColor : "rgba(220,220,220,0.5)",
                strokeColor : "rgba(220,220,220,1)",
                data : '<?php echo $js_cols; ?>'
            }

        ]
                   }

var myLine = new Chart(document.getElementById("canvas").getContext("2d")).Bar(barChartData);

我在页面中包含了所有其他必需的HTML元素。当我使用chart.js示例文件时，我能够看到图表。唯一的问题是我不确定如何在javascript数据中包含数组：部分。提前致谢。

I have included all other required HTML elements in my page. When I use the chart.js sample file I was able to see charts. The only issue is I am not sure how to include arrays in javascript data: part. Thanks in advance.

推荐答案

您可以使用 $ js_cols = json_encode（$ COUNTS，JSON_NUMERIC_CHECK）;

然后

data : <?php echo print_r($js_cols,true); ?>

这篇关于Chart.js数据数组使用PHP，MySQL。如何从JSON数组定义数据源？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！