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 ("jpgraph14/jpgraph.php");
include ("jpgraph14/jpgraph_line.php");
$id_film = $HTTP_GET_VARS['id'];
connectionDB($host,$user,$pwd,$base) ;
$query = "SELECT t1.id_film, t1.titre, t1.prix, t2.des_cat, t5.des_mois, t1.nb_ent, t1.3m, t1.6m, t1.12m, t1.ean, t3.des_supp, t4.des_distrib, t6.des_ss_cat, t7.des_ss_ss_cat,t1.coffret, t1.autre_supp, t1.annee, t1.id_budgetm, t1.12m/t1.nb_ent*100 FROM films t1
INNER JOIN categories t2 ON t1.id_cat = t2.id_cat
INNER JOIN supports t3 ON t1.id_supp = t3.id_supp
INNER JOIN distributeurs t4 ON t1.id_distrib = t4.id_distrib
INNER JOIN mois t5 ON t1.id_mois = t5.id_mois
INNER JOIN ss_cat t6 ON t1.id_ss_cat = t6.id_ss_cat
INNER JOIN ss_ss_cat t7 ON t1.id_ss_ss_cat = t7.id_ss_ss_cat
WHERE (t1.id_film LIKE $id_film)" ;
$res = execQuery($query) ;
$num_row = mysql_num_rows($res) ;
$ydata = array($t1.3m,$t1.6m,$t1.12m);
// Creation du graphique
$graph = new Graph(500,500);
$graph->SetScale("textlin");
// Création du système de points
$lineplot=new LinePlot($ydata);
// On rajoute les points au graphique
$graph->Add($lineplot);
// Affichage
$graph->Stroke(); |
Partager