<?php

include('./class.graph1');



$user = "root";

$motdepasse= "";

$mysqlserveur = "localhost";

$basedd= "appels";



//connection du serveur

$connect = mysql_connect($mysqlserveur,$user,$motdepasse)

or die("Erreur de connection!");



//Sélection de la base de données

$db = mysql_select_db($basedd,$connect)

or die("Erreur de base de données: $basedd");



$requete_sql="SELECT MAX( valeur) FROM tb_semaines";

$resultat_requete=mysql_query($requete_sql);

//$lagest=mysql_resultat($resultat_requete,tb_se

maines);



$requete_sql="SELECT Nar,Nanr FROM tb_semaines WHERE Dt>='$debut_semaine' AND Dt<='$fin_semaine' GROUP BY Appelant";

$resultat_requete=mysql_query($requete_sql,$conn

ect);



$i=0;



while ($colonne=mysql_fetch_array($resultat_requete))

{

$names[$i]=$colonne[Nar];

$values[$i]=$colonne[Nanr];

$i++;

}



$a=array();

for($i=0;$i<SizeOf($values);$i++)

{



phpplot(array(

  "box_showbox"=> true,

  "grid"=> true,

  "cubic"=> true,

  "zeroaxis"=> true,

  "title_text"=> "Occupation disques",

  "yaxis_labeltext"=> "Taille (en Mo)",

  "xaxis_labeltext"=> "Mois",

  "ymarkset" => array(1,5,10),

  "legend_shift"=> array(0,10),

  "size"=> array(600,300) ));



phpdata($a);



phpdraw("bargraph",array(

  "drawsets" => array(1,2),

  "legend" => array("System","Work","Bases","Prod"),

  "barspacing"=> 8,

  "showvalue"=> false ));



phpshow("graph.png");



echo "<img src=graph.png>";



}

?>

<?php

$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

?>