以下是excel 下载代码。现在由于数据量比较大,所以想让这个excel文件压缩后下载。接下去应该怎么写压缩部分的代码?header("Content-Type: application/vnd.ms-excel;charset=utf-8");
header("Content-Disposition: attachment; filename=Big_".date('YmdHis').".xls");
header("Pragma: no-cache");
header("Expires: 0");
echo '<table border="1" cellspacing="2" cellpadding="2" width="50%" align="center">';
echo '<tr bgcolor=#CCCCCC height="50%">';
// 输出字段名
echo "<td align='center'>id</td>";
echo "<td align='center'>项目编号</td>";
echo "<td align='center'>订单金额</td>";
echo "<td align='center'>最终订单金额</td>";
echo "<td align='center'>货币类型</td>";
echo "<td align='center'>开店日期</td>";
echo '</tr>';
// 输出内容
foreach($rs as $key => $outResult)
{
echo '<tr>';
echo "<td align='center'>" . $outResult['id'] . '</td>';
echo "<td align='center'>" . $outResult['project_number'] . '</td>';
echo "<td align='center'>" . $outResult['order_amount'] . '</td>';
echo "<td align='center'>" . $outResult['finally_amount'] . '</td>';
echo "<td align='center'>" . $outResult['money_type'] . '</td>';
echo "<td align='center'>" . $outResult['real_open_date'] . '</td>';
echo "<td align='center'>" . '</td>';
echo '</tr>';
}
echo '</table>';
header("Content-Disposition: attachment; filename=Big_".date('YmdHis').".xls");
header("Pragma: no-cache");
header("Expires: 0");
echo '<table border="1" cellspacing="2" cellpadding="2" width="50%" align="center">';
echo '<tr bgcolor=#CCCCCC height="50%">';
// 输出字段名
echo "<td align='center'>id</td>";
echo "<td align='center'>项目编号</td>";
echo "<td align='center'>订单金额</td>";
echo "<td align='center'>最终订单金额</td>";
echo "<td align='center'>货币类型</td>";
echo "<td align='center'>开店日期</td>";
echo '</tr>';
// 输出内容
foreach($rs as $key => $outResult)
{
echo '<tr>';
echo "<td align='center'>" . $outResult['id'] . '</td>';
echo "<td align='center'>" . $outResult['project_number'] . '</td>';
echo "<td align='center'>" . $outResult['order_amount'] . '</td>';
echo "<td align='center'>" . $outResult['finally_amount'] . '</td>';
echo "<td align='center'>" . $outResult['money_type'] . '</td>';
echo "<td align='center'>" . $outResult['real_open_date'] . '</td>';
echo "<td align='center'>" . '</td>';
echo '</tr>';
}
echo '</table>';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货