<?php
include ("src/jpgraph.php");
include ("src/jpgraph_bar.php");

function open_connect(){
$host="localhost";
$usrname="root";
$usrpwd="";
$dbname="aws";
$link=mysql_connect($host,$usrname,$usrpwd) or die ("Database Tak Terhubung!");
mysql_select_db($dbname,$link);
return $link;
}

$sqlstr="SELECT avg_harian.* FROM avg_harian ORDER BY Hari_ke";
$link=open_connect();
$qrydtl=mysql_query($sqlstr,$link) or die("Query Salah!");
while($rowdtl=mysql_fetch_object($qrydtl)){
$datay[]=$rowdtl->PAINS_HPA;
$datax[]=$rowdtl->Hari_ke;
}

$width=800;
$height=480;
$height=(mysql_num_rows($qrydtl))*30;

$graph=new Graph($width,$height,'auto');
$graph->SetScale("textlin");

$graph->SetFrame(true);
$graph->Set90AndMargin(180,10,60,10);
$graph->SetMarginColor('blue');
$graph->SetBox();

$graph->SetBackgroundGradient('white','blue',GRAD_HOR,BGRAD_PLOT);

$graph->title->set("AVG_PAINS_HPA");
$graph->title->setFont(FF_VERDANA,FS_BOLD,10);

$graph->xaxis->SetTickLabels($datax);
$graph->xaxis->SetFont(FF_VERDANA,FS_NORMAL,8);

$graph->xaxis->SetLabelMargin(10);
$graph->xaxis->SetLabelAlign('right','center');

$graph->yaxis->scale->SetGrace(20);
$graph->yaxis->Hide();

$bplot=new BarPlot($datay);

$bplot->SetShadow();
$bplot->SetWidth(0.75);

$bplot->SetFillGradient('white','orange',GRAD_HOR);
$bplot->SetFillGradient("navy","#EEEEEE",GRAD_LEFT_REFLECTION);

$bplot->value->Show();
$bplot->value->SetFont(FF_ARIAL,FS_BOLD,8);
$bplot->value->SetAlign('left','center');
$bplot->value->SetColor("black");
$bplot->value->SetFormat('%.1f');
$bplot->SetValuePos('max');
$bplot->SetColor("white");

$graph->Add($bplot);

$graph->Stroke();
?>