我用Highcharts制作图表,效果很好。
但是现在我想要mysql结果的值。我尝试的是这样的:
xAxis: {
dateTimeLabelFormats: {
month: '%b'
}
data: [<?
//verkoopfacturen tot 30 dagem oud
$query = "SELECT SUM(VerkoopfactBedrag) AS bedrag, DATE_FORMAT(VerkoopfactDatum, '%m') AS date
FROM verkoopfacturen WHERE Verkoopfact_UserId = {$_COOKIE['customer_id']} AND VerkoopfactDatum BETWEEN '{$year}-01-01' AND '{$year}-12-30'
GROUP BY MONTH(VerkoopfactDatum)";
$sql = mysql_query("$query");
while ($fill = mysql_fetch_array($sql))
{
$bedrag = $fill['bedrag'];
$date = $fill['date'];
echo '[';
echo $date.',';
echo $bedrag;
echo '],';
}
?>]
问题是现在我得到的月份是小数
您可以在xAxis上使用实际日期,并让HighCharts呈现它。参考API参考中的xAxis - dateTimeLabelFormats