3 <script src="Chart.js/Chart.js"></script>
7 $r=open_database("freqwatch", "select count(id) as tot,freq from freqs group by freq asc");
8 $num=mysql_numrows($r);
11 $tot=mysql_result($r,$i,"tot");
12 $freq=mysql_result($r,$i,"freq");
14 $labels=$labels.'"'.$freq.'",';
17 # $labels=$labels.'" ",';
19 $data=$data.'"'.$tot.'",';
24 $labels=rtrim($labels,',');
25 $data=rtrim($data,",");
28 <div style="width: 50%">
29 <canvas id="canvas" height="800" width="<? echo $num*5; ?>"></canvas>
35 labels : [<? echo $labels; ?>],
38 fillColor : "rgba(151,187,205,0.5)",
39 strokeColor : "rgba(151,187,205,0.8)",
40 highlightFill : "rgba(151,187,205,0.75)",
41 highlightStroke : "rgba(151,187,205,1)",
42 data : [<? echo $data; ?>]
46 window.onload = function(){
47 var ctx = document.getElementById("canvas").getContext("2d");
48 window.myBar = new Chart(ctx).Bar(barChartData, {
51 barStrokeWidth : 0.01,
59 function open_database($dab,$sqlquery)
61 $db = mysql_connect("localhost", "freqwatch", "DAPASSWORD");
63 echo "Cant connect to server.<br>";
66 if (! @mysql_select_db($dab)) {
67 echo "Cant connect to DB.<br>";
70 $result=mysql_query($sqlquery);