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

*/
?>