<?php   
/* CAT:Area Chart */

/* pChart library inclusions */
include("class/pData.class.php");
include("class/pDraw.class.php");
include("class/pImage.class.php");

/* Connect to the MySQL database */
$db = mysql_connect("localhost", "turup", "pass");
mysql_select_db("turup",$db);


/* Build the query that will returns the data to graph */
$Requete = "SELECT * FROM `measures`";
$Result  = mysql_query($Requete,$db);

while($row = mysql_fetch_array($Result))
{
  /* Push the results of the query in an array */
  $temperature[] = $row["temperature"];
  $humidity[]    = $row["humidity"];
}

/* Create and populate the pData object */
$MyData = new pData(); 

$MyData->addPoints(array($temperature),"temperature");
$MyData->addPoints(array($humidity),"humidity");

$MyData->setSerieTicks("humidity",4);

$MyData->setAxisName(0,"");

$MyData->addPoints(array("1","2","3"),"Labels");
$MyData->setSerieDescription("Labels","Months");
$MyData->setAbscissa("Labels");

/* Create the pChart object */
$myPicture = new pImage(700,230,$MyData);

/* Turn of Antialiasing */
$myPicture->Antialias = FALSE;

/* Add a border to the picture */
$myPicture->drawRectangle(0,0,699,229,array("R"=>0,"G"=>0,"B"=>0));

/* Write the chart title */
$myPicture->setFontProperties(array("FontName"=>"fonts/Forgotte.ttf","FontSize"=>11));
$myPicture->drawText(150,35,"Average temperature",array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMMIDDLE));

/* Set the default font */
$myPicture->setFontProperties(array("FontName"=>"fonts/pf_arma_five.ttf","FontSize"=>6));

/* Define the chart area */
$myPicture->setGraphArea(60,40,650,200);

/* Draw the scale */
$scaleSettings = array("XMargin"=>10,"YMargin"=>10,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE);
$myPicture->drawScale($scaleSettings);

/* Write the chart legend */
$myPicture->drawLegend(540,20,array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL));

/* Turn on Antialiasing */
$myPicture->Antialias = TRUE;

/* Draw the area chart */
$myPicture->drawAreaChart();

/* Render the picture (choose the best way) */
$myPicture->autoOutput("pictures/example.drawAreaChart.simple.png");
?>