![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
下面的代码在windows上运行正常,但是在Linux上并没有生成excel文件,只简单的打印出来。请问如何才能在Linux上生成Excel?
[PHP]
<?php
header("Content-type:application/vnd.ms-excel");
header("Content-disposition:attachment;filename=exhibition.xls");
echo "序号\t姓名\t职位\t性别\t公司\t地址\t邮编\t电邮\t主页\t电话\t传真\t行业\t希望\t";
echo "期望展览\t工作性质\t企业性质\t兴趣范围\t公司领域\t采购身份\t公司人数\t了解展会\t填写日期\t参观目的,用户种类,购买因素\t\n";
$sql=<<
`id` AS `序号`,
`name` AS `姓名`,
`poisition` AS `职位`,
`sex` AS `性别`,
`company` AS `公司`,
`address` AS `地址`,
`post` AS `邮编`,
`email` AS `电邮`,
`homepage` AS `主页`,
`tel` AS `电话`,
`fax` AS `传真`,
`tp` AS `行业`,
`hope` AS `希望`,
`pp` AS `期望展览`,
`ww` AS `工作性质`,
`mc` AS `企业性质`,
`tt` AS `兴趣范围`,
`cc` AS `公司领域`,
`ac` AS `采购身份`,
`ps` AS `公司人数`,
`wc` AS `了解展会`,
`submitdate` AS `填写日期`,
`ite` AS `参观目的,用户种类,购买因素`
FROM `tempexhibition`
WHERE 1
ORDER BY `submitdate` DESC
END;
//echo $sql;
mysql_connect("localhost","root","");
mysql_select_db("dbmy") or die("对不起,请稍候再试!");
$result=mysql_query($sql) or die("对不起,请稍候再试!");
while($data=mysql_fetch_array($result))
{
for($i=0;$i<23;$i++)
{
echo $data[$i++]."\t";
}
echo "\n";
}
?>
[/PHP]

