
marcoeea
|
voici le code complet, j'espère qu'il pourra t'aider. Pour l'instant, je ne suis référencé nulle part.
<?php require_once('../Connections/Videotheque.php'); ?> <?php $hauteur = 0; $largeur = 0; $choix = 0; $choixfilm = 0; $choixpersonnalite = 0; $selection_url=''; $lance_url='';
if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } }
if (isset($_GET['ChoixFilm'])) { $choixfilm = $_GET['ChoixFilm'] ; $choix = 1; $selection_url=sprintf("Videotheque_Imprime_Selection.php?Choix=1&Numero=%s",$choixfilm); $hauteur = 500; $largeur = 760; } if (isset($_GET['ChoixPersonnalite'])) { $choixpersonnalite = $_GET['ChoixPersonnalite'] ; $choix = 2; $selection_url=sprintf("Videotheque_Imprime_Selection.php?Choix=2&Numero=%s",$choixpersonnalite); $hauteur = 250; $largeur = 750; }
if (isset($_GET['ChoixGenre'])) { $choixgenre = $_GET['ChoixGenre'] ; $choix = 3; } if (isset($_GET['ChoixRealisateur'])) { $choixrealisateur = $_GET['ChoixRealisateur'] ; $choix = 4; } if (isset($_GET['ChoixScenariste'])) { $choixscenariste = $_GET['ChoixScenariste'] ; $choix = 5; } if (isset($_GET['ChoixProduction'])) { $choixproduction = $_GET['ChoixProduction'] ; $choix = 6; }
mysql_select_db($database_Videotheque, $Videotheque); $query_ListeFilm = "SELECT NumFilm, Titre,Annee,Heures,Minutes FROM principal ORDER BY Titre ASC"; $ListeFilm = mysql_query($query_ListeFilm, $Videotheque) or die(mysql_error()); $row_ListeFilm = mysql_fetch_assoc($ListeFilm); $totalRows_ListeFilm = mysql_num_rows($ListeFilm);
mysql_select_db($database_Videotheque, $Videotheque); $query_ListeFilm_Stats = "SELECT NumFilm, Titre,Annee,Heures,Minutes FROM principal ORDER BY Titre ASC"; $ListeFilm_Stats = mysql_query($query_ListeFilm_Stats, $Videotheque) or die(mysql_error()); $row_ListeFilm_Stats = mysql_fetch_assoc($ListeFilm_Stats); $totalRows_ListeFilm_Stats = mysql_num_rows($ListeFilm_Stats);
$Annee_Stats = $row_ListeFilm_Stats['Annee']; $Heures_Stats = $row_ListeFilm_Stats['Heures']; $Minutes_Stats = $row_ListeFilm_Stats['Minutes']; $FilmVieux = $row_ListeFilm_Stats['Annee']; $NumFilmVieux = $row_ListeFilm_Stats['NumFilm']; $FilmLong = $Minutes_Stats + 60 * $Heures_Stats; $NumFilmLong = $row_ListeFilm_Stats['NumFilm']; while ($row_ListeFilm_Stats = mysql_fetch_assoc($ListeFilm_Stats)) { $Annee_Stats += $row_ListeFilm_Stats['Annee']; $Heures_Stats += $row_ListeFilm_Stats['Heures']; $Minutes_Stats += $row_ListeFilm_Stats['Minutes']; $Test_Temps = $Minutes_Stats + 60 * $Heures_Stats; if ($FilmVieux > $row_ListeFilm_Stats['Annee']) { $FilmVieux = $row_ListeFilm_Stats['Annee']; $NumFilmVieux = $row_ListeFilm_Stats['NumFilm']; } if ($FilmLong > $Test_Temps) { $FilmLong = $Test_Temps; $NumFilmLong = $row_ListeFilm_Stats['NumFilm']; } } $Annee_Stats = (int)($Annee_Stats / $totalRows_ListeFilm_Stats) ; $Temps_Total = (60 * $Heures_Stats + $Minutes_Stats)/$totalRows_ListeFilm_Stats; $Heure_Moyenne = (int)($Temps_Total / 60); $Minutes_Moyenne = (int)($Temps_Total - 60 * $Heure_Moyenne);
mysql_select_db($database_Videotheque, $Videotheque); $query_ListePersonnalite = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite ORDER BY Nom ASC"; $ListePersonnalite = mysql_query($query_ListePersonnalite, $Videotheque) or die(mysql_error()); $row_ListePersonnalite = mysql_fetch_assoc($ListePersonnalite); $totalRows_ListePersonnalite = mysql_num_rows($ListePersonnalite); mysql_select_db($database_Videotheque, $Videotheque); $query_ListeComedien = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite WHERE NumFonction = 1 ORDER BY Nom ASC"; $ListeComedien = mysql_query($query_ListeComedien, $Videotheque) or die(mysql_error()); $row_ListeComedien = mysql_fetch_assoc($ListeComedien); $totalRows_ListeComedien = mysql_num_rows($ListeComedien);
mysql_select_db($database_Videotheque, $Videotheque); $query_ListeRealisateur = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite WHERE NumFonction = 2 OR NumFonction = 5 ORDER BY Nom ASC"; $ListeRealisateur = mysql_query($query_ListeRealisateur, $Videotheque) or die(mysql_error()); $row_ListeRealisateur = mysql_fetch_assoc($ListeRealisateur); $totalRows_ListeRealisateur = mysql_num_rows($ListeRealisateur);
mysql_select_db($database_Videotheque, $Videotheque); $query_ListeScenariste = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite WHERE NumFonction = 3 OR NumFonction = 5 ORDER BY Nom ASC"; $ListeScenariste = mysql_query($query_ListeScenariste, $Videotheque) or die(mysql_error()); $row_ListeScenariste = mysql_fetch_assoc($ListeScenariste); $totalRows_ListeScenariste = mysql_num_rows($ListeScenariste);
mysql_select_db($database_Videotheque, $Videotheque); $query_ListeProducteur = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite WHERE NumFonction = 4 ORDER BY Nom ASC"; $ListeProducteur = mysql_query($query_ListeProducteur, $Videotheque) or die(mysql_error()); $row_ListeProducteur = mysql_fetch_assoc($ListeProducteur); $totalRows_ListeProducteur = mysql_num_rows($ListeProducteur);
do { $choix_acteur = mt_rand(0, $totalRows_ListePersonnalite); $query_ActeurAleatoire = sprintf("SELECT * from personnalite WHERE NumPersonnalite=%s AND NumFonction = 1",$choix_acteur); $ActeurAleatoire = mysql_query($query_ActeurAleatoire,$Videotheque); $row_ActeurAleatoire = mysql_fetch_assoc($ActeurAleatoire); $totalRows_ActeurAleatoire = mysql_num_rows($ActeurAleatoire); } while ($totalRows_ActeurAleatoire == 0);
do { $choix_album = mt_rand(0, $totalRows_ListeFilm); $query_FilmAleatoire = sprintf("SELECT principal.NumFilm,principal.Jaquette,principal.Annee,principal.Heures,principal.Minutes,principal.Titre,principal.NumNationalite1,principal.NumNationalite2,principal.NumFormat,genre.NumGenre,genre.Genre from principal,genre WHERE principal.NumFilm = %s AND principal.NumGenre = genre.NumGenre",$choix_album); $FilmAleatoire = mysql_query($query_FilmAleatoire,$Videotheque); $row_FilmAleatoire = mysql_fetch_assoc($FilmAleatoire); $totalRows_FilmAleatoire = mysql_num_rows($FilmAleatoire); } while ($totalRows_FilmAleatoire == 0);
$query_SelectFilmVieux = sprintf("SELECT principal.NumFilm,principal.Jaquette,principal.Annee,principal.Heures,principal.Minutes,principal.Titre,principal.NumNationalite1,principal.NumNationalite2,principal.NumFormat,genre.NumGenre,genre.Genre from principal,genre WHERE principal.NumFilm = %s AND principal.NumGenre = genre.NumGenre",$NumFilmVieux); $SelectFilmVieux = mysql_query($query_SelectFilmVieux,$Videotheque); $row_SelectFilmVieux = mysql_fetch_assoc($SelectFilmVieux); $totalRows_SelectFilmVieux = mysql_num_rows($SelectFilmVieux); $query_SelectFilmLong = sprintf("SELECT principal.NumFilm,principal.Jaquette,principal.Annee,principal.Heures,principal.Minutes,principal.Titre,principal.NumNationalite1,principal.NumNationalite2,principal.NumFormat,genre.NumGenre,genre.Genre from principal,genre WHERE principal.NumFilm = %s AND principal.NumGenre = genre.NumGenre",$NumFilmLong); $SelectFilmLong = mysql_query($query_SelectFilmLong,$Videotheque); $row_SelectFilmLong = mysql_fetch_assoc($SelectFilmLong); $totalRows_SelectFilmLong = mysql_num_rows($SelectFilmLong);
mysql_select_db($database_Videotheque, $Videotheque); $query_VideoGenre = "SELECT * FROM genre ORDER BY Genre ASC"; $VideoGenre = mysql_query($query_VideoGenre, $Videotheque) or die(mysql_error()); $row_VideoGenre = mysql_fetch_assoc($VideoGenre); $totalRows_VideoGenre = mysql_num_rows($VideoGenre);
mysql_select_db($database_Videotheque, $Videotheque); $query_VideoRealisateur = "SELECT NumPersonnalite,Nom, Prenom FROM personnalite WHERE NumFonction = 2 OR NumFonction = 5 ORDER BY Nom ASC"; $VideoRealisateur = mysql_query($query_VideoRealisateur, $Videotheque) or die(mysql_error()); $row_VideoRealisateur = mysql_fetch_assoc($VideoRealisateur); $totalRows_VideoRealisateur = mysql_num_rows($VideoRealisateur);
mysql_select_db($database_Videotheque, $Videotheque); $query_VideoScenariste = "SELECT NumPersonnalite, Nom, Prenom FROM personnalite WHERE NumFonction = 3 OR NumFonction = 5 ORDER BY Nom ASC"; $VideoScenariste = mysql_query($query_VideoScenariste, $Videotheque) or die(mysql_error()); $row_VideoScenariste = mysql_fetch_assoc($VideoScenariste); $totalRows_VideoScenariste = mysql_num_rows($VideoScenariste);
mysql_select_db($database_Videotheque, $Videotheque); $query_VideoProduction = "SELECT * FROM production ORDER BY Production ASC"; $VideoProduction = mysql_query($query_VideoProduction, $Videotheque) or die(mysql_error()); $row_VideoProduction = mysql_fetch_assoc($VideoProduction); $totalRows_VideoProduction = mysql_num_rows($VideoProduction);
function Affichage($valeur) { $valeur ="/jaquettes/Video/Affiches/".$valeur; return $valeur; } function Affichageflags($valeur) { $valeur ="/Jaquettes/Video/Drapeaux/".$valeur; return $valeur; } function AffichagePhoto($valeur) { $valeur ="/jaquettes/Video/Photos/".$valeur; return $valeur; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Videotheque.gif</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript"> <!-- function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function mmLoadMenus() { if (window.mm_menu_0927233930_0) return; window.mm_menu_0927233930_0 = new Menu("root",156,20,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#cc0000","#333333","#ffff99","center","middle",3,0,650,-5,7,true,false,true,0,false,true); mm_menu_0927233930_0.addMenuItem("Acteur","window.open('Insertion_Personnalite.php?choix=1', '_blank','width=510,height=280');"); mm_menu_0927233930_0.addMenuItem("Distributeur","window.open('Insertion_Distributeur.php', '_blank','width=420,height=170');"); mm_menu_0927233930_0.addMenuItem("Film","window.open('Insertion_Film.php', '_blank','width=745,height=445');"); mm_menu_0927233930_0.addMenuItem("Genre","window.open('Insertion_Genre.php','_blank','width=420,height=170');"); mm_menu_0927233930_0.addMenuItem("Nationalité","window.open('Insertion_Nationalite.php','_blank','width=420,height=170');"); mm_menu_0927233930_0.addMenuItem("Musicien","window.open('Insertion_Personnalite.php?choix=6', '_blank','width=510,height=280');"); mm_menu_0927233930_0.addMenuItem("Production","window.open('Insertion_Production.php', '_blank','width=420,height=170');"); mm_menu_0927233930_0.addMenuItem("Réalisateur","window.open('Insertion_Personnalite.php?choix=2', '_blank','width=510,height=280');"); mm_menu_0927233930_0.addMenuItem("Scénariste","window.open('Insertion_Personnalite.php?choix=3', '_blank','width=510,height=280');"); mm_menu_0927233930_0.bgImageUp="images/mmmenu3_156x20_up.gif"; mm_menu_0927233930_0.bgImageOver="images/mmmenu3_156x20_over.gif"; mm_menu_0927233930_0.fontWeight="bold"; mm_menu_0927233930_0.hideOnMouseOut=true; mm_menu_0927233930_0.bgColor='#ffff00'; window.mm_menu_0927234250_1 = new Menu("root",156,20,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#ff0000","#333333","#ffff99","center","middle",3,0,650,-5,7,true,false,true,0,false,true); mm_menu_0927234250_1.addMenuItem("Film ou Acteur en Cours","window.open('<?php echo $selection_url; ?>', '_blank','width=<?php echo $largeur;?>,height=<?php echo $hauteur;?>,menubar=yes,scrollbars=yes, resizable = yes');"); mm_menu_0927234250_1.addMenuItem("Par Acteur"); mm_menu_0927234250_1.addMenuItem("Par Film"); mm_menu_0927234250_1.addMenuItem("Par Genre"); mm_menu_0927234250_1.addMenuItem("Par Scénariste"); mm_menu_0927234250_1.addMenuItem("Par Réalisateur"); mm_menu_0927234250_1.bgImageUp="images/mmmenu2_156x20_up.gif"; mm_menu_0927234250_1.bgImageOver="images/mmmenu2_156x20_over.gif"; mm_menu_0927234250_1.fontWeight="bold"; mm_menu_0927234250_1.hideOnMouseOut=true; mm_menu_0927234250_1.bgColor='#ffff00'; window.mm_menu_0927234354_2 = new Menu("root",156,20,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#ff0000","#333333","#ffff99","center","middle",3,0,650,-5,7,true,false,true,0,false,true); mm_menu_0927234354_2.addMenuItem("Par Année","window.open('Videoscope.php?choix=1','_blank');"); mm_menu_0927234354_2.addMenuItem("Par Film","window.open('Videoscope.php?choix=2', '_blank');"); mm_menu_0927234354_2.addMenuItem("Par Distributeur","window.open('Videoscope.php?choix=3', '_blank');"); mm_menu_0927234354_2.addMenuItem("Par Réalisateur","window.open('Videoscope.php?choix=4', '_blank');"); mm_menu_0927234354_2.addMenuItem("Les Acteurs","window.open('Videoscope.php?choix=5', '_blank');"); mm_menu_0927234354_2.bgImageUp="images/mmmenu1_156x20_up.gif"; mm_menu_0927234354_2.bgImageOver="images/mmmenu1_156x20_over.gif"; mm_menu_0927234354_2.fontWeight="bold"; mm_menu_0927234354_2.hideOnMouseOut=true; mm_menu_0927234354_2.bgColor='#ffff00';
mm_menu_0927234354_2.writeMenus(); } // mmLoadMenus()
function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); }
function MM_goToURL() { //v3.0 var i, args=MM_goToURL.arguments; document.MM_returnValue = false; for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'"); }
function MM_showHideLayers() { //v6.0 var i,p,v,obj,args=MM_showHideLayers.arguments; for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2]; if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; } obj.visibility=v; } }
//--> </script> <script language="JavaScript1.2" type="text/javascript" src="mm_menu.js"></script> <style type="text/css"> <!-- .Style1 { color: #FFFFFF; font-family: "Eras Ult BT"; font-size: 20px; } .Style2 { font-family: Arial, Helvetica, sans-serif; color: #CCCCCC; font-size: 14px; font-weight: bold; font-style: italic; } .Style3 { font-family: "Bauhaus 93"; color: #000000; font-weight: bold; } .Style8 {font-style: italic; font-family: Arial, Helvetica, sans-serif; font-size: 14px;} .Style11 { font-size: 14px; font-weight: bold; font-family: Arial, Helvetica, sans-serif; font-style: italic; } #Genre { position:absolute; left:993px; top:74px; width:255px; height:303px; z-index:1; background-color: #CCCCCC; visibility: hidden; } #Genre { border: medium outset #CCCCCC; } #Genre select { background-color: #CCCCCC; width: 250px; } #Realisateur { position:absolute; left:993px; top:74px; width:255px; height:303px; z-index:2; background-color: #CCCCCC; visibility: hidden; } #Realisateur select { background-color: #CCCCCC; width: 250px; } #Realisateur { border: medium outset #CCCCCC; } #Scenariste { position:absolute; left:994px; top:73px; width:262px; height:309px; z-index:3; background-color: #CCCCCC; visibility: hidden; } #Scenariste form { background-color: #CCCCCC; width: 250px; } #Scenariste { height: 303px; width: 255px; border-top-style: outset; border-right-style: outset; border-bottom-style: outset; border-left-style: outset; border-top-color: #CCCCCC; border-right-color: #CCCCCC; border-bottom-color: #CCCCCC; border-left-color: #CCCCCC; background-color: #CCCCCC; } #Scenariste select { background-color: #CCCCCC; width: 250px; } #Layer1 { position:absolute; left:862px; top:65px; width:261px; height:313px; z-index:4; background-color: #CCCCCC; } #Layer2 { position:absolute; left:414px; top:209px; width:1px; height:1px; z-index:4; } #Production { position:absolute; left:565px; top:158px; width:323px; height:224px; z-index:4; background-color: #CCCCCC; visibility: hidden; } #Production { left: 993px; top: 74px; height: 303px; width: 255px; border-top-style: outset; border-right-style: outset; border-bottom-style: outset; border-left-style: outset; } #Production select { background-color: #CCCCCC; width: 250px; } .ListeFilm { background-color: #000000; width: 220px; color: #FFFFFF; border-top-color: #000000; border-right-color: #000000; border-bottom-color: #000000; border-left-color: #000000; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } .ListePersonne { background-color: #000000; width: 220px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #FFFFFF; } body { background-color: #000000; } .Style12 { color: #FFFF00; font-family: "LED BOARD REVERSED"; font-size: 9px; } .Style13 { font-family: "Raspoutine Classic"; font-size: 12px; color: #FF9900; } #ListeGenre { position:absolute; left:242px; top:117px; width:747px; height:783px; z-index:5; background-color: #C6CBD4; visibility: hidden; } #ListeRealisateur { position:absolute; left:243px; top:116px; width:745px; height:784px; z-index:6; background-color: #FFCCFF; visibility: hidden; } #ListeScenariste { position:absolute; left:239px; top:117px; width:746px; height:785px; z-index:7; background-color: #FFFFCC; visibility: hidden; } #ListeFilm { position:absolute; left:236px; top:114px; width:747px; height:786px; z-index:8; background-color: #CCCCFF; visibility: hidden; } #ListeActeur { position:absolute; left:234px; top:112px; width:749px; height:788px; z-index:9; background-color: #CC99FF; visibility: hidden; } .Style14 {color: #FF0000} .Style15 {color: #FF00FF} --> </style> <script src="../scripts/AC_RunActiveContent.js" type="text/javascript"></script> </head> <body onLoad="MM_preloadImages('Images/Videotheque_r2_c12_survol.gif','Images/Videotheque_r2_c17_Survol.gif','Images/Videotheque_r2_c18_Survol.gif','Images/Videotheque_r2_c20_Survol.gif','Images/Videotheque_r5_c1_Survol.gif','Images/Videotheque_r9_c1_Survol.gif','Images/Videotheque_r10_c1_Survol.gif','Images/Videotheque_r13_c1_Survol.gif','Images/Videotheque_Calque_Ferme_survol.gif')"> <?php switch ($choix) { case 1 : $choixstyle="visibilty:visible"; echo "bonjour";?> <? break; case 2 : break; case 3 : break; case 4 : break; case 5 : break; case 6 : break; } ?>
<div id="Genre" > <table width="259" height="304" border="0"> <tr> <td width="216" height="27"><div align="center" class="Style1">Les Genres de Film </div></td> <td width="33"><div align="center"><img src="Images/Videotheque_Calque_Ferme.gif" width="20" height="20" id="Image11" onClick="MM_showHideLayers('Genre','','hide')" onMouseOver="MM_swapImage('Image11','','Images/Videotheque_Calque_Ferme_survol.gif','Image1','','Images/Videotheque_Calque_Ferme_survol.gif',1)" onMouseOut="MM_swapImgRestore()"></div></td> </tr> <tr> <td height="239" colspan="2"><form name="form3" method="get" action=""> <div align="center"> <select name="ChoixGenre" size="13"> <?php do { ?> <option value="<?php echo $row_VideoGenre['NumGenre']?>"><?php echo $row_VideoGenre['Genre']?></option> <?php } while ($row_VideoGenre = mysql_fetch_assoc($VideoGenre)); $rows = mysql_num_rows($VideoGenre); if($rows > 0) { mysql_data_seek($VideoGenre, 0); $row_VideoGenre = mysql_fetch_assoc($VideoGenre); } ?> </select> <br> <input type="submit" name="Submit2" value="Envoyer"> </div> </form> </td> </tr> </table> </div> <div id="Realisateur"> <table width="259" height="305" border="0"> <tr> <td width="216" height="27"><div align="center" class="Style1">Les Réalisateurs </div></td> <td width="33"><div align="center"><img src="Images/Videotheque_Calque_Ferme.gif" width="20" height="20" id="Image1" onClick="MM_showHideLayers('Realisateur','','hide')" onMouseOver="MM_swapImage('Image11','','Images/Videotheque_Calque_Ferme_survol.gif','Image1','','Images/Videotheque_Calque_Ferme_survol.gif',1)" onMouseOut="MM_swapImgRestore()"></div></td> </tr> <tr> <td height="231" colspan="2"><form name="form3" method="get" action=""> <div align="center"> <select name="ChoixRealisateur" size="13"> <?php do { ?> <option value="<?php echo $row_VideoRealisateur['NumPersonnalite']?>"><?php echo $row_VideoRealisateur['Nom'],' ',$row_VideoRealisateur['Prenom']?></option> <?php } while ($row_VideoRealisateur = mysql_fetch_assoc($VideoRealisateur)); $rows = mysql_num_rows($VideoRealisateur); if($rows > 0) { mysql_data_seek($VideoRealisateur, 0); $row_VideoRealisateur = mysql_fetch_assoc($VideoRealisateur); } ?> </select> <br> <input type="submit" name="Submit2" value="Envoyer"> </div> </form> </td> </tr> </table> </div>
<div id="Scenariste"> <table width="259" height="305" border="0"> <tr> <td width="216" height="27"><div align="center" class="Style1">Les Scénaristes </div></td> <td width="33"><div align="center"><img src="Images/Videotheque_Calque_Ferme.gif" width="20" height="20" id="Image121" onClick="MM_showHideLayers('Scenariste','','hide')" onMouseOver="MM_swapImage('Image121','','Images/Videotheque_Calque_Ferme_survol.gif',1)" onMouseOut="MM_swapImgRestore()"></div></td> </tr> <tr> <td height="231" colspan="2"><form name="form3" method="get" action=""> <div align="center"> <select name="ChoixScenariste" size="13"> <?php do { ?> <option value="<?php echo $row_VideoScenariste['NumPersonnalite']?>"><?php echo $row_VideoScenariste['Nom'],' ',$row_VideoScenariste['Prenom']?></option> <?php } while ($row_VideoScenariste = mysql_fetch_assoc($VideoScenariste)); $rows = mysql_num_rows($VideoScenariste); if($rows > 0) { mysql_data_seek($VideoScenariste, 0); $row_VideoScenariste = mysql_fetch_assoc($VideoScenariste); } ?> </select> <br> <input type="submit" name="Submit2" value="Envoyer"> </div> </form> </td> </tr> </table>
</div> <div id="Production"> <table width="259" height="305" border="0"> <td width="216" height="27"><div align="center" class="Style1">Les Productions </div></td> <td width="33"><div align="center"><img src="Images/Videotheque_Calque_Ferme.gif" width="20" height="20" id="Image12" onClick="MM_showHideLayers('Production','','hide')" onMouseOver="MM_swapImage('Image12','','Images/Videotheque_Calque_Ferme_survol.gif',1)" onMouseOut="MM_swapImgRestore()"></div></td> </tr> <form name="form3" method="get" action=""> <tr> <tr> <td height="231" colspan="2"><select name="ChoixProduction" size="13"> <?php do { ?> <option value="<?php echo $row_VideoProduction['NumProduction']?>"><?php echo $row_VideoProduction['Production'];?></option> <?php } while ($row_VideoProduction = mysql_fetch_assoc($VideoProduction)); $rows = mysql_num_rows($VideoProduction); if($rows > 0) { mysql_data_seek($VideoProduction, 0); $row_VideoProduction = mysql_fetch_assoc($VideoProduction); } $lance_url = sprintf('Videotheque.php?ChoixProduction=6&Submit=Envoyer'); ?> </select><div align="center"><input type="submit" name="Submit2" value="Envoyer"></div></td> </tr> </form> </table> </div> <div id="ListeGenre">Liste des Films d'un genre </div> <div id="ListeRealisateur">Liste des Films d'un Réalisateur </div> <div id="ListeScenariste">SListe des Films d'un Scenariste</div> <div id="ListeFilm" style=" <?php echo $choixstyle; ?>">Liste Films </div> <div id="ListeActeur">Acteur</div> <script language="JavaScript1.2">mmLoadMenus();</script>
<table border="0" cellpadding="0" cellspacing="0" width="1245"> <!--DWLayoutTable--> <!-- fwtable fwsrc="Videotheque_vide.png" fwbase="Videotheque.gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" --> <tr> <td><img src="images/spacer.gif" width="4" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="206" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="16" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="4" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="146" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="83" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="43" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="102" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="102" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="55" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="4" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="43" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="102" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="78" height="1" border="0" alt=""></td> <td width="9"><img src="images/spacer.gif" width="9" height="1" border="0" alt=""></td> <td width="22"><img src="images/spacer.gif" width="22" height="1" border="0" alt=""></td> <td width="64"><img src="images/spacer.gif" width="64" height="1" border="0" alt=""></td> <td width="14"><img src="images/spacer.gif" width="14" height="1" border="0" alt=""></td> <td width="32"><img src="images/spacer.gif" width="32" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="9" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="98" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="8" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr>
<tr> <td rowspan="4" colspan="2"><script type="text/javascript"> AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','210','height','50','src','flash/Médiatheque','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','flash/Médiatheque' ); //end AC code </script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="210" height="50"> <param name="movie" value="flash/Médiatheque.swf"> <param name="quality" value="high"> <embed src="flash/Médiatheque.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="210" height="50"></embed> </object></noscript></td> <td colspan="4"><img name="Videotheque_r1_c3" src="images/Videotheque_r1_c3.gif" width="249" height="13" border="0" alt=""></td> <td rowspan="4"><!--DWLayoutEmptyCell--> </td> <td rowspan="5"><img name="Videotheque_r1_c8" src="images/Videotheque_r1_c8.gif" width="1" height="54" border="0" alt=""></td> <td rowspan="2" colspan="6"><!--DWLayoutEmptyCell--> </td> <td rowspan="4" colspan="9"><!--DWLayoutEmptyCell--> </td> <td><img src="images/spacer.gif" width="1" height="13" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="4"><img name="Videotheque_r2_c3" src="images/Videotheque_r2_c3.gif" width="249" height="28" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="13" border="0" alt=""></td> </tr> <tr> <td rowspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Videotheque_r3_c9','','Images/Videotheque_r2_c12_survol.gif',1)"><img name="Videotheque_r3_c9" src="images/Videotheque_r3_c9.gif" width="102" height="25" border="0" alt=""></a></td> <td rowspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore();MM_startTimeout()" onMouseOver="MM_showMenu(window.mm_menu_0927233930_0,0,21,null,'Videotheque_r3_c10');MM_swapImage('Videotheque_r3_c10','','Images/Videotheque_r2_c17_Survol.gif',1);"><img name="Videotheque_r3_c10" src="images/Videotheque_r3_c10.gif" width="102" height="25" border="0" alt=""></a></td> <td rowspan="2" colspan="3"><a href="javascript:;" onMouseOut="MM_swapImgRestore();MM_startTimeout()" onMouseOver="MM_showMenu(window.mm_menu_0927234250_1,0,21,null,'Videotheque_r3_c11');MM_swapImage('Videotheque_r3_c11','','Images/Videotheque_r2_c18_Survol.gif',1);"><img name="Videotheque_r3_c11" src="images/Videotheque_r3_c11.gif" width="102" height="25" border="0" alt=""></a></td> <td rowspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore();MM_startTimeout()" onMouseOver="MM_showMenu(window.mm_menu_0927234354_2,0,21,null,'Videotheque_r3_c14');MM_swapImage('Videotheque_r3_c14','','Images/Videotheque_r2_c20_Survol.gif',1);"><img name="Videotheque_r3_c14" src="images/Videotheque_r3_c14.gif" width="102" height="25" border="0" alt=""></a></td> <td><img src="images/spacer.gif" width="1" height="15" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="4"><img name="Videotheque_r4_c3" src="images/Videotheque_r4_c3.gif" width="249" height="13" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="10" border="0" alt=""></td> </tr> <tr> <td colspan="2"><img name="Videotheque_r5_c1" src="images/Videotheque_r5_c1.gif" width="210" height="3" border="0" alt=""></td> <td><img name="Videotheque_r5_c7" src="images/Videotheque_r5_c7.gif" width="43" height="3" border="0" alt=""></td> <td colspan="9"><img name="Videotheque_r5_c9" src="images/Videotheque_r5_c9.gif" width="517" height="3" border="0" alt=""></td> <td rowspan="3" colspan="6"><img name="Videotheque_r5_c18" src="images/Videotheque_r5_c18.gif" width="225" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td colspan="17"><img name="Videotheque_r6_c1" src="images/Videotheque_r6_c1.gif" width="1020" height="5" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="5" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="11"><img name="Videotheque_r7_c1" src="images/Videotheque_r7_c1.gif" width="762" height="7" border="0" alt=""></td> <td rowspan="2"><img name="Videotheque_r7_c12" src="images/Videotheque_r7_c12.gif" width="4" height="7" border="0" alt=""></td> <td rowspan="5" colspan="3"><!--DWLayoutEmptyCell--> </td> <td height="6"></td> <td></td> <td><img src="images/spacer.gif" width="1" height="6" border="0" alt=""></td> </tr> <tr> <td rowspan="2"><img name="Videotheque_r8_c16" src="images/Videotheque_r8_c16.gif" width="9" height="14" border="0" alt=""></td> <td rowspan="2" colspan="6"><img name="Videotheque_r8_c17" src="images/Videotheque_r8_c17.gif" width="239" height="14" border="0" alt=""></td> <td rowspan="2"><img name="Videotheque_r8_c23" src="images/Videotheque_r8_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td rowspan="47"><img name="Videotheque_r9_c1" src="images/Videotheque_r9_c1.gif" width="4" height="776" border="0" alt=""></td> <td rowspan="4" colspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Videotheque_r9_c2','','Images/Videotheque_r5_c1_Survol.gif',1);"><img src="images/Videotheque_r9_c2.gif" alt="" name="Videotheque_r9_c2" width="222" height="34" border="0" onClick="MM_showHideLayers('Genre','','show','Realisateur','','hide','Scenariste','','hide','Production','','hide')"></a></td> <td rowspan="51"><img name="Videotheque_r9_c4" src="images/Videotheque_r9_c4.gif" width="4" height="816" border="0" alt=""></td> <td rowspan="2"><div align="center"><span class="Style1">Recherche</span></div></td> <td rowspan="2" colspan="6"><form name="form1" method="post" action=""> <input name="textfield" type="text" size="45"> <input type="submit" name="Submit" value="Envoyer"> </form> </td> <td rowspan="2"><img name="Videotheque_r9_c12" src="images/Videotheque_r9_c12.gif" width="4" height="30" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="13" border="0" alt=""></td> </tr> <tr> <td colspan="4" rowspan="2" align="right" valign="middle" class="Style12"><?php echo $totalRows_ListeFilm?></td> <td height="17"></td> <td rowspan="2" colspan="3"><span class="Style2">Films</span></td> <td><img src="images/spacer.gif" width="1" height="17" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="7"><img name="Videotheque_r11_c5" src="images/Videotheque_r11_c5.gif" width="532" height="4" border="0" alt=""></td> <td rowspan="2"><img name="Videotheque_r11_c12" src="images/Videotheque_r11_c12.gif" width="4" height="4" border="0" alt=""></td> <td height="3"></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td rowspan="49" colspan="3"><!--DWLayoutEmptyCell--> </td> <td colspan="4" rowspan="2" align="right" valign="middle" class="Style12"><span class="Style12"><?php echo $totalRows_ListeComedien?></span></td> <td height="1"></td> <td colspan="3" rowspan="2" class="Style2">Acteurs</td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Videotheque_r13_c2','','Images/Videotheque_r9_c1_Survol.gif',1);"><img src="images/Videotheque_r13_c2.gif" alt="" name="Videotheque_r13_c2" width="222" height="35" border="0" onClick="MM_showHideLayers('Genre','','hide','Realisateur','','hide','Scenariste','','show','Production','','hide')"></a></td> <td rowspan="48" colspan="8"><span class="Style14"><?php echo $choix;?></span></td> <td height="19"> </td> <td><img src="images/spacer.gif" width="1" height="19" border="0" alt=""></td> </tr> <tr> <td colspan="4" rowspan="2" align="right" valign="middle" class="Style12"><?php echo $totalRows_ListeRealisateur?></td> <td height="16"></td> <td colspan="3" rowspan="2" class="Style2">Réalisateurs</td> <td><img src="images/spacer.gif" width="1" height="16" border="0" alt=""></td> </tr> <tr> <td rowspan="3" colspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Videotheque_r15_c2','','Images/Videotheque_r10_c1_Survol.gif',1);"><img src="images/Videotheque_r15_c2.gif" alt="" name="Videotheque_r15_c2" width="222" height="34" border="0" onClick="MM_showHideLayers('Genre','','hide','Realisateur','','show','Scenariste','','hide','Production','','hide')"></a></td> <td height="4"></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td height="20" colspan="4" align="right" valign="middle" class="Style12"><?php echo $totalRows_ListeScenariste?></td> <td> </td> <td colspan="3" class="Style2">Scénarites</td> <td><img src="images/spacer.gif" width="1" height="20" border="0" alt=""></td> </tr> <tr> <td colspan="4" rowspan="2" align="right" valign="middle" class="Style12"><?php echo $totalRows_ListeProducteur?></td> <td height="10"></td> <td colspan="3" rowspan="2" class="Style2">Productions</td> <td><img src="images/spacer.gif" width="1" height="10" border="0" alt=""></td> </tr> <tr> <td rowspan="5" colspan="2"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Videotheque_r18_c2','','Images/Videotheque_r13_c1_Survol.gif',1);"><img src="images/Videotheque_r18_c2.gif" alt="" name="Videotheque_r18_c2" width="222" height="34" border="0" onClick="MM_showHideLayers('Genre','','hide','Realisateur','','hide','Scenariste','','hide','Production','','show')"></a></td> <td height="10"></td> <td><img src="images/spacer.gif" width="1" height="10" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r19_c16" src="images/Videotheque_r19_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r20_c16" src="images/Videotheque_r20_c16.gif" width="9" height="14" border="0" alt=""></td> <td colspan="6"><img name="Videotheque_r20_c17" src="images/Videotheque_r20_c17.gif" width="239" height="14" border="0" alt=""></td> <td><img name="Videotheque_r20_c23" src="images/Videotheque_r20_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="14" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r21_c16" src="images/Videotheque_r21_c16.gif" width="256" height="2" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="2" border="0" alt=""></td> </tr> <tr> <td rowspan="4"><img name="Videotheque_r22_c16" src="images/Videotheque_r22_c16.gif" width="9" height="14" border="0" alt=""></td> <td rowspan="4" colspan="6"><img name="Videotheque_r22_c17" src="images/Videotheque_r22_c17.gif" width="239" height="14" border="0" alt=""></td> <td rowspan="4"><img name="Videotheque_r22_c23" src="images/Videotheque_r22_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td colspan="2"><img name="Videotheque_r23_c2" src="images/Videotheque_r23_c2.gif" width="222" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td colspan="2" rowspan="16" valign="top"><form name="form1" method="get" action=""> <div align="center"> <p> <select name="ChoixFilm" size="20" class="ListeFilm"> <?php do { ?> <option value="<?php echo $row_ListeFilm['NumFilm']?>"><?php echo $row_ListeFilm['Titre']?></option> <?php } while ($row_ListeFilm = mysql_fetch_assoc($ListeFilm)); $rows = mysql_num_rows($ListeFilm); if($rows > 0) { mysql_data_seek($ListeFilm, 0); $row_ListeFilm = mysql_fetch_assoc($ListeFilm); } ?> </select> </p> <p> <input type="submit" name="Submit" value="Envoyer"> </p> </div> </form></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td><img src="images/spacer.gif" width="1" height="5" border="0" alt=""></td> </tr> <tr> <td colspan="6" class="Style2">Année Moyenne </td> <td colspan="2" align="center" valign="middle" class="Style12"><?php echo $Annee_Stats;?></td> <td><img src="images/spacer.gif" width="1" height="22" border="0" alt=""></td> </tr> <tr> <td colspan="6" class="Style2">Durée Moyenne </td> <td colspan="2" align="center" valign="middle" class="Style12"><?php echo $Heure_Moyenne," hrs ",$Minutes_Moyenne," mn";?></td> <td><img src="images/spacer.gif" width="1" height="21" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r28_c16" src="images/Videotheque_r28_c16.gif" width="256" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r29_c16" src="images/Videotheque_r29_c16.gif" width="9" height="14" border="0" alt=""></td> <td colspan="6"><img name="Videotheque_r29_c17" src="images/Videotheque_r29_c17.gif" width="239" height="14" border="0" alt=""></td> <td><img name="Videotheque_r29_c23" src="images/Videotheque_r29_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="14" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r30_c16" src="images/Videotheque_r30_c16.gif" width="256" height="2" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="2" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r31_c16" src="images/Videotheque_r31_c16.gif" width="9" height="23" border="0" alt=""></td> <td colspan="6" bgcolor="#FFFFFF"><div align="center"><span class="Style3"><span class="Style8">Le Film du Moment</span></span> </div></td> <td><img name="Videotheque_r31_c23" src="images/Videotheque_r31_c23.gif" width="8" height="23" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="23" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r32_c16" src="images/Videotheque_r32_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td colspan="3"><?php $envoi_url = sprintf ("Videotheque.php?ChoixFilm=%s",$row_FilmAleatoire['NumFilm']); ?> <form id="form7" name="form7" method="get" action=""> <input name="ChoixAlbum2" type="image" src="<?php echo affichage($row_FilmAleatoire['Jaquette']); ?>" width="95" height="109" onClick="MM_goToURL('parent','<?php echo $envoi_url; ?>');return document.MM_returnValue"/> </form></td> <td rowspan="2"><img name="Videotheque_r33_c19" src="images/Videotheque_r33_c19.gif" width="14" height="113" border="0" alt=""></td> <td colspan="3" align="center"><span class="Style13"> <?php $DureeAleatoire = 60*$row_FilmAleatoire['Heures'] + $row_FilmAleatoire['Minutes']; echo $row_FilmAleatoire['Titre']; ?> <br> <?php echo $row_FilmAleatoire['Annee'],' / ',$DureeAleatoire,' mn'; ?><br> <?php echo $row_FilmAleatoire['Genre']; ?></span><br> <br> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_FilmAleatoire['NumNationalite1']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php if ($row_FilmAleatoire['NumNationalite2']!=1) { mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_FilmAleatoire['NumNationalite2']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php } ?> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixFormatAleatoire = sprintf("SELECT * FROM format WHERE NumFormat=%s ",$row_FilmAleatoire['NumFormat']); $ChoixFormatAleatoire = mysql_query($query_ChoixFormatAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixFormatAleatoire= mysql_fetch_assoc($ChoixFormatAleatoire); $totalRows_ChoixFormatAleatoire = mysql_num_rows($ChoixFormatAleatoire); $flag = $row_ChoixFormatAleatoire['Format'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"></span></td> <td rowspan="2"><img name="Videotheque_r33_c23" src="images/Videotheque_r33_c23.gif" width="8" height="113" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="110" border="0" alt=""></td> </tr> <tr> <td colspan="3"><img name="Videotheque_r34_c16" src="images/Videotheque_r34_c16.gif" width="95" height="3" border="0" alt=""></td> <td colspan="3"><img name="Videotheque_r34_c20" src="images/Videotheque_r34_c20.gif" width="139" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r35_c16" src="images/Videotheque_r35_c16.gif" width="9" height="14" border="0" alt=""></td> <td colspan="6"><img name="Videotheque_r35_c17" src="images/Videotheque_r35_c17.gif" width="239" height="14" border="0" alt=""></td> <td><img name="Videotheque_r35_c23" src="images/Videotheque_r35_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="14" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r36_c16" src="images/Videotheque_r36_c16.gif" width="256" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r37_c16" src="images/Videotheque_r37_c16.gif" width="9" height="23" border="0" alt=""></td> <td colspan="6" bgcolor="#FFFFFF"><div align="center" class="Style11">L'Acteur / Actrice du Moment </div></td> <td><img name="Videotheque_r37_c23" src="images/Videotheque_r37_c23.gif" width="8" height="23" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="23" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r38_c16" src="images/Videotheque_r38_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td rowspan="3" colspan="3"><?php $envoi_url = sprintf ("Videotheque.php?ChoixPersonnalite=%s",$row_ActeurAleatoire['NumPersonnalite']); ?> <form id="form7" name="form7" method="get" action=""> <input name="ChoixAlbum" type="image" src="<?php echo affichagephoto($row_ActeurAleatoire['Photo']); ?>" width="95" height="95" onClick="MM_goToURL('parent','<?php echo $envoi_url; ?>');return document.MM_returnValue"/> </form></td> <td rowspan="5"><img name="Videotheque_r39_c19" src="images/Videotheque_r39_c19.gif" width="14" height="98" border="0" alt=""></td> <td colspan="3" rowspan="4" align="center" class="Style13"> <?php echo $row_ActeurAleatoire['Prenom']; ?> <br> <?php echo $row_ActeurAleatoire['Nom']; ?> <br> <?php if ($row_ActeurAleatoire['LieuNaissance'] != NULL) { echo 'Né(e) à ',$row_ActeurAleatoire['LieuNaissance']; } ?> <br> <?php if ($row_ActeurAleatoire['Annee'] != NULL) { if ($row_ActeurAleatoire['MortEn'] != 0) { $Age = $row_ActeurAleatoire['MortEn']-$row_ActeurAleatoire['Annee']; echo "Mort à ",$Age," ans";} else { $aujourdhui = getdate(); $Age = $aujourdhui['year'] - $row_ActeurAleatoire['Annee']; echo $Age," Ans";} } ?> <strong><br> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_ActeurAleatoire['NumNationalite']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> </strong></span></td> <td rowspan="5"><img name="Videotheque_r39_c23" src="images/Videotheque_r39_c23.gif" width="8" height="98" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="61" border="0" alt=""></td> </tr> <tr> <td colspan="2"><img name="Videotheque_r40_c2" src="images/Videotheque_r40_c2.gif" width="222" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td colspan="2" rowspan="14" valign="top"><form name="ChoixPersonnalite" method="get" action=""> <div align="center"> <p> <select name="ChoixPersonnalite" size="20" class="ListePersonne"> <?php do { ?> <option value="<?php echo $row_ListePersonnalite['NumPersonnalite']?>"><?php echo $row_ListePersonnalite['Prenom']," ",$row_ListePersonnalite['Nom']?></option> <?php } while ($row_ListePersonnalite = mysql_fetch_assoc($ListePersonnalite)); $rows = mysql_num_rows($ListePersonnalite); if($rows > 0) { mysql_data_seek($ListePersonnalite, 0); $row_ListePersonnalite = mysql_fetch_assoc($ListePersonnalite); } ?> </select> </p> <p> <input type="submit" name="Submit2" value="Envoyer"> </p> </div> </form></td> <td><img src="images/spacer.gif" width="1" height="30" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="3"><img name="Videotheque_r42_c16" src="images/Videotheque_r42_c16.gif" width="95" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="2" border="0" alt=""></td> </tr> <tr> <td colspan="3"><img name="Videotheque_r43_c20" src="images/Videotheque_r43_c20.gif" width="139" height="1" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r44_c16" src="images/Videotheque_r44_c16.gif" width="9" height="14" border="0" alt=""></td> <td colspan="6"><img name="Videotheque_r44_c17" src="images/Videotheque_r44_c17.gif" width="239" height="14" border="0" alt=""></td> <td><img name="Videotheque_r44_c23" src="images/Videotheque_r44_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="14" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r45_c16" src="images/Videotheque_r45_c16.gif" width="256" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r46_c16" src="images/Videotheque_r46_c16.gif" width="9" height="23" border="0" alt=""></td> <td colspan="6" bgcolor="#FFFFFF" class="Style11"><div align="center">Le Film le Plus Long </div></td> <td><img name="Videotheque_r46_c23" src="images/Videotheque_r46_c23.gif" width="8" height="23" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="23" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r47_c16" src="images/Videotheque_r47_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td colspan="3"><?php $envoi_url = sprintf ("Videotheque.php?ChoixFilm=%s",$row_SelectFilmLong['NumFilm']); ?> <form id="form7" name="form7" method="get" action=""> <input name="ChoixAlbum" type="image" src="<?php echo affichage($row_SelectFilmLong['Jaquette']); ?>" width="95" height="109" onclick="MM_goToURL('parent','<?php echo $envoi_url; ?>');return document.MM_returnValue"/> </form></td> <td rowspan="2"><img name="Videotheque_r48_c19" src="images/Videotheque_r48_c19.gif" width="14" height="113" border="0" alt=""></td> <td colspan="3" align="center"><span class="Style13"> <?php $DureeSelectFilmLong = 60*$row_SelectFilmLong['Heures'] + $row_SelectFilmLong['Minutes']; echo $row_SelectFilmLong['Titre']; ?> <br> <?php echo $row_SelectFilmLong['Annee'],' / ',$DureeSelectFilmLong,' mn'; ?><br> <?php echo $row_SelectFilmLong['Genre']; ?><br> <br> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_SelectFilmLong['NumNationalite1']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php if ($row_FilmAleatoire['NumNationalite2']!=1) { mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_SelectFilmLong['NumNationalite2']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php } ?> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixFormatAleatoire = sprintf("SELECT * FROM format WHERE NumFormat=%s ",$row_SelectFilmLong['NumFormat']); $ChoixFormatAleatoire = mysql_query($query_ChoixFormatAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixFormatAleatoire= mysql_fetch_assoc($ChoixFormatAleatoire); $totalRows_ChoixFormatAleatoire = mysql_num_rows($ChoixFormatAleatoire); $flag = $row_ChoixFormatAleatoire['Format'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"></span></td> <td rowspan="2"><img name="Videotheque_r48_c23" src="images/Videotheque_r48_c23.gif" width="8" height="113" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="110" border="0" alt=""></td> </tr> <tr> <td colspan="3"><img name="Videotheque_r49_c16" src="images/Videotheque_r49_c16.gif" width="95" height="3" border="0" alt=""></td> <td colspan="3"><img name="Videotheque_r49_c20" src="images/Videotheque_r49_c20.gif" width="139" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="3" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r50_c16" src="images/Videotheque_r50_c16.gif" width="9" height="14" border="0" alt=""></td> <td colspan="6"><img name="Videotheque_r50_c17" src="images/Videotheque_r50_c17.gif" width="239" height="14" border="0" alt=""></td> <td><img name="Videotheque_r50_c23" src="images/Videotheque_r50_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="14" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r51_c16" src="images/Videotheque_r51_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r52_c16" src="images/Videotheque_r52_c16.gif" width="9" height="23" border="0" alt=""></td> <td colspan="6" bgcolor="#FFFFFF" class="Style11"><div align="center">Le Film le Plus Vieux </div></td> <td><img name="Videotheque_r52_c23" src="images/Videotheque_r52_c23.gif" width="8" height="23" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="23" border="0" alt=""></td> </tr> <tr> <td colspan="8"><img name="Videotheque_r53_c16" src="images/Videotheque_r53_c16.gif" width="256" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td rowspan="3" colspan="3"><?php $envoi_url = sprintf ("Videotheque.php?ChoixFilm=%s",$row_SelectFilmVieux['NumFilm']); ?> <form id="form7" name="form7" method="get" action=""> <input name="ChoixAlbum" type="image" src="<?php echo affichage($row_SelectFilmVieux['Jaquette']); ?>" width="95" height="109" onclick="MM_goToURL('parent','<?php echo $envoi_url; ?>');return document.MM_returnValue"/> </form></td> <td rowspan="5"><img name="Videotheque_r54_c19" src="images/Videotheque_r54_c19.gif" width="14" height="113" border="0" alt=""></td> <td colspan="3" rowspan="4" align="center" class="Style13"> <?php $DureeSelectFilmVieux = 60*$row_SelectFilmVieux['Heures'] + $row_SelectFilmVieux['Minutes']; echo $row_SelectFilmVieux['Titre']; ?> <br> <?php echo $row_SelectFilmVieux['Annee'],' / ',$DureeSelectFilmVieux,' mn'; ?><br> <?php echo $row_SelectFilmVieux['Genre']; ?><br> <br> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_SelectFilmVieux['NumNationalite1']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php if ($row_FilmAleatoire['NumNationalite2']!=1) { mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixNationAleatoire = sprintf("SELECT * FROM nationalite WHERE NumNationalite=%s ",$row_SelectFilmVieux['NumNationalite2']); $ChoixNationAleatoire = mysql_query($query_ChoixNationAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixNationAleatoire = mysql_fetch_assoc($ChoixNationAleatoire); $totalRows_ChoixNationAleatoire = mysql_num_rows($ChoixNationAleatoire); $flag = $row_ChoixNationAleatoire['Pays'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"> <?php } ?> <?php mysql_select_db($database_Videotheque, $Videotheque); $query_ChoixFormatAleatoire = sprintf("SELECT * FROM format WHERE NumFormat=%s ",$row_SelectFilmVieux['NumFormat']); $ChoixFormatAleatoire = mysql_query($query_ChoixFormatAleatoire, $Videotheque) or die(mysql_error()); $row_ChoixFormatAleatoire= mysql_fetch_assoc($ChoixFormatAleatoire); $totalRows_ChoixFormatAleatoire = mysql_num_rows($ChoixFormatAleatoire); $flag = $row_ChoixFormatAleatoire['Format'].'.jpg';?> <img src="<?php echo Affichageflags($flag)?>" width="30" height="21"></td> <td rowspan="5"><img name="Videotheque_r54_c23" src="images/Videotheque_r54_c23.gif" width="8" height="113" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="81" border="0" alt=""></td> </tr> <tr> <td colspan="2"><img name="Videotheque_r55_c2" src="images/Videotheque_r55_c2.gif" width="222" height="4" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="4" border="0" alt=""></td> </tr> <tr> <td rowspan="5" colspan="3"><img name="Videotheque_r56_c1" src="images/Videotheque_r56_c1.gif" width="226" height="42" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="25" border="0" alt=""></td> </tr> <tr> <td rowspan="2" colspan="3"><img name="Videotheque_r57_c16" src="images/Videotheque_r57_c16.gif" width="95" height="3" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr> <td colspan="3"><img name="Videotheque_r58_c20" src="images/Videotheque_r58_c20.gif" width="139" height="2" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="2" border="0" alt=""></td> </tr> <tr> <td rowspan="2"><img name="Videotheque_r59_c16" src="images/Videotheque_r59_c16.gif" width="9" height="14" border="0" alt=""></td> <td rowspan="2" colspan="6"><img name="Videotheque_r59_c17" src="images/Videotheque_r59_c17.gif" width="239" height="14" border="0" alt=""></td> <td rowspan="2"><img name="Videotheque_r59_c23" src="images/Videotheque_r59_c23.gif" width="8" height="14" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="12" border="0" alt=""></td> </tr> <tr> <td><img name="Videotheque_r60_c4" src="images/Videotheque_r60_c4.gif" width="4" height="2" border="0" alt=""></td> <td><img src="images/spacer.gif" width="1" height="2" border="0" alt=""></td> </tr> </table> </body> </html> <?php mysql_free_result($VideoGenre);
mysql_free_result($VideoRealisateur);
mysql_free_result($VideoScenariste);
mysql_free_result($VideoProduction); ?>
|