client-freqwatch/index.php

   1 <html>
   2 <head>
   3 <script src="Chart.js/Chart.js"></script>
   4 </head>
   5 <body>
   6 <?
   7   $r=open_database("freqwatch", "select count(id) as tot,freq from freqs group by freq asc");
   8   $num=mysql_numrows($r);
   9   $skipper=50;
  10   while ($i<$num) {
  11     $tot=mysql_result($r,$i,"tot");
  12     $freq=mysql_result($r,$i,"freq");
  13     #if ($skipper==50) {
  14       $labels=$labels.'"'.$freq.'",';
  15     #  $skipper=0;
  16     #} else {
  17     #  $labels=$labels.'" ",';
  18     #}
  19     $data=$data.'"'.$tot.'",';
  20     $i++;
  21     #$skipper++;
  22     #echo $freq;
  23   }
  24   $labels=rtrim($labels,',');
  25   $data=rtrim($data,",");
  26   #$num=150;
  27 ?>
  28         <div style="width: 50%">
  29                         <canvas id="canvas" height="800" width="<? echo $num*5; ?>"></canvas>
  30                 </div>
  31
  32
  33         <script>
  34         var barChartData = {
  35                 labels : [<? echo $labels; ?>],
  36                 datasets : [
  37                         {
  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; ?>]
  43                         }
  44                 ]
  45         }
  46         window.onload = function(){
  47                 var ctx = document.getElementById("canvas").getContext("2d");
  48                 window.myBar = new Chart(ctx).Bar(barChartData, {
  49                         animation: false,
  50                         scaleLineWidth: 1,
  51                         barStrokeWidth : 0.01,
  52                         responsive : false
  53                 });
  54         }
  55         </script>
  56 </body>
  57 </html>
  58 <?
  59 function open_database($dab,$sqlquery)
  60 {
  61   $db = mysql_connect("localhost", "freqwatch", "DAPASSWORD");
  62   if (!$db) {
  63     echo "Cant connect to server.<br>";
  64     exit();
  65   }
  66   if (! @mysql_select_db($dab)) {
  67     echo "Cant connect to DB.<br>";
  68     exit();
  69   }
  70   $result=mysql_query($sqlquery);
  71   return($result);
  72 }
  73 ?>