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
|
function export(){
$content = array();
$head = array();
$head []= 'head1';
$head []= 'head2';
$query = "SELECT * from table ";
$result = db_query($query);
while ($data = db_fetch_object($result)) {
$output = array();
$output[]= utf8_decode($data->data1);
$output[]= utf8_decode($data->data2);
switch ($data->data2) {
case 1: $output[] = utf8_decode("test1"); break;
case 2: $output[] = utf8_decode("test2"); break;
case 3: $output[] = utf8_decode("test3"); break;
case 4: $output[] = utf8_decode("test4"); break;
default: $output[] = utf8_decode(""); break;
}
$content[] = $output;
}
$file = 'export'.date('d_m_Y_h_i_s').'.csv';
$fp = fopen($file,"w" ); // ouverture du fichier
$export = join(';',$entete)."\n";
foreach ($contenu as $fields) {
$export .= str_replace("\n","",join(';',$fields))."\n";
}
header( 'Content-type: text/comma-separated-values' );
header( 'Content-disposition: attachment; filename='.$file);
print $export;
} |
