论坛 › php › PHP 把数据表列出来的东西导出成execle格式

残缺极品 发表于 2017-4-14 06:10:13

PHP 把数据表列出来的东西导出成execle格式

　　<? php
　　header("Content-type:application/vnd.ms-excel");//这两行最重要
header("Content-Disposition:attachment;filename=test_data.xls");//这两行最重要，一定要写上

　　
　　
　　$tx='参会注册表';
echo $tx."\n\n";
echo "个人信息\t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo "同行人员\t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo "联系人员\t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \t";
echo " \n";
echo "编号\t";
echo "姓名\t";
echo "性别\t";
echo "单位类型\t";
echo "单位名称\t";
echo "职务\t";
echo "办公电话\t";
echo "移动电话\t";
echo "传真\t";
echo "邮箱\t";
echo "邮寄地址\t";
echo "邮编\t";
echo "姓名\t";
echo "性别\t";
echo "职务\t";
echo "电话\t";
echo "邮箱\t";
echo "姓名\t";
echo "性别\t";
echo "职务\t";
echo "电话\t";
echo "邮箱\t\n";
$i=0;
$result=mysql_query("select * from zhuce order by id desc");
while($row=mysql_fetch_array($result)){
$i++;
echo "$i\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t";
echo "$row\t\n";
}
　　?>
　　本热测试过，全部通过，希望能帮到更多的人，我们一起加油，如有疑问，请联系QQ：523132661

查看完整版本: PHP 把数据表列出来的东西导出成execle格式