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
| header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="01simple.xls"');
header('Cache-Control: max-age=0');
//connexion à la base de données
include('../../access2.php');
//Lancement de la requete
$req = "SELECT * FROM cdc,sous_projet_ic WHERE cdc.cod_cdc=sous_projet_ic.cod_cdc AND sp_soumis='Oui' ORDER BY annee_soumis DESC, mois_soumis DESC, jour_soumis DESC ";
$resultat = mysql_query($req) or die('Erreur SQL !'.$req.''.mysql_error());
echo'<div align="center">
<table border="2" cellspacing="2" cellpadding="5" bordercolor="#999999">
<tr><td align="center" colspan="6" bgcolor="#FFCC99">LISTE DES SOUS PROJETS SOUMIS INFRASTRUCTURE COMMUNAUTAIRE</td></tr>
<tr>
<td width="200" align="center" bgcolor="#DDD"><strong>LOCALISATION</strong></td>
<td width="180" bgcolor="#DDD"><strong>CODE DU CDC</strong></td>
<td width="154" bgcolor="#DDD"><strong>NOM DU CDC</strong></td>
<td width="200" align="center" bgcolor="#DDD"><strong>CODE DU
SOUS PROJET</strong></td>
<td width="320" align="center" bgcolor="#DDD"><strong>TITRE DU
SOUS PROJET</strong></td>
<td width="100" align="center" bgcolor="#DDD"><strong>DATE DE
SOUMISSION</strong></td>
<!--<td width="110" align="center" bgcolor="#DDD"><strong>OPERATION</strong></td>-->';
while($data = mysql_fetch_array($resultat))
{
echo'
<tr>
<td bgcolor="#EDEDED" align="center">';
$sel = "SELECT * FROM departement WHERE cod_dep ='".$data['cod_dep']."'";
$res = mysql_query($sel) or die('Erreur SQL !'.$sel.'
'.mysql_error());
while($dat = mysql_fetch_array($res))
{
echo strtoupper($dat['lib_dep']);
}
$sel = "SELECT * FROM sous_prefecture WHERE cod_soupref ='".$data['cod_soupref']."'";
$res = mysql_query($sel) or die('Erreur SQL !'.$sel.'
'.mysql_error());
while($dat = mysql_fetch_array($res))
{
echo ' / '.strtoupper($dat['lib_soupref']);
}
echo'</td>
<td bgcolor="#EDEDED">'.$data['cod_cdc'].'</td>
<td bgcolor="#EDEDED">';
$sel = "SELECT * FROM cdc WHERE cod_cdc ='".$data['cod_cdc']."'";
$res = mysql_query($sel) or die('Erreur SQL !'.$sel.'
'.mysql_error());
while($dat = mysql_fetch_array($res))
{
echo strtoupper(stripslashes($dat['nom_cdc']));
}
echo'</td>
<td align="center" bgcolor="#EDEDED">'.strtoupper($data['cod_sp']).'</td>
<td align="center" bgcolor="#EDEDED">'.strtoupper(stripslashes($data['titre_sp'])).'</td>
<td align="center" bgcolor="#EDEDED">'.strtoupper($data['date_soumis']).'</td>
</tr>';
}
echo'</table><p> </p>';
echo'</div>'; |
Partager