PHP 导出 EXCEL

浏览数：40 / 时间：2015年06月09日
?
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;

PHP 导出 EXCEL,古老的榕树,5-wow.com

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。

标签： it string class word oc blog la gb sql io tr it string class word oc blog la gb sql io tr

相关文章

随机文章

您可能还喜欢

您可能还喜欢