PHP 数据导出到EXECEL类

最新推荐文章于 2024-07-02 12:16:12 发布

riyao

最新推荐文章于 2024-07-02 12:16:12 发布

阅读量1k

点赞数

分类专栏： php相关文章标签： php database sql function mysql query

本文链接：https://blog.csdn.net/riyao/article/details/729072

版权

php相关专栏收录该内容

69 篇文章 0 订阅

订阅专栏

<?
/*
    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 < mysql_num_fields($result)){
                $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;
      }

}

/*
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();

*/
?>