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
|
echo '<form action="tapage.php" method="post">';
echo '<select name="Id_classe" size="1">';
$requete="select * from Classe order by Libelle_classe";
$exe=mysql_query($requete);
if($exe){
while($classes=mysql_fetch_assoc($exe)){
echo '<option value="'.$classes[Id_classe].'">'.$classes[Libelle_classe].'</option>';
}
}
echo '</select>';
echo '<input type="submit" value="Go">';
echo '</form>';
echo '<br /><br />';
//si on a choisi une classe, alors on affiche le tableau des élèves de cette classe
if(isset($_POST['Id_classe'])){
$requete="select * from Eleve where Id_class='".$_POST['Id_classe']."' order by Nom_eleve asc";
$ress=mysql_query($requete);
if($ress){
echo '<table width="100%">';
echo '<tr><td>Nom</td><td>Prénom</td></tr>';
while($eleves=mysql_fetch_assoc($ress)){
echo '<tr><td>'.$eleves[Nom_eleve].'</td><td>'.$eleves[Preom_eleve].'</td></tr>';
}
echo '</table>';
}
} |
Partager