从mysql获取数据并绘制图表

Question

I have a temperature logger that stores a float value in mysql database, with the time and date of reading. Now I would like to use highcharts and display the values instead of in a table in a chart.

I have found an example on http://blueflame-software.com/using-highcharts-with-php-and-mysql/, but when I set my values I get this:

When I was getting through the code I have noticed difference in date and time format (format that I am using yyyy-mm-dd hh:mm:ss). I have changed the line

  date= Date.pars(line[0]+ ' ISO');

but no luck.

Answer 1

Convert the datetime format in your data.php.

$t = date_create(line[0]);
echo date_format($t, 'l, F j, Y H:i:s');

This should return something like this:

Tuesday, May 3, 2016 10:00:00