想导出Excel数据?
是不是有人告诉过你下载这个,引入那个。来个超简单的。
$innerdata = Db::name('order')->select(); $table = ''; $table .= "<table> <thead> <tr> <th class='name'>名称</th> <th class='name'>入库日期</th> <th class='name'>入库库位</th> <th class='name'>供货商</th> <th class='name'>入库人</th> <th class='name'>数量</th> <th class='name'>单价</th> </tr> </thead> <tbody>"; foreach ($innerdata as $v) { $table .= "<tr> <td class='name'>{$v['out_trade_no']}</td> <td class='name'>{$v['time']}</td> <td class='name'>{$v['shou_name']}</td> <td class='name'>{$v['total_price']}</td> </tr>"; } $table .= "</tbody> </table>"; //通过header头控制输出excel表格 header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download");; header('Content-Disposition:attachment;filename="入库明细表.xls"'); header("Content-Transfer-Encoding:binary"); echo $table;