php实例:导出数据到excel文件
<?php
//开启输出缓存
ob_start();
//连接数据库,查询数据
$conn=mysql_connect('127.0.0.1','root','8888');
mysql_select_db('test',$conn);
$query=mysql_query("select * from category") ;
?>
<table width="300" border="0">
<tr>
<th align="center">ID</th>
<th align="center">pID</th>
<th align="center">name</th>
</tr>
<?php
while($myrow = mysql_fetch_array($query)){
?>
<tr>
<td align="center"><?php echo $myrow["categoryId"]; ?></td>
<td align="center"><?php echo $myrow["parentId"]; ?></td>
<td align="center"><?php echo $myrow["categoryName"]; ?></td>
</tr>
<?php
}
?>
</table>
<?php
//获取缓存区数据
$data = ob_get_contents();
ob_end_clean();
//保存到excel文件
$fp=fopen('data.xls',"wb");
fwrite($fp,$data);
fclose($fp);
echo 'ok';
?>