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
| <?php require_once('Connections/Principale.php'); ?>
<?php
mysql_select_db($database_Principale, $Principale);
$query_RequeteCalcul = "SELECT Id, Nom_Eleve, Prenom_Eleve, Nom_Maritalement, Presence, Nbre_Personne, Montant_Reglement, Reglement, Annee_Naissance_Eleve FROM liste_retrouvailles_2007 WHERE Presence = 'oui' ORDER BY liste_retrouvailles_2007.Nom_Eleve";
$RequeteCalcul = mysql_query($query_RequeteCalcul, $Principale) or die(mysql_error());
$row_RequeteCalcul = mysql_fetch_assoc($RequeteCalcul);
$totalRows_RequeteCalcul = mysql_num_rows($RequeteCalcul);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Calcul Nombre Présents</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.Style1 {
color: #FF0000;
font-weight: bold;
}
.Style2 {color: #333333}
.Style3 {color: #FF0000}
-->
</style>
</head>
<body>
<div align="center">
<p><a href="index.html"><em><strong>Accueil</strong></em></a> <a href="Maintenance.php"><em><strong>Retour à la Maintenance</strong></em></a></p>
<table border="1" cellpadding="2" cellspacing="0">
<tr>
<td>Id</td>
<td bgcolor="#DFFFDF"><div align="center"><strong>Vous êtes </strong></div></td>
<td bgcolor="#FBEEF2"><div align="center"> Prénom </div></td>
<td bgcolor="#DFFFDF"><div align="center"> Nom Maritalement </div></td>
<td bgcolor="#FFFFEA"><div align="center">Présence</div></td>
<td bgcolor="#EAFFFF"><div align="center">Nbre</div></td>
<td bgcolor="#FFEFE8"><div align="center">Montant </div></td>
<td><div align="center">Réglement</div></td>
<td><div align="center"> Année</div></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_RequeteCalcul['Id']; ?></td>
<td bgcolor="#DFFFDF"><?php echo $row_RequeteCalcul['Nom_Eleve']; ?></td>
<td><?php echo $row_RequeteCalcul['Prenom_Eleve']; ?></td>
<td><?php echo $row_RequeteCalcul['Nom_Maritalement']; ?></td>
<td><?php echo $row_RequeteCalcul['Presence']; ?></td>
<td><?php echo $row_RequeteCalcul['Nbre_Personne']; ?></td>
<td><?php echo $row_RequeteCalcul['Montant_Reglement']; ?></td>
<td><?php echo $row_RequeteCalcul['Reglement']; ?></td>
<td><?php echo $row_RequeteCalcul['Annee_Naissance_Eleve']; ?></td>
</tr>
<?php } while ($row_RequeteCalcul = mysql_fetch_assoc($RequeteCalcul)); ?>
</table>
<p align="left"> Nombre d'Elèves: <span class="Style1"><?php echo $totalRows_RequeteCalcul ?> </span><span class="Style3"><span class="Style2">Nombre Personnes: </span></span> Montant Euros: </p>
<table width="200" border="1" bgcolor="#FFFF00">
<tr>
<th scope="col"><a href="Maintenance.php"><em><strong>Retour à la Maintenance</strong></em></a></th>
</tr>
</table>
<p> </p>
</div>
</body>
</html>
<?php
mysql_free_result($RequeteCalcul);
?> |
Partager