Chart.js-使用mysql和php从数据库获取数据

请将您的php代码放入另一个文件中，

api.php

$.ajax

json_enpre()

我提供了示例示例，您可以在这里看到。

请参考以下代码示例：

1. api.php

   $arrLabels = array("January","February","March","April","May","June","July");

   $arrDatasets = array(‘label’ => “My First dataset”,’fillColor’ => “rgba(220,220,220,0.2)”, ‘strokeColor’ => “rgba(220,220,220,1)”, ‘pointColor’ => “rgba(220,220,220,1)”, ‘pointStrokeColor’ => “#fff”, ‘pointHighlightFill’ => “#fff”, ‘pointHighlightStroke’ => “rgba(220,220,220,1)”, ‘data’ => array(‘28’, ‘48’, ‘40’, ‘19’, ‘86’, ‘27’, ‘90’));

   $arrReturn = array(array(‘labels’ => $arrLabels, ‘datasets’ => $arrDatasets));

   print (json_enpre($arrReturn));

2. example.html

   $.ajax({

   type: ‘POST’,
   url: ‘api.php’,
   success: function (data) {
   lineChartData = data;//alert(JSON.stringify(data));
   var myLine = new Chart(document.getElementById(“canvas”).getContext(“2d”)).Line(lineChartData);

   var ctx = document.getElementById(“canvas”).getContext(“2d”);
   window.myLine = new Chart(ctx).Line(lineChartData, {responsive: true});
   }
   });

请注意，您应该传递价值

randomScalingFactor()

api.php

请检查并告知我是否需要其他帮助。