
php
<?php require ('config/config.php'); $sql = mysql_query("SELECT rampercent FROM `sys_info` WHERE data > '2012-01-20 6:00:00' AND data < '2012-01-20 9:00:00' ORDER BY data ASC"); $data = ''; $data .= $row['rampercent'] . '|'; } ?>
Reszta php wyglada tak samo tylko zmienia to co jest pobierane z bazy
jquery/ajax:
<!-- 1. Add these JavaScript inclusions in the head of your page --> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script> <script type="text/javascript" src="js/highcharts.js"></script> <script type="text/javascript" src="js/themes/gray.js"></script> <!-- 1b) Optional: the exporting module --> <script type="text/javascript" src="js/modules/exporting.js"></script> <!-- 2. Add the JavaScript to initialize the chart on document ready --> <script type="text/javascript"> $(document).ready(function() { var chart; var CPUdata; var HDDdata; var RAMdata; $.ajax({ url: 'getCPUdata.php', success: function(data){ for(var i = 0; i < CPUdata.length; i++) { CPUdata[i] = parseFloat(CPUdata[i]); } //url: 'getRAMdata.php', //success: function(data){ //RAMdata = data.split('|'); //for(var i = 0; i <RAMdata.length; i++) { //RAMdata[i] = parseFloat(RAMdata[i]); //} createChart(CPUdata) //tutaj w nawiasie robilem (CPUdata, RAMdata) } }); function createChart(CPUdata) { //tutaj w nawiasie robilem (CPUdata, RAMdata) chart = new Highcharts.Chart({ chart: { renderTo: 'container', defaultSeriesType: 'line' }, title: { text: 'Zuzycie CPU ' }, subtitle: { text: 'Ostatnie 24h' }, xAxis: { categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'] }, yAxis: { title: { text: 'Zyzycie w %' } }, tooltip: { enabled: false, formatter: function() { return '<b>'+ this.series.name +'</b><br/>'+ this.x +': '+ this.y +'°C'; } }, plotOptions: { line: { dataLabels: { enabled: true }, enableMouseTracking: false } }, series: [{ name: 'RAM', data: [1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2] }, { name: 'CPU', data: CPUdata }] }); } }); </script> <!-- 3. Add the container --> <div id="container" style="width: 800px; height: 400px; margin: 0 auto"></div>
No i nie mam pojęcia jak to zrobić