'$time'
ORDER BY zeit ASC
";
export_csv($sql);
exit;
function export_csv($sql){
header('Content-Type: text/csv; charset=UTF-8');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=sms_export.csv');
header('Pragma: no-cache');
//echo "\xEF\xBB\xBF"; // UTF-8 BOM
// echo $sql."\n";
$result = mysql_query($sql) or die("export_csv.php: $sql
".mysql_error());
$numfields = mysql_num_fields($result);
$export = "";
// Spaltenüberschriften
for ($i=0; $i < $numfields; $i++){
$export .= mysql_field_name($result, $i);
if($i != $numfields-1)
{
$export .= ";";
}
}
$export .= "\r\n";
// Daten
for($i = 0; $i < mysql_num_rows($result); $i++)
{
$daten = mysql_fetch_array($result, MYSQL_NUM );
for ($j=0; $j < $numfields; $j++){
$datenReplaced = str_replace("\"", "\"\"", $daten[$j] );
$datenReplaced = str_replace( '
', ' ', $daten[$j] );
$spalte[] = $datenReplaced;
}
for($k = 0; $k < count($spalte); $k++)
{
$export .= "\"" . $spalte[$k] . "\"";
if($k != count($spalte)-1)
{
$export .= ";";
}
}
$export .= "\r\n";
$spalte = "";
}
echo $export;
exit;
}
?>