[SQL] Exportation CSV dans un fichier

$filename = "test.txt";
print "Ecrire dans $filename<br>";
$fp = fopen ($filename, "w") or die ("Impossible d'ouvrir $filename");
fwrite ($fp, "Hello\n");
fclose($fp);
print "réaliser un ajout dans $filename<br>";
$fp = fopen ($filename, "a") or die ("Impossible d'ouvrir $filename");
fputs ($fp, "Une autre chaine\n");
fclose($fp) ;

/* vars for export */
// database record to be exported
$db_record = 'XXXX';
// optional where query
$where = '';
// filename for export
$csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
 
// database variables
$hostname = "XXXXX";
$user = "XXXXX";
$[/contents/64-mots-de-passe password] = "XXXXX";
$database = "XXXXX";
 
// Database connecten voor alle services
mysql_connect($hostname, $user, $password)
or die('Could not connect: ' . mysql_error());
mysql_select_db($database)
or die ('Could not select database ' . mysql_error());
 
// create empty variable to be filled with export data
$csv_export = '';
 
// query to get data from database
$query = mysql_query("SELECT * FROM ".$db_record." ".$where);
$field = mysql_num_fields($query);
 
// create line with field names
for($i = 0; $i < $field; $i++) {
$csv_export.= mysql_field_name($query,$i).';';
}
// newline (seems to work both on Linux & Windows servers)
$csv_export.= '
';
 
// loop through database query and fill export variable
while($row = mysql_fetch_array($query)) {
// create line with field values
for($i = 0; $i < $field; $i++) {
$csv_export.= '"'.$row[mysql_field_name($query,$i)].'";';
} 
$csv_export.= '
'; 
}
 
// Export the data and prompt a csv file for download
header("Content-type: text/x-csv");
header("Content-Disposition: attachment; filename=".$csv_filename."");
echo($csv_export);