php mysql导出excel_php导出mysql数据（以excel形式下载）

/*******EDIT LINES 3-8*******/

$DB_Server="192.168.66.209";//MySQL Server

$DB_Username="snh48";//MySQL Username

$DB_Password="akb48@mina";//MySQL Password

$DB_DBName="snh48";//MySQL Database Name

//var_dump($_GET);die;

if(!$_GET)exit("parameter needed");

if($_GET['a']=='weekly'){

$DB_TBLName="eighth_join_girls";//MySQL Table Name

$filename="daily_sum_".date('y-m-d');//File Name

/*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/

//create MySQL connection

$sql="Selectcount(*) as daily_sum,date(submit_time) as time  from$DB_TBLNamegroup by time";

$Connect= @mysql_connect($DB_Server, $DB_Username, $DB_Password)or die("Couldn't connect to MySQL:

".mysql_error()."

".mysql_errno());

//select database

$Db= @mysql_select_db($DB_DBName, $Connect)or die("Couldn't select database:

".mysql_error()."

".mysql_errno());

//execute query

$result= @mysql_query($sql,$Connect)or die("Couldn't execute query:

".mysql_error()."

".mysql_errno());

$file_ending="xls";

//header info for browser

header("Content-Type: application/xls");//设置请求头部，下载xls文件；/Content-Disposition: attachment设置文件以附件形式下载

header("Content-Disposition: attachment; filename=$filename.xls");

header("Pragma: no-cache");

header("Expires: 0");

/*******Start of Formatting for Excel*******/

//define separator (defines columns in excel & tabs in word)

$sep="\t";//tabbed character

//start of printing column names as names of MySQL fields

for($i=0; $i

echomysql_field_name($result,$i)."\t";

}

print("\n");

//end of printing column names

//start while loop to get data

while($row=mysql_fetch_row($result))

{

$schema_insert="";

for($j=0; $j

{

if(!isset($row[$j]))

$schema_insert.="NULL".$sep;

elseif($row[$j]!="")

$schema_insert.="$row[$j]".$sep;

else

$schema_insert.="".$sep;

}

$schema_insert=str_replace($sep."$","", $schema_insert);

$schema_insert=preg_replace("/\r\n|\n\r|\n|\r/"," ", $schema_insert);

$schema_insert.="\t";

print(trim($schema_insert));

print"\n";

}

}