PHP 数据导出到EXECEL类

数据

/*
    Name: ToExcel
    Author: Riyao Chen
    Version: 0.0.1
    Date: 2006-05-15
    License: GPL
*/

/****************************************
//This class is to change data from query to excel file
//SQL FORMAT:
 SELECT c_id,c_title,c_subject FROM news_content WHERE c_parid=0 ORDER BY c_date desc,c_clicks desc
//The DataBase connection is open outside;
//Parameter:$sql,The query sentence ;$database,which database
***********************************/
class ToExcel
{
 var $sql="";
 var $fields;

 var $db;
 
 function ToExcel($sql,$database)
 {
  if($sql == "")
   return $this->errorMessage("NO QUERY SENTENCE!");

  $this->db = $database;
  
  //Get Table Name 
  $tmp=ereg_replace("SELECT.+FROM ","",$sql);
  $tmp=ereg_replace("ORDER BY.+","",$tmp);
  $this->table = ereg_replace(" WHERE.+","",$tmp);
  //Get Fields 
  $field = ereg_replace("SELECT ","",$sql);
  $field = ereg_replace(" FROM.+","",$field);
  if(trim($field) == "*")
   $this->fields = $this->GetFieldList($this->table);//$mysql->GetFieldList($this->table);
  else
   $this->fields = explode(",",$field);
   
  $this->sql = $sql;
  
  }
 
 function ShowExcel()
 {  
  header("Content-type:application/vnd.ms-excel");
  header("Content-Disposition:filename=Excel.xls");
  
  //OutPut Fields Start
  foreach($this->fields as $key=>$value)
  {
   echo $value."\t";
   
   }
  echo "\n";
  //OutPut Fields End
  
  //OutPut Field Value Start   
  $result = mysql_query($this->sql);
  while($row = mysql_fetch_array($result))
  {
   foreach($this->fields as $key=>$value)
    echo iconv("utf-8","gb2312",$row[$value]."\t");

   echo "\n";
   }
   
  //OutPut Field Value End
  
  }
 
 //Get The FieldLis
 function GetFieldList($table)
 {
  if($result=mysql_list_fields($this->db,$table)){
             $i=0;
             while($i                  $fd_names[$i]=mysql_field_name($result,$i);
                 $i++;
             }
             return($fd_names);
             
         }else
              return $this->errorMessage("Unable to find any field list in table: $tbl_name");

  }
 
  function errorMessage($msg){
         echo "Error: $msg : ".mysql_error();
  return false;
      }
  
 }
 

智慧车行预约小程序

智慧车行小程序，是一个专门为洗车/4S/车辆维修行业打造的小程序，前后端完整代码包括车行动态，养车常识，保养预约，维修预约，洗车美容预约，汽车检测预约等功能。采用腾讯提供的小程序云开发解决方案，无须服务器和域名预约管理：开始/截止时间/人数均可灵活设置，可以自定义客户预约填写的数据项预约凭证：支持线下到场后校验签到/核销/二维码自助签到等多种方式详尽的预约数据：支持预约名单数据导出Excel，打印

0

查看详情

/*
exemple

$sql = "SELECT * FROM news_content WHERE c_parid=0 ORDER BY c_date desc,c_clicks desc";
$excel = new ToExcel($sql,DATABASE_NAME);
$excel->ShowExcel();

*/
?>