|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |
header("Content-type:application/vnd.ms-excel;charset=utf-8");$filename
= "order_".date("Y-m-d",time()).".xls";header("Content-Disposition:attachment; filename=$filename");$sql = "select id ,linkman,telephone,postcode, address,price,name from {$tablepre}shops ";$result
= $db->fetchAssocArrBySql($sql,0);//print_r($result);exit;$excelheader
= "订单号\t收货人\t手机\t邮编\t商品名称\t价格\t收货地址\t\n";foreach($result
as $k => $v){ if($k==0) { echo
iconv("utf-8","gbk",$excelheader); } foreach($v
as $kk => $vv) { $vv
= preg_replace(‘/\n/‘, ‘‘, $vv); $vv
= preg_replace(‘/\t/‘, ‘‘, $vv); $vv
= preg_replace(‘/‘.chr(13).‘/‘, ‘‘, $vv); //echo $vv."\t"; echo
@iconv("utf-8","gbk",$vv."\t"); } /* echo iconv("utf-8","gbk",$v[‘name‘]."\t"); $cardid = $db->fetchOneBySql("select idcode from {$tablepre}members where uid=‘".$v[‘title‘]."‘"); $cardid = "‘".strval($cardid); */ echo
"\n";}exit; |
原文：http://www.cnblogs.com/smallwind/p/3584186.html