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
|
<?
if(isset($HTTP_GET_VARS['mn'])){
session_start();
include("./scripts/connect.php");
print("
<html>
<head>
<title>DATA VISTA</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
<link rel=\"stylesheet\" type=\"text/css\" href=\"./css/text.css\">
</head>
<body>
<center>
<img src=\"./images/titre.gif\">
<br>
________________________________________________________________________<br><br>
");
}
else
include("./header.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.12m/t1.nb_ent 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) ;
// ---------------------------------------------------------------------------------------
if(isset($_SESSION['msg_sql'])){
print("<a class=msg >".$_SESSION['msg_sql']."</a>");
}
// ---------------------------------------------------------------------------------------
for ($i=0; $i<$num_row;$i++)
{
$row = mysql_fetch_array($res) ;
print ("<table width=85% border=1><tr><td width=175>TITRE :</td><td align=left><strong>$row[1]</strong></td></tr>") ;
print ("<tr><td>Code EAN :</td><td align=left><strong>$row[9]</strong></td></tr>") ;
print ("<tr><td>FORMAT :</td><td align=left><strong>$row[10]</strong></td></tr>") ;
print ("<tr><td>COFFRET :</td><td align=left><strong>");
if($row[14]==1)
print("NON</strong></td></tr>") ;
else
print("OUI</strong></td></tr>") ;
print ("<tr><td>REEDITION :</td><td align=left><strong>");
if($row[15]==1)
print("NON</strong></td></tr>") ;
else
print("OUI</strong></td></tr>") ;
print ("<tr><td>PRIX MOYEN:</td><td align=left><strong>$row[2] </strong></td></tr>") ;
print ("<tr><td>DISTRIBUTEUR :</td><td align=left><strong>$row[11] </strong></td></tr>") ;
print ("<tr><td>CATEGORIE :</td><td align=left><strong>$row[3]</strong></td></tr>") ;
print ("<tr><td>SOUS CATEGORIE :</td><td align=left><strong>$row[12]</strong></td></tr>") ;
print ("<tr><td>SOUS SS CATEGORIE :</td><td align=left><strong>$row[13]</strong></td></tr>") ;
print ("<tr><td>MOIS DE SORTIE :</td><td align=left><strong>$row[4]</strong></td></tr>") ;
print ("<tr><td>ANNEE DE SORTIE :</td><td align=left><strong>$row[16]</strong></td></tr>") ;
print ("<tr><td>NOMBRE D'ENTREES :</td><td align=left><strong>$row[5]</strong></td></tr>") ;
print ("<tr><td>QTÉ VENDUE à 3 MOIS :</td><td align=left><strong>$row[6]</strong></td></tr>") ;
print ("<tr><td>QTÉ VENDUE à 6 MOIS :</td><td align=left><strong>$row[7]</strong></td></tr>") ;
print ("<tr><td>QTÉ VENDUE à 12 MOIS :</td><td align=left><strong>$row[8]</strong></td></tr></table>") ;
print ("<tr><td>ce que tu veux :</td><td align=left><strong>$row[17]</strong></td></tr></table>") ;
}
include('./feet.php');
?> |
Partager