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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
| <?php
if(isset($_GET['nom'])){
$ns =$_GET['nom'];
echo $ns;
}
// Connexion au serveur de base de données
$link = mysql_connect("127.0.0.1","root","");
if (!$link)
{
die('Connexion impossible : ' . mysql_error());
}
//echo 'Connecté correctement';
// Sélection de la base de données
$db_selected = mysql_select_db('npidb',$link);
if (!$db_selected)
{
die ('Impossible de sélectionner la base de données : ' . mysql_error());
}
// On va chercher les enregistrements disponibles
$sql =
'SELECT
Release_gsm AS "Release GSM"
, Sub_release_gsm AS "Sub Release"
, SUM("'".$ns."'") AS "BSC Qty"
, FORMAT(100*SUM("'".$ns."'")/(SELECT SUM("'".$ns."'") FROM customer), 1) AS Pourcentage
FROM
customer
WHERE
network_status = "active" -- réseau actif
AND NOT Release_gsm = "/"
GROUP BY
Release_gsm, Sub_release_gsm
-- WITH ROLLUP
'
;
$result = mysql_query($sql) or die('Erreur SQL : <br />'.$sql);
// On affiche le contenu si la table n'est pas vide
if (mysql_num_rows($result) > 0)
{
//echo '<br />';
while ($donnees = mysql_fetch_assoc($result))
{
//echo $donnees['datation'].' '.$donnees['type'].' '.$donnees['valeur'].'<br />';
$data[] = $donnees['Pourcentage'];
//echo $data1y.'<br />';
}
}
// content="text/plain; charset=utf-8"
require_once ('jpgraph.php');
require_once ('jpgraph_pie.php');
require_once ('jpgraph_pie3d.php');
//$gJpgBrandTiming=true;
// Some data
//$data = array(40,21,17,27,23);
// Create the Pie Graph.
$graph = new PieGraph(600,400,'auto');
$graph->SetShadow();
// Set A title for the plot
$graph->title->Set("3D Pie Client side image map");
$graph->title->SetFont(FF_FONT1,FS_BOLD);
// Create
$p1 = new PiePlot3D($data);
$p1->SetLegends(array("Jan (%d)","Feb","Mar","Apr","May","Jun","Jul"));
$targ=array("pie3d_csimex1.php?v=1","pie3d_csimex1.php?v=2","pie3d_csimex1.php?v=3",
"pie3d_csimex1.php?v=4","pie3d_csimex1.php?v=5","pie3d_csimex1.php?v=6");
$alts=array("val=%d","val=%d","val=%d","val=%d","val=%d","val=%d");
$p1->SetCSIMTargets($targ,$alts);
// Use absolute labels
$p1->SetLabelType(1);
$p1->value->SetFormat("%d kr");
// Move the pie slightly to the left
$p1->SetCenter(0.4,0.5);
$graph->Add($p1);
// Send back the HTML page which will call this script again
// to retrieve the image.
$graph->StrokeCSIM();
?> |
Partager