浏览文章
文章信息
PHP简单的Excel表格下载
2581
$result = $this->model->query($sql)->rows;
# 下载产品Excel
$search = "";
foreach ($result as $key => $val) {
$search .= "<tr>
<td>{$val['product_id']}</td>
<td>{$val['sku']}</td>
<td>{$val['keyword']}</td>
<td>{$val['language_id']}</td>
</tr>";
}
$table = "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
<table border='1' width='100%'>
<tr>
<td>产品ID</td>
<td>SKU</td>
<td>SEO-URL</td>
<td>语言ID</td>
</tr>".$search."
</table>";
$file_name = 'SEO URL 映射表'.date("Y-m-d H:i:s");
header("Pragma: public");
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition: inline;filename=$file_name.xls");
echo $table;
exit;