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 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
<form name="etat_absences" action="memo_etat_absences.php" method="POST">
<p id="recherche_groupe">
<select name="action" >
<?php
require ("Connect.php");
$connexion = mysql_pconnect (SERVEUR, NOM, PASSE);
mysql_select_db (BASE,$connexion);
$sql = 'SELECT action from action ORDER BY action ASC ';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
while($data = mysql_fetch_array($req))
{
echo '<option value="'.$data['action'].'" " selected ">'.$data['action'].'</option><br>\n';
}
mysql_free_result ($req);
?>
</select>
<input type="submit" name="afficher_la_liste" value="afficher la liste" >
</p>
<table cellspacing="0" cellpadding="0"id="table_liste_groupe">
<?php
if (isset($_POST['afficher_la_liste']))
{
require ("Connect.php");
$connexion = mysql_pconnect (SERVEUR, NOM, PASSE);
mysql_select_db (BASE,$connexion);
$resultat = mysql_query ($requete, $connexion);
$sql = mysql_query("SELECT id,nom, prenom FROM profil WHERE action='$_POST[action]'");
echo '<tr>
<td colspan="2" id="languette_haut">
</td>
</tr>';
while($result=mysql_fetch_array($sql))
{
echo '
<tr>
<td id="nom_prenom">
<a href="memo_etat_absences.php?id='.$result['id'].'">'.$result['nom'].'</a>
</td>
<td id="nom_prenom">
'.$result['prenom'].'
</td>
</tr>';
}
echo '<tr>
<td colspan="2" id="languette_bas">
</td>
</tr>';
}
?>
</table>
<fieldset id="fieldset_absences">
<legend>
ETAT DES ABSENCES
</legend>
<table cellspacing="0" cellpadding="1" align="center" id="">
<?php
if (isset($_GET['id'])) {
require ("Connect.php");
$connexion=mysql_pconnect (SERVEUR, NOM, PASSE);
mysql_select_db (BASE,$connexion);
$requete='SELECT * FROM afi_situation WHERE id='.$_GET[id];
while($result=mysql_fetch_array($requete))
{
echo '
<tr>
<td id="date_debut_abs">
'.$result['date_debut_abs'].'
</td>
<td id="date_fin_abs">
'.$result['date_fin_abs'].'
</td>
<td id="motif_absence">
'.$result['motif_absence'].'
</td>
<td id="note_absence">
'.$result['note_absence'].'
</td>
</tr>';
}
}
?>
</table>
</form> |
Partager