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
|
$sql = "SELECT * FROM $table";
$result = mysql_query($sql);
$handle = tmpfile();
$fields = mysql_fetch_assoc($result);
fputcsv($handle, array_keys($fields), ';');
do
{
fputcsv($handle, $fields, ';');
}
while($fields = mysql_fetch_assoc($result));
mysql_free_result($result);
rewind($handle);
fpassthru($handle);
fclose($handle);
header("Content-Type: text/csv; charset=UTF-8");
header("Content-disposition: csv; filename=" . date("Y-m-d") ."_".$table.".csv; size=".strlen($csv));
echo $csv;
exit;
break;
case "brochure":
$dbconnection=mysql_connect("localhost", DB_USER, DB_PASSWORD);
mysql_select_db(DB_NAME,$dbconnection);
$table="users_contact";
$csv = NULL;
/* link identifier from db connection */
$r = mysql_query("select * from ".$table);
$i=0;
while ($row = mysql_fetch_assoc($r)) {
if ($i==0){
$csv .=''.('Id Contact;Nom;Prenom;Adresse;Adresse Complementaire;Code Postal;Ville;Pays;Tel;Tel Portable;Email;Niveau;ArtDesign;ImageSon;Stage decouverte;Recevoir des informations;Langage;Civilite;')."\n";
}
$i++;
$csv .= ''.utf8_decode(join(';', $row))."\n";
}
header("Content-Type: text/csv; charset=UTF-8");
header("Content-disposition: csv; filename=" . date("Y-m-d") ."_".$table.".csv; size=".strlen($csv));
echo $csv;
exit; |
Partager