我有一个 HTML/PHP 表格,可以从 mySQL 中提取数据。请看这里link https://anakpanti.com/ab-cargo/controllers_searchshipment/。例如,请搜索此发货代码以获取表格内的结果:42-7278954.
之后,我想将结果导出到 Excel(您也可以看到那里的按钮)。
下面是我的视图中的表代码(我删除了一些列以缩短代码):
$body = "";
$display = "<table class='table_searchshipment' id='table_searchshipment' cellpadding='0' cellspacing='0' border='0'>";
echo $display;
$body .= $display;
$display = "<thead>
<tr>
<th>CN No.</th>
<th>Doc No.</th>
</tr>
</thead>";
echo $display;
$body .= $display;
while($row = mysqli_fetch_array($result)) {
$CN_no= $row['CN_no'];
$doc_no= $row['doc_no'];
$display = "<tr>
<td>".$CN_no."</td>
<td>".$doc_no."</td>
</tr>";
echo $display;
$body .= $display;
}
$display = "</table>";
echo $display;
$body .= $display;
$body = htmlspecialchars($body);
echo '<form action = "setheader" method = "post">
<input type = "hidden" name = "body" value = "<?php echo $body ; ?>">
<input type = "submit" name = "submit" Value = "Export to excel">
</form>';
if(isset($_POST['submit'])){
$body = $_POST['body'];
setHeader("export.xls");
echo $body;
}
在控制器中,我创建了函数 setheader:
public function setheader($excel_file_name)//this function used to set the header variable
{
header("Content-type: application/octet-stream");//A MIME attachment with the content type "application/octet-stream" is a binary file.
//Typically, it will be an application or a document that must be opened in an application, such as a spreadsheet or word processor.
header("Content-Disposition: attachment; filename=$excel_file_name");//with this extension of file name you tell what kind of file it is.
header("Pragma: no-cache");//Prevent Caching
header("Expires: 0");//Expires and 0 mean that the browser will not cache the page on your hard drive
}
出现下载弹出窗口,但它只下载包含错误通知的“setheader”文件。请看一下here https://anakpanti.com/setheader.
Firstly,
该行需要更改为:
echo '<form action = "setheader" method = "post">
<input type = "hidden" name = "body" value = "<?php echo $body ; ?>">
<input type = "submit" name = "submit" Value = "Export to excel">
</form>';
to:
echo '<form action = "setheader" method = "post">
<input type = "hidden" name = "body" value = "'.$body.'">
<input type = "submit" name = "submit" Value = "Export to excel">
</form>';
第二,$body = htmlspecialchars($body);
最有可能返回一个空字符串。
来自PHP Docs http://php.net/manual/en/function.htmlspecialchars.php
如果输入字符串包含无效的代码单元序列
给定编码将返回空字符串,除非
设置了 ENT_IGNORE 或 ENT_SUBSTITUTE 标志。
如果不知道数据库来自哪些数据,就很难进一步测试。
但你可以尝试:
$body = htmlspecialchars($body, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');
看看它是否解决了这个问题。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)