66 lines
1.7 KiB
PHP
66 lines
1.7 KiB
PHP
<?php
|
|
// content="text/plain; charset=utf-8"
|
|
|
|
require_once ('src/jpgraph.php');
|
|
require_once ('src/jpgraph_line.php');
|
|
|
|
// FOR DB CONNECTION
|
|
$link = mysql_connect('controls2k8', 'corey', '41945549')
|
|
or die('Could not connect: ' . mysql_error());
|
|
|
|
mysql_select_db('controls') or die('Could not select database');
|
|
|
|
$dataArray=array();
|
|
|
|
//get data from database
|
|
$sql="SELECT timestamp, imbflow FROM trending where trending.id mod 16 = 0 GROUP BY timestamp DESC LIMIT 96";
|
|
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
|
|
if ($result) {
|
|
while ($row = mysql_fetch_assoc($result)) {
|
|
$datay[] = $row["timestamp"];
|
|
$datax1[] = $row["imbflow"];
|
|
|
|
}
|
|
}
|
|
// Setup the graph
|
|
$graph = new Graph(1600,520);
|
|
$graph->SetScale('linlin',0,600);
|
|
$graph->yaxis->scale->ticks->Set(5,10);
|
|
|
|
$theme_class=new UniversalTheme;
|
|
|
|
$graph->SetTheme($theme_class);
|
|
$graph->img->SetAntiAliasing(false);
|
|
$graph->title->Set('Graph');
|
|
$graph->img->SetMargin(70,15,30,125); // Sets the margin. L, R, T, B
|
|
$graph->title->Set('Immibition Flow Past 24 Hours');
|
|
$graph->subtitle->Set('(15 Minute Intervals)');
|
|
$graph->xaxis->title->Set();
|
|
$graph->yaxis->title->Set('GPM');
|
|
$graph->SetBox(false);
|
|
|
|
$graph->img->SetAntiAliasing();
|
|
|
|
$graph->yaxis->HideZeroLabel();
|
|
$graph->yaxis->HideLine(false);
|
|
$graph->yaxis->HideTicks(false,false);
|
|
$graph->yaxis->title->Set('Immibition Flow');
|
|
$graph->yaxis->SetTitleMargin(50);
|
|
|
|
$graph->xgrid->Show();
|
|
$graph->xgrid->SetLineStyle("solid");
|
|
$graph->xaxis->SetTickLabels($datay);
|
|
$graph->xaxis->SetLabelAngle(65);
|
|
$graph->xgrid->SetColor('#E3E3E3');
|
|
|
|
// Create line 1
|
|
$p1=new LinePlot($datax1);
|
|
$graph->Add($p1);
|
|
$p1->SetColor("green");
|
|
$p1->SetLegend('');
|
|
|
|
$graph->legend->SetFrameWeight(1);
|
|
|
|
// Output line
|
|
$graph->Stroke();
|
|
?>
|