mysql2excel.php<?php
/**
* author:
* create at:2015-11-13
* last mod: 2015-12-12 14:23:52
*/
header("content-type:application/vnd.ms-excel");
header("content-disposition:filename=xls_data.xls");
// header("content-type:text/html;charset=utf-8"); //测试启用
$dbhost = 'localhost';
$dbname = 'mydb'; //所在数据库名
$dbuser = 'root';
$dbpwd = '';
$language = 'utf8';
$tbname = 'mytable'; //要导出的表单
$style = "border='1' width='100%' cellspacing=0";//自定义表的样式,如果加css请使用连接符.
//链接数据库
$link = mysqli_connect($dbhost,$dbuser,$dbpwd,$dbname);
//设置utf8编码
mysqli_query($link,"set names ".$language);
//获取user表的段名和备注
$sql = "select column_name,column_comment from information_schema.columns where table_name='$tbname' and table_schema='$dbname'";
$cos = mysqli_query($link,$sql);
echo "";
//导出表头（也就是表中拥有的字段）
while($col = mysqli_fetch_assoc($cos)){
if ($col['column_comment']) {//取备注名组成数组，如果没有，则直接用段名
$t_field[] = $col['column_comment'];
echo "".$col['column_comment']."";
}else{
$t_field[] = $col['column_name'];
echo "".$col['column_name']."";
}
}
echo "";
//查出10条数据
$sql = "select * from $tbname limit 10";
$res = mysqli_query($link,$sql);
while($row = mysqli_fetch_array($res)){
echo "";
for ($i=0; $i < count($t_field); $i++) { //循环输出一行记录
echo "".$row[$i]."";
}
echo "";
}
echo "";
?>