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 88 89 90 91 92 93 94 95
|
<? session_start();?>
<html>
<head>
<title>cretion</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<div align="center">
<TBODY>
<TR vAlign=top>
<TD width=293 height=90><IMG height=90
src="logodoc.gif" width=1004 useMap=#logo
border=0><MAP name=logo><AREA shape=RECT coords=28,7,89,80
href="logodoc.gif" target="_blank"></MAP></TD>
</TR>
</TBODY>
</div>
<style type="text/css">
<!--
body {
background-color: #FFCC66;
}
-->
</style></head>
<body>
<table width="746" height="65" bordercolor="#000099" border="1" >
<tr bordercolor="#330066">
<td width="109"><div align="left"><span class="Style1">Num_Ars</span></div></td>
<td width="109"><div align="left"><span class="Style1">Matricule</span></div></td>
<td width="109"><div align="left"><span class="Style1">Prenom</span></div></td>
<td width="109"><div align="left"><span class="Style1">Nom</span></div></td>
<td width="109"><div align="left"><span class="Style1">Service</span></div></td>
<td width="109"><div align="left"><span class="Style1">Date Archivage</span></div></td>
<td width="109"><div align="left"><span class="Style1">Etiquette de l'archive</span></div></td>
<td width="109"><div align="left"><span class="Style1">Type d'archive</span></div></td>
<td width="109"><div align="left"><span class="Style1">Chemin de l'archive</span></div></td>
<td width="109"><div align="left"><span class="Style1">Commentaire</span></div></td>
<td width="109"><div align="left"><span class="Style1">Libelle de l'archve</span></div></td>
<td width="109"><div align="left"><span class="Style1">lien vers le fichier detaillé de l'archive</span></div></td>
</tr>
<?$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,Lien_fichier 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
$fp=fopen("c:/formulaire/robocopy.txt","r");
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'];
$Lien_fichier = $rows['Lien_fichier'];
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 > <a href=\"$fp\">$Lien_fichier<\a> </td>\n
</tr>\n";
}
?>
<input name="button" type="button"onClick="javascript:location.href='connexion_base.php'" value="retour au menu">
</body>
</html> |
Partager