Home  >  Article  >  Backend Development  >  php导出word格式数据的代码实例_php实例

php导出word格式数据的代码实例_php实例

WBOY
WBOYOriginal
2016-05-17 08:52:44881browse

本节内容:
一个php导出文档的类

例子:

复制代码 代码如下:

/**
* 生成word文档的类
*
*/
class word
{
    function start()
    {
        ob_start();
        echo '        xmlns:w="urn:schemas-microsoft-com:office:word"
        xmlns="http://www.w3.org/TR/REC-html40">';
        }
    function save($path)
    {    
        echo "";
        $data = ob_get_contents();
        ob_end_clean();

        $this->wirtefile ($path,$data);
    }

    function wirtefile ($fn,$data)
    {
        $fp=fopen($fn,"wb");
        fwrite($fp,$data);
        fclose($fp);
    }
}

//导出的程序文件
//导出 ---start---
require SITE_ROOT.'include/word.class.php';  //类文件放在根目录下的include文件夹下
$word = new word();
//查询数据填入word 中
$result = $db->query("SELECT * FROM ".DB_PRE."box where status='9' order by boxid DESC");
while($r = $db->fetch_array($result))
{
  $r['orderinfo'] = $db->get_one("SELECT * FROM ".DB_PRE."order where orderid='".$r['orderid']."'");
  $r['wrapinfo']  = $db->get_one("SELECT * FROM ".DB_PRE."wrap where orderid='".$r['orderid']."'");
 $boxlist[] = $r;
}

 foreach($boxlist as $key=>$val){
    $order->UPCAbarcode($val['box_code']);

    $html .='


   
     
     
     
     
     
     
   
   
     
     
     
     
     
     
   
   
     
     
     
     
   
   
     
          
   
   
     
     
   
   
iGo运
单号
php导出word格式数据的代码实例_php实例
  '.$val['box_code'].'
日期 '.date('Y-m-d',$val[create_date]).' 标示
姓名
'.$val[code].'/'.$val['orderid'].'
'.$val['orderinfo']['user_name'].'
件数 3 重量 56.5 品名 咬咬了,吸盘碗,学饮杯,鱼干油
服务
类别
库房服务 服务
要求
合小箱


客户
备注

'.$val['orderinfo']['beizhu'].'



到货
情况



什么问题?果点不到
什么问题?果点不到
什么问题?果点不到












'; 
 }
     $word->start();
     $filename = '拣货单导出.doc';
     echo $html;
      $word->save($filename);

      //文件的类型
      header('Content-type: application/word');
      header('Content-Disposition: attachment; filename="拣货单导出.doc"');
      readfile($filename);
      ob_flush();
      flush();
     exit();
//导出word --end--
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn