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
| <?php
include"config.php";
$db = mysql_connect($serveur, $login, $password);
mysql_select_db($base,$db);
$sql = "SELECT nomsite,typologie,usages,fluide,compteur,unite,determinant,quantite,cout,DATE_FORMAT(dates, '%d-%m-%Y') as dates,indexx,ratio FROM site where commune='$commune' ORDER BY typologie,nomsite,fluide,compteur,dates";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$csv_output = "Nom site;Typo site;Usage;Fluide;Compteur;Unité;Déterminant;Quantité;Cout TTC;Date;Index;Ratio";
$csv_output .= "\n";
while($data = mysql_fetch_array($req))
{
$csv_output .= "$data[nomsite];$data[typologie];$data[usages];$data[fluide];$data[compteur];$data[unite];$data[determinant];$data[quantite];$data[cout];$data[dates];$data[indexx];$data[ratio];\n";
}
$csv_output .= "\n";
$csv_output .= "\n";
$csv_output .= "\n";
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename="."Commune_en_cours.csv");
print $csv_output;
$db = mysql_connect($serveur, $login, $password);
mysql_select_db($base,$db);
$sql1 = "SELECT nomsite,typologie,usages,fluide,compteur,unite,determinant,quantite,cout,DATE_FORMAT(dates, '%d-%m-%Y') as dates,indexx,ratio FROM site ORDER BY typologie,nomsite,fluide,compteur,dates";
$req1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error());
$csv_output1 = "Nom site;Typo site;Usage;Fluide;Compteur;Unité;Déterminant;Quantité;Cout TTC;Date;Index;Ratio";
$csv_output1 .= "\n";
while($data = mysql_fetch_array($req1))
{
$csv_output1 .= "$data[nomsite];$data[typologie];$data[usages];$data[fluide];$data[compteur];$data[unite];$data[determinant];$data[quantite];$data[cout];$data[dates];$data[indexx];$data[ratio];\n";
}
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename="."toute_communes.csv");
print $csv_output1;
exit;
?> |
Partager