Databases
StackOverflow2013
Postsdbo
POGet current date values to own hours
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGet current date values to own hours
    text
    copied!<p>I get values to MySql database everyday at each hour. I got site with highcharts, but I cant get it to work.</p> <p>I need to get current day values from MySql organized to own hours.</p> <p>Here is my Highcharts code:</p> <pre><code>&lt;script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"&gt;&lt;/script&gt; &lt;script src="http://code.highcharts.com/highcharts.js"&gt;&lt;/script&gt; &lt;script type="text/javascript"&gt; var chart; $(document).ready(function() { chart = new Highcharts.Chart({ chart: { renderTo: 'chart', defaultSeriesType: 'spline' }, title: { text: "Today's Values" }, subtitle: { text: 'Values by Hour' }, credits: { enabled: false }, xAxis: { categories: ['12AM', '1AM', '2AM', '3AM', '4AM', '5AM', '6AM', '7AM', '8AM', '9AM', '10AM', '11AM','12PM', '1PM', '2PM', '3PM', '4PM', '5PM', '6PM', '7PM', '8PM', '9PM', '10PM', '11PM'] }, yAxis: { min: 0, title: { text: 'Values' }, labels: { formatter: function() { return this.value } } }, tooltip: { valueDecimals: 2, crosshairs: true, shared: true, formatter: function() { return '$' + this.y; } }, plotOptions: { spline: { marker: { radius: 4, lineColor: '#666666', lineWidth: 1 } } }, series: [{ name: 'Values', data: [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] }] }); }); &lt;/script&gt; </code></pre> <p>Here is pic from MySql database how it looks like</p> <p><a href="http://img35.imageshack.us/img35/39/chartlp.png" rel="nofollow">chart</a></p> <p>So, I need all values from MySql categorized to own hours at chart. It should count values + show it at own category, any idea how to do this?</p> <p>Im stuck with this beacause I dont know how to do this.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload