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> |
