<?php
//database
require_once "config.php";
// Standard inclusions
include("pChart/pData.class");
include("pChart/pChart.class");
$age1 = $_POST["age1"];
$DataSet = new pData();
foreach($_POST['admin'] as $categ){
//generate a random key for the picture file
$key=rand();
$sql = "select count(distinct `IDPat`) as Nombre, annee, CIMO from export where CIMO like '".$categ."'
and age>=".$age1."
group by annee order by annee desc";
$result = mysql_query($sql) or die(mysql_error());
//init var
$Nombre="";
$annee="";
echo "<table border='1'>
<tr>
<th>Nombre</th>
<th>annee</th>
<th>LesionCIMO</th>
</tr>";
while($row = mysql_fetch_assoc($result))
{
echo "<tr>";
echo "<td>" . $row['Nombre'] . "</td>";
echo "<td>" . $row['annee'] . "</td>";
echo "<td>" . $row['CIMO'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo "<br/><br/>";
/* Push the results of the query in an array */
while($rowz = mysql_fetch_array($result)) {
$Nombre[] = $rowz['Nombre'];
$annee[] = $rowz['annee'];
}
$DataSet->AddPoint($Nombre,"Nombre");
$DataSet->AddPoint($annee,"Annee");
$DataSet->AddAllSeries();
$DataSet->RemoveSerie("Annee");
$DataSet->SetAbsciseLabelSerie("Annee");
$DataSet->SetSerieName("Nombre","Nombre");
$DataSet->SetYAxisName("Nombre");
// Initialise the graph
$Test = new pChart(700,230);
$Test->setFontProperties("Fonts/tahoma.ttf",8);
$Test->setGraphArea(50,30,585,200);
$Test->drawFilledRoundedRectangle(7,7,693,223,5,240,240,240);
$Test->drawRoundedRectangle(5,5,695,225,5,230,230,230);
$Test->drawGraphArea(255,255,255,TRUE);
$Test->drawScale($DataSet->GetData(),$DataSet->GetDataDescription(),SCALE_NORMAL,150,150,150,TRUE,0,2,TRUE);
$Test->drawGrid(4,TRUE,230,230,230,50);
// Draw the 0 line
$Test->setFontProperties("Fonts/tahoma.ttf",6);
$Test->drawTreshold(0,143,55,72,TRUE,TRUE);
// Draw the bar graph
$Test->drawOverlayBarGraph($DataSet->GetData(),$DataSet->GetDataDescription());
// Finish the graph
$Test->setFontProperties("Fonts/tahoma.ttf",8);
$Test->drawLegend(600,30,$DataSet->GetDataDescription(),255,255,255);
$Test->setFontProperties("Fonts/tahoma.ttf",10);
$Test->drawTitle(50,22,"Example",50,50,50,585);
$Test->Render("example$key.png");
}//end foreach
mysql_close($con)
?>
.
