AW: Fehler bei Datenexport
<?php
$DatabaseHost = "localhost";
$DatabaseUser = "web5";
$DatabasePassword = "hodensack";
$Database = "usr_web1_1";
$Table = "tbl_reservations_temp";
header('Content-Type: text/x-csv');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=Reservierungen.csv');
header('Pragma: no-cache');
$DatabasePointer = mysql_connect($DatabaseHost, $DatabaseUser, $DatabasePassword);
mysql_select_db($Database, $DatabasePointer);
$ResultPointer = mysql_query("SELECT user_ID FROM tbl_reservations_temp");
for($i=0, $Export=""; $i<mysql_num_rows($ResultPointer); $i++)
{
$Daten = mysql_fetch_object($ResultPointer);
$Spalte[] = str_replace("\"", "\"\"", $Daten->user_ID);
for($j=0; $j<count($Spalte); $j++)
{
$Export .= "\"" . $Spalte[$j] . "\"";
if($j!=count($Spalte)-1)
{
$Export .= ";";
}
}
$Export .= "\r\n";
$Spalte = "";
}
echo$Export;
?>
|