php导出execl...
时间：2010-08-17 来源：qiyufeifan
<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment; filename=test.xls");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>php导出excel</title>
</head>
<body>
<?php
$conn=mysql_connect("localhost","root","123456") or die("连接服务器出错！");
mysql_select_db("bbb",$conn) or die("没有数据库");
mysql_query("set names 'utf8'");
$sql="select * from sp where 1=1 ";
$result=mysql_query($sql);
?>
<table width="100%" border="1">
<?
while($array=@mysql_fetch_assoc($result)){ //myaql_fetch_assoc:从结果集中取得一行作为关联数组
?>
<tr>
<td><? echo $array['a'];?></td>
<td><? echo $array['b'];?></td>
<td><? echo $array['c'];?></td>
<td><? echo $array['d'];?></td>
<td><? echo $array['e'];?></td>
<td><? echo $array['f'];?></td>
<td><? echo $array['g'];?></td>
<td><? echo $array['h'];?></td>
<td><? echo $array['i'];?></td>
</tr>
<? }?>
</table>
</body>
</html>
相关阅读 更多 +
