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
| <?php require_once('../Connections/Mom.php'); ?>
<?php
mysql_select_db($database_Mom, $Mom);
$query_RecEcole = "SELECT Num_Ecole, Nom FROM ecole";
$RecEcole = mysql_query($query_RecEcole, $Mom) or die(mysql_error());
$row_RecEcole = mysql_fetch_assoc($RecEcole);
$totalRows_RecEcole = mysql_num_rows($RecEcole);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form_Ecole" method="post" action="liste_ecole.php">
<select name="ecole" id="ecole">
<?php
do {
?>
<option value="<?php echo $row_RecEcole['Num_Ecole']?>"><?php echo $row_RecEcole['Nom']?></option>
<?php
} while ($row_RecEcole = mysql_fetch_assoc($RecEcole));
$rows = mysql_num_rows($RecEcole);
if($rows > 0) {
mysql_data_seek($RecEcole, 0);
$row_RecEcole = mysql_fetch_assoc($RecEcole);
}
?>
</select>
<input name="rechercher" type="submit" value="rechercher" />
</p>
</form>
<?php
$ecole="";
if(isset($_POST['ecole'])) $ecole=$_POST['ecole'];
mysql_connect("localhost","root","");
mysql_select_db('momartre');
$reponse=mysql_query("SELECT enfant.Nom,enfant.Prenom, ecole.Nom as Nom_Ecole FROM enfant, ecole,
WHERE
Num_Ecole='".$ecole."'and
enfant.Num_Ecole =ecole.Num_Ecole");
while ($donnees=mysql_fetch_array($reponse) )
{
?>
<table width="75%" border="0" valign="top">
<tr>
<td> <?PHP echo $donnees['Prenom']; ?> </td>
<td> <?PHP echo $donnees['Nom']; ?> </td>
<td> <?PHP echo $donnees['Nom_Ecole']; ?> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($RecEcole);
}
mysql_close();
?> |
Partager