1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| //connect to the database
$link = mysql_connect("localhost", "root", "") or die ("Impossible de se connecter : " . mysql_error());
mysql_select_db ( "maintenance" );
$myChart = $_REQUEST['myChart'];
$nb_major = 0;
$nb_minor = 0;
$nb_critical = 0;
$graph = new PieGraph (300,200);
$graph->SetShadow();
$sqlQuery = mysql_query ("select * from anomaly_follow_up.Severity") or die ("Impossible d'exécuter la requête : " . mysql_error());
$while($result = mysql_fetch_row($sqlQuery))
{
if ($result == 'major')
{
$nb_major++;
}
if ($result == 'minor')
{
$nb_minor++;
}
if ($result == 'critical')
{
$nb_critical++;
}
}
$data = array($nb_minor,$nb_major,$nb_critical);
$p1 = new PiePlot( $data);
$graph->Add( $p1);
$graph->Stroke(); |
Partager