//搜索 $start_time = strtotime($start_date); $end_time = strtotime($end_date); $sql = "select a.*,b.order_amount,b.money_paid from ".$ecs->table('invoice')." as a ". " left join ".$ecs->table('order_info')." as b on a.order_id=b.order_sn". " where a.add_time >=".$start_time." and a.add_time <=".$end_time." "; $temp_list = $db->getAll($sql); if($temp_list){//有数据 $Html=''; $mime_type = 'application/vnd.ms-excel'; header('Content-Type: ' . $mime_type); header('Content-Disposition: attachment; filename="invoice.xls"'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); echo $Html;
有时excel会自动把数字转换格式,于是有些手机号码,身份证之类的就乱了,因此可以在导出时,先定义好
'.$temp_list[$i][order_id].'