从mysql导出到excel 格式为.csv

<?php

include_once("dbconini.php");
$EXCEL_OUT="姓,名,年龄,生日\n";
$query="select * from $test_data";
$result=mysql_query($query);
while($ROW=mysql_fetch_array($result))
{
$xing=$ROW['xing'];
$ming=$ROW["ming"];
$age=$ROW["age"];
$birthday=$ROW["birthday"];
$EXCEL_OUT.="$xing,$ming,$age,$birthday\n";
}
header("Expires: 0");
header("Cache-control: private");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Content-Description: File Transfer");
header("Content-Type: application/vnd.ms-excel");
header("Content-disposition: attachment;filename=file_name.csv");

echo $EXCEL_OUT;
mysql_close($con);

?>