本文由我司收集整編，推薦下載，如有疑問，請(qǐng)與我司聯(lián)系

PHP生成excel，方法一:header生成

2018/02/09 444 public function export_order() { //搜索條件$where = ‘where 1=1 ‘; $consignee = I(‘consignee’); if($consignee){ $where .= “ AND consignee like ‘%$consignee%’ “; } $order_sn = I(‘order_sn’); if($order_sn){ $where .= “ AND order_sn = ‘$order_sn’ “; } if(I(‘order_status’)){ $where .= “ AND order_status = “.I(‘order_status’); } $timegap = I(‘timegap’); if($timegap){ $gap = explode(‘-’, $timegap); $begin = strtotime($gap[0]); $end = strtotime($gap[1]); $where .= “ AND add_time $begin and add_time $end “; } $sql = “select *,FROM_UNIXTIME(add_time,’%Y-%m-%d’) as create_time from __PREFIX__order $where order by order_id”; $orderList = D()- query($sql); $strTable =‘ table width=“500” border=“1” $strTable .= ‘ tr $strTable .= ‘ td 訂單編號(hào)/td $strTable .= ‘ td width=“100” 日期/td $strTable .= ‘ td width=“*” 收貨人/td $strTable .= ‘ td width=“*” 收貨地址/td $strTable .= ‘ td width=“*” 電話/td $strTable .= ‘ td width=“*” 訂單金額/td $strTable .= ‘ td width=“*” 實(shí)際支付/td $strTable .= ‘ td width=“*” 支付方式/td $strTable .= ‘ td width=“*” 支付狀態(tài)/td $strTable .= ‘ td width=“*” 發(fā)貨狀態(tài)/td $strTable .= ‘ td width=“*” 商品信息/td $strTable .= ‘ /tr if(is_array($orderList)){ $region = M(‘region’)- getField(‘id,name’); foreach($orderList as $k= $val){ $strTable .= ‘ tr $strTable .= ‘ td nbsp;’.$val[‘order_sn’].’ /td $strTable .= ‘ td ‘.$val[‘create_time’].’ /td $strTable .= ‘ td ‘.$val[‘consignee’].’ /td $strTable .= ‘ td ‘.”{$region[$val[‘province’]]},{$region[$val[‘city’]]},{$region[$val[‘district’]]},{$region [$val[‘twon’]]}{$val[‘a(chǎn)ddress’]}”.’ /td $strTable .= ‘ td ‘.$val[‘mobile’].’ /td $strTable .= ‘ td ‘.$val[‘goods_price’].’ /td $strTable .= ‘ td ‘.$val[‘order_amount’].’ /td $strTable .= ‘ td ‘.$val[‘pay_name’].’ /td $strTable .= ‘ td ‘.$this- pay_status[$val[‘pay_status’]].’ /td $strTable .= ‘ td ‘.$this- shipping_status[$val[‘shipping_status’]].’ /td $orderGoods = D(‘order_goods’)-

總結(jié)

以上是生活随笔為你收集整理的php excel header,【IT专家】PHP生成excel,方法一-header生成的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。