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 38 39 40 41 42 43 44 45 46
|
<?php
require_once "../artichow/BarPlot.class.php";
// je fais appel a ma connection
$hostname_connect = "localhost";
$database_connect = "gestion_enseignants";
$username_connect = "root";
$password_connect = "";
$connect = mysql_pconnect($hostname_connect, $username_connect, $password_connect) or trigger_error(mysql_error(),E_USER_ERROR);
$graph = new Graph(550, 400);
// j'etablis ma requête
$connexion = mysql_connect($hostname_connect, username_connect, $password_connect) or die('Erreur de connexion a la base') ;
mysql_select_db($database_connect, $connexion);
$sql = "select VILLE, count(*) from etablissement group by VILLE";
$result = mysql_query( $sql ) or die ( mysql_error() );
while ($resultat = mysql_fetch_array($result))
{$resultat['VILLE'];}
$values = array(2, 1, 3, 6, 4);
$plot = new BarPlot($values);
$plot->setBarGradient(
new LinearGradient(
new LightBlue(25),
new VeryLightOrange(25),
90
)
);
$plot->setSpace(5, 5, NULL, NULL);
$plot->barShadow->setSize(4);
$plot->barShadow->setPosition(Shadow::RIGHT_TOP);
$plot->barShadow->setColor(new Color(180, 180, 180, 10));
$plot->barShadow->smooth(TRUE);
$graph->add($plot);
$graph->draw();
?> |
Partager