phpexcel导出与读取excel的经典实例

<?php 
// 包含class的基本头文件
include("./class/class.php");

// 生成excel的基本类定义(注意文件名的大小写)
include("./class/phpexcel/PHPExcel.php");
// 包含写Excel5格式的文件，如果需要生成excel2007的文件，包含对应的Writer即可
include("./class/phpexcel/PHPExcel/Writer/Excel5.php");
// 包含写PDF格式文件
include("./class/phpexcel/PHPExcel/Writer/PDF.php");

// 创建phpexcel对象，此对象包含输出的内容及格式
$m_objPHPExcel = new PHPExcel();

// 模板文件，为了实现格式与内容分离，有关输出文件具体内容实现在模板文件中
// 模板文件将对象$m_objPHPExcel进行操作
include("./include/excel.php");

// 输出文件的类型，excel或pdf
$m_exportType = "pdf";

$m_strOutputExcelFileName = date('Y-m-j_H_i_s').".xls"; // 输出EXCEL文件名
$m_strOutputPdfFileName = date('Y-m-j_H_i_s').".pdf"; // 输出PDF文件名

// 输出文件保存路径，此路径必须可写
$m_strOutputPath = "./output/";

// 如果需要输出EXCEL格式
if($m_exportType=="excel"){
$objWriter = new PHPExcel_Writer_Excel5($m_objPHPExcel);
$objWriter->save($m_strOutputPath.$m_strOutputExcelFileName); 
}

// 如果需要输出PDF格式
if($m_exportType=="pdf"){
$objWriter = new PHPExcel_Writer_PDF($m_objPHPExcel);
$objWriter->save($m_strOutputPath.$m_strOutputPdfFileName); 
}
?>

<?php
  $servern="SFKFK27EL8FJ＼SQLTRY";
  $coninfo=array("Database"=>"try2","UID"=>"sa","PWD"=>"123");
  $conn=sqlsrv_connect($servern,$coninfo) or die ("连接失败!");
  $val=sqlsrv_query($conn,"select * from usertable");
  while($row=sqlsrv_fetch_array($val)){
    echo $row[1]."<br />";
  }
  sqlsrv_close($conn);
?>

<?php

class DB {
    var $con = null;
    function __construct($dbhost,$dbuser,$dbpass,$dbname) {
        $connectionInfo =  array("UID"=>$dbuser,"PWD"=>$dbpass,"Database"=>$dbname);
        $this->con = sqlsrv_connect($dbhost,$connectionInfo);
    }

    function query($sql){
        $result = sqlsrv_query($this->con, $sql);
    }

    function getRow($sql){
        $result = sqlsrv_query($this->con, $sql);
        $arr = array();
        while($row = sqlsrv_fetch_array($result))
        {
            $arr[] = $row;
        }
        return $arr[0];
    }

    function getAll($sql){
        $result = sqlsrv_query($this->con, $sql);
        $arr = array();
        while($row = sqlsrv_fetch_array($result))
        {
            $arr[] = $row;
        }
        return $arr;
    }

    function __destruct() {
        unset($con);
    }

}
test.php

//简单调用
$db = new DB(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$sql = "select * from crm_order_batch where (status=0 or status is null) and lock_id is not null  ";
$orders_add_list = $db->getAll($sql);

<?php
header("content-type:text/html;charset:utf-8");
include "../inc/str.php";
include "../Inc/mysql.php";
include "../Inc/const.php";  
if($is_memcache){    
    // $memcache操作    
    $memcache = new Memcache;    
    try{        
        $memc=@$memcache->connect($memcache_server, $memcache_port);    
        if($memc){
            $getMsg=$memcache->get("360GetMsgDate");//获取缓存中的数据
            // $memcache->delete("360GetMsgDate");
            if(!$getMsg){  
                $jsonDate = getMessage($f_serverName,$f_userName,$f_password,$f_htNewsDate);
                $memcache->set("360GetMsgDate",$jsonDate,0,3600); //设置缓存时间为一小时
                echo $jsonDate;
            }
            else{     
                 echo $getMsg;
            }       
            $memcache->close();
        }
        else{
            //code
        }
    }catch(Exception $e){
        print $e->getMessage();
    }
    unset($memcache);
    //结束$memcache操作
}else{
  echo  getMessage($f_serverName,$f_userName,$f_password,$f_htNewsDate);
}

1 mysql_query("SET NAMES 'UTF8'");
2 mysql_query("SET CHARACTER SET UTF8");
3 mysql_query("SET CHARACTER_SET_RESULTS=UTF8'");

set_time_limit(0);
mysql_connect('localhost','root','root');
mysql_select_db('sms');
mysql_query("set Names 'gbk'");