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
|
<?
$connexion = mysql_connect('xxx','xxx','');// Connexion à la base de donnée
mysql_select_db('ref',$connexion) or die('Erreur de selection '.mysql_error());
$requete = "SELECT Matricule,Nom,Prenom,Service.id_service,Libelle_Service,Num_Ars,E_Archive,D_Archive,Libelle,type_Archive.id_T_Archive,Libelle_T_Archive,C_Archive,Commentaire,Photo FROM arch,service,type_archive WHERE arch.id_t_archive = '".$_POST['Type_Archive']."'&& arch.id_service = service.id_service && arch.id_t_archive = type_archive.id_t_archive ";
$resultat = mysql_db_query('ref',$requete,$connexion) or die('Erreur de selection '.mysql_error()); // execution de la requete
mysql_close($connexion);// Fermeture de la connexion
while($rows = mysql_fetch_array($resultat))
{
$Num_Ars = $rows['Num_Ars'];
$Matricule = $rows['Matricule'];
$Prenom = $rows['Prenom'];
$Nom = $rows['Nom'];
$Libelle_Service = $rows['Libelle_Service'];
$D_Archive = $rows['D_Archive'];
$E_Archive = $rows['E_Archive'];
$Libelle_T_Archive = $rows['Libelle_T_Archive'];
$C_Archive = $rows['C_Archive'];
$Commentaire = $rows['Commentaire'];
$Libelle = $rows['Libelle'];
$blob = $rows['Photo'];
echo "<tr>\n
<td > $Num_Ars </td>\n
<td > $Matricule</td>\n
<td > $Prenom </td>\n
<td > $Nom </td>\n
<td > $Libelle_Service </td>\n
<td > $D_Archive </td>\n
<td > $E_Archive </td>\n
<td > $Libelle_T_Archive </td>\n
<td > $C_Archive </td>\n
<td > $Commentaire </td>\n
<td > $Libelle </td>\n
<td > $blob </td>\n
</tr>\n";
}
?> |
