<?php
include_once("inc/auth.inc.php");
error_reporting(0);//屏蔽提示信息
Header( "Content-type: application/octet-stream ");
Header( "Accept-Ranges: bytes ");
Header( "Content-type:application/vnd.ms-excel ;charset=utf-8");//自己写编码
Header( "Content-Disposition:attachment;filename=投票结果.xls "); //名字
?>
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr class="TableHeader">
<td align="center"><strong>级别</strong></td>
<td align="center"><strong>姓名</strong></td>
<td align="center"><strong>优秀</strong></td>
<td align="center"><strong>称职</strong></td>
<td align="center"><strong>基本称职</strong></td>
<td align="center"><strong>不称职</strong></td>
<td align="center"><strong>总分</strong></td>
<td align="center"><strong>基本称职和不称职占总票的比例</strong></td>
</tr>
<?
$query6 = "SELECT * from vote_jieguo where vote_id = '".$VOTE_ID."'";
$query6 = "SELECT * FROM (SELECT *,youxiu AS number FROM vote_jieguo where vote_id = '".$VOTE_ID."' GROUP BY jibie,xingming) a
WHERE
9999>(
SELECT COUNT(*)
FROM (SELECT jibie,xingming,COUNT(*) AS number FROM vote_jieguo GROUP BY jibie,xingming) b
WHERE a.jibie=b.jibie AND a.number<b.number
)ORDER BY jibie,number DESC; ";
$cursor6= exequery(TD::conn(),$query6,$query6);
while($ROW6=mysql_fetch_array($cursor6))
{
?>
<tr>
<td align="center"><?=$ROW6["jibie"]?></td>
<td align="center"><?=$ROW6["xingming"]?></td>
<td align="center"><?=$ROW6["youxiu"]?></td>
<td align="center"><?=$ROW6["chenzhi"]?></td>
<td align="center"><?=$ROW6["jibenchenzhi"]?></td>
<td align="center"><?=$ROW6["buchenzhi"]?></td>
<td align="center"><b style="color: red;"><?=$ROW6["zongfen"]?></b></td>
<td align="center"><?=$ROW6["bili"]?></td>
</tr>
<?
}
?>
</tbody>
</table>
php自动导出excel的简单方法
最新推荐文章于 2024-06-29 09:51:21 发布