php将mysql数据导出excel表中_使用PHP将Mysql数据表导出到Excel中

//使用PHP将Mysql数据表导出到Excel中

$db = 'test';

$table = 'article';

header("content-type:text/html;charset=utf-8");

@mysql_connect('localhost','root','123456');

mysql_set_charset('utf8');

mysql_select_db($db);

$sql = "select * from $table";

$res = mysql_query($sql);

$file_type = "vnd.ms-excel";

$file_ending = "xls";

header("content-type:application/$file_type");

header("content-Disposition: attachement; filename=$table.$file_ending");

header("Pragma: no-cache");

header("Expires: 0");

$time = date("Y-m-d H:i");

$title = "数据库名：$db,数据表名：$table,备份日期：$time";

echo "$title\n";

$sep = "\t";

for ($i=0; $i < mysql_num_fields($res); $i++) {

echo mysql_field_name($res,$i)."\t";

}

print("\n");

$i = 0;

while ($row = mysql_fetch_row($res)) {

$schema_insert = "";

for($j = 0;$j < mysql_num_fields($res); $j++){

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

$schema_insert .= "NULL".$sep;

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

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

} else {

$schema_insert .= "".$sep;

}

}

$schema_insert .= "\t\n";

echo $schema_insert;

$i++;

}