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 32 33 34 35 36 37
| <?php
include_once ("src/jpgraph.php");
include_once ("src/jpgraph_line.php");
function creertableau($nom_schema,$query,$num_colonne)
{
$conn = oci_connect("login", "mdp",$nom_schema);
$qqqq = oci_parse($conn, $query);
oci_execute($qqqq, OCI_DEFAULT);
while (oci_fetch($qqqq)) { $le_tableau_attendu[]=oci_result($qqqq,$num_colonne) ;}
return $le_tableau_attendu;
}
$superrequete1 ="select To_Char(SYSDATE,'yyyy')-To_Char(date_naissance,'yyyy') AS age,
Count(*) AS nb from latable
group by To_Char(SYSDATE,'yyyy')-To_Char(date_naissance,'yyyy')";
$superrequete2='select civilite,count(*) as nb from gedimat.client_adresse group by civilite';
//$y1=creertableau('prod2',$superrequete1,1);
$y2=creertableau('prod2',$superrequete1,2);
$graph1 = new Graph(400,300);
$graph1->SetScale("textlin");
//$graph2 = new Graph(400,300);
//$graph2->SetScale("textlin");
//$lineplot1=new LinePlot($y1);
$lineplot2=new LinePlot($y2);
// On ajoutte ce tracé au graph
//$graph1->Add($lineplot1);
$graph1->Add($lineplot2);
//$graph2->Add($lineplot2);
// On affiche le graphique
$graph1->Stroke();
//$graph2->Stroke();
?> |
Partager