<?php require_once('Connections/DisneyHebdo.php'); ?>
<?php require_once('Connections/DisneyHebdo.php'); ?>
<?php
mysql_select_db($database_DisneyHebdo, $DisneyHebdo);
$query_edito = "SELECT edito FROM edito WHERE `date` = '1'";
$edito = mysql_query($query_edito, $DisneyHebdo) or die(mysql_error());
$row_edito = mysql_fetch_assoc($edito);
$totalRows_edito = mysql_num_rows($edito);
mysql_select_db($database_DisneyHebdo, $DisneyHebdo);
$query_titre = "SELECT titre FROM auteur WHERE code = '1'";
$titre = mysql_query($query_titre, $DisneyHebdo) or die(mysql_error());
$row_titre = mysql_fetch_assoc($titre);
$totalRows_titre = mysql_num_rows($titre);
mysql_select_db($database_DisneyHebdo, $DisneyHebdo);
$query_titre2 = "SELECT titre FROM auteur WHERE code = '2'";
$titre2 = mysql_query($query_titre2, $DisneyHebdo) or die(mysql_error());
$row_titre2 = mysql_fetch_assoc($titre2);
$totalRows_titre2 = mysql_num_rows($titre2);
mysql_select_db($database_DisneyHebdo, $DisneyHebdo);
$query_titre3 = "SELECT titre FROM auteur WHERE code = '3'";
$titre3 = mysql_query($query_titre3, $DisneyHebdo) or die(mysql_error());
$row_titre3 = mysql_fetch_assoc($titre3);
$totalRows_titre3 = mysql_num_rows($titre3);
mysql_select_db($database_DisneyHebdo, $DisneyHebdo);
$query_menutitres = "SELECT titre FROM auteur WHERE code = '0'";
$menutitres = mysql_query($query_menutitres, $DisneyHebdo) or die(mysql_error());
$row_menutitres = mysql_fetch_assoc($menutitres);
$totalRows_menutitres = mysql_num_rows($menutitres);
?>
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>Disney Hebdo</title>
<!-- TemplateEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
</head>
<body bgcolor="#2E3AAB">
<table width="100%" height="89%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%"><img src="angle_haut_gauche.gif" width="40" height="40" align="bottom" />
</td>
<td width="16%" height="9%"><img src="haut.gif" width="100%" height="40" />
<div align="center"></div>
<div align="center"></div></td>
<td height="40"><img src="haut.gif" width="100%" height="40" /></td>
<td height="40"><img src="haut.gif" width="100%" height="40" /></td>
<td height="40"><img src="haut.gif" width="100%" height="40" /></td>
<td width="40"><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td width="4%" height="9%"><img src="gauche.gif" width="40" height="100%" /></td>
<td colspan="4"><div align="center"><img src="images/logo.gif" width="247" height="33" /></div></td>
<td width="40"><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="4%" height="15%"><img src="gauche.gif" width="40" height="100%" /></td>
<td colspan="4"><hr />
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><strong><font color="#FFFFFF" size="4">A la
Une</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Parcs</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Animation</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Ciné</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Télévision</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Société
Mère</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Divers</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="4">Sur le
Web</font></strong></div></td>
</tr>
</table>
<hr /></td>
<td width="40"><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="4%" height="28%"><img src="gauche.gif" width="40" height="100%" /></td>
<td valign="top" rowspan="2"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td><img src="angle_haut_gauche.gif" width="40" height="40" /></td>
<td><img src="haut.gif" width="100%" height="40" /></td>
<td><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td><img src="gauche.gif" width="40" height="100%" /></td>
<td rowspan="2"><div align="center"><strong><font color="#FFFFFF" size="4">Edito
</font></strong> </div>
<hr /> <div align="center"><font color="#FFFFFF"><?php echo $row_edito['edito']; ?></font></div></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="40"><img src="gauche.gif" width="40" height="100%" /></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table></td>
<td valign="top" colspan="2"><table width="90%" border="0" align="center" valign="top" cellpadding="0" cellspacing="0">
<tr>
<td width="5%"><img src="angle_haut_gauche.gif" width="40" height="40" /></td>
<td width="90%"><img src="haut.gif" width="100%" height="40" /></td>
<td width="5%"><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td><img src="gauche.gif" width="40" height="100%" /></td>
<td><div align="center"><strong><font color="#FFFFFF" size="6"><?php echo $row_titre['titre']; ?></font></strong></div></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table></td>
<td valign="top" rowspan="2"> <table width="100%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><img src="angle_haut_gauche.gif" width="40" height="40" /></td>
<td><img src="haut.gif" width="100%" height="40" /></td>
<td><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td><img src="gauche.gif" width="40" height="100%" /></td>
<td rowspan="2"><div align="center"><strong><font color="#FFFFFF" size="4">A
voir également </font></strong></div>
<hr /> <div align="center"><font color="#FFFFFF">
<?php
// on se connecte à MySQL
$db = mysql_connect('localhost', 'root', '');
// on sélectionne la base
mysql_select_db('disneyhebdo',$db);
// on crée la requête SQL
$sql = 'SELECT titre FROM auteur WHERE code = 0';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
echo '<b>'.$data['titre'].'<br><br></b>';
}
// on ferme la connexion à mysql
mysql_close();
?>
</font></div></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="40"><img src="gauche.gif" width="40" height="100%" /></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td height="40"><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table></td>
<td width="40"><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="4%" height="28%"><img src="gauche.gif" width="40" height="100%" /></td>
<td valign="top" width="27%"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="5%"><img src="angle_haut_gauche.gif" width="40" height="40" /></td>
<td width="90%"><img src="haut.gif" width="100%" height="40" /></td>
<td width="5%"><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td><img src="gauche.gif" width="40" height="100%" /></td>
<td><div align="center"><strong><font color="#FFFFFF" size="6"><?php echo $row_titre2['titre']; ?></font></strong></div></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table></td>
<td valign="top" width="27%"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="5%"><img src="angle_haut_gauche.gif" width="40" height="40" /></td>
<td width="90%"><img src="haut.gif" width="100%" height="40" /></td>
<td width="5%"><img src="angle_haut_droite.gif" width="40" height="40" /></td>
</tr>
<tr>
<td><img src="gauche.gif" width="40" height="100%" /></td>
<td><div align="center"><strong><font color="#FFFFFF" size="6"></font></strong></div>
<div align="center"><strong><font color="#FFFFFF" size="6"><?php echo $row_titre3['titre']; ?></font></strong></div></td>
<td><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table></td>
<td width="40"><img src="droite.gif" width="40" height="100%" /></td>
</tr>
<tr>
<td width="4%" height="11%"><img src="angle_bas_gauche.gif" width="40" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="bas.gif" width="100%" height="40" /></td>
<td><img src="angle_bas_droite.gif" width="40" height="40" /></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($edito);
mysql_free_result($titre);
mysql_free_result($titre2);
mysql_free_result($titre3);
mysql_free_result($menutitres);
?>