+<html>
+<head>
+<script src="Chart.js/Chart.js"></script>
+</head>
+<body>
+<?
+ $r=open_database("freqwatch", "select count(id) as tot,freq from freqs group by freq asc");
+ $num=mysql_numrows($r);
+ $skipper=50;
+ while ($i<$num) {
+ $tot=mysql_result($r,$i,"tot");
+ $freq=mysql_result($r,$i,"freq");
+ #if ($skipper==50) {
+ $labels=$labels.'"'.$freq.'",';
+ # $skipper=0;
+ #} else {
+ # $labels=$labels.'" ",';
+ #}
+ $data=$data.'"'.$tot.'",';
+ $i++;
+ #$skipper++;
+ #echo $freq;
+ }
+ $labels=rtrim($labels,',');
+ $data=rtrim($data,",");
+ #$num=150;
+?>
+ <div style="width: 50%">
+ <canvas id="canvas" height="800" width="<? echo $num*5; ?>"></canvas>
+ </div>
+
+
+ <script>
+ var barChartData = {
+ labels : [<? echo $labels; ?>],
+ datasets : [
+ {
+ fillColor : "rgba(151,187,205,0.5)",
+ strokeColor : "rgba(151,187,205,0.8)",
+ highlightFill : "rgba(151,187,205,0.75)",
+ highlightStroke : "rgba(151,187,205,1)",
+ data : [<? echo $data; ?>]
+ }
+ ]
+ }
+ window.onload = function(){
+ var ctx = document.getElementById("canvas").getContext("2d");
+ window.myBar = new Chart(ctx).Bar(barChartData, {
+ animation: false,
+ scaleLineWidth: 1,
+ barStrokeWidth : 0.01,
+ responsive : false
+ });
+ }
+ </script>
+</body>
+</html>
+<?
+function open_database($dab,$sqlquery)
+{
+ $db = mysql_connect("localhost", "freqwatch", "DAPASSWORD");
+ if (!$db) {
+ echo "Cant connect to server.<br>";
+ exit();
+ }
+ if (! @mysql_select_db($dab)) {
+ echo "Cant connect to DB.<br>";
+ exit();
+ }
+ $result=mysql_query($sqlquery);
+ return($result);
+}
+?>