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

for($i = 0, $Export = ""; $i < mysql_num_rows($ResultPointer); $i++)  
{  
    $Daten = mysql_fetch_object($ResultPointer);  
  
    $Spalte = array($Daten->Name,$Daten->Vorname,$Daten->Telefonnummer); 
 
    // Eliminierung der Anführungszeichen innerhalb der Daten 
    $Spalte = str_replace('"', '', $Spalte);  
  
    // mit Anführungszeichen:  
    $Export .= "\"" . join('","',$Spalte) . "\"\r\n"; 
     
    // ohne umschließende Anführungszeichen 
    // $Export .= join(',',$Spalte) . "\r\n"; 
     
    $Spalte = null; 
} 

header("Content-type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment;Filename=document_name.xls");