php pdo连接mysql数据查询数据

$db = new sqlite3('mysql教程itedb.db');

//获取文件2进制流
$filename = "/www.111cn.net/logo.gif";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize ($filename));
fclose($handle);
//创建数据表
$db->exec('create table person (idnum text,name text,photo blob)');

$stmt = $db->prepare("insert into person values ('41042119720101001x', '张三',?)");
$stmt->bindvalue(1, $contents, sqlite3_blob);
$stmt->execute();

class excel{   
  
 
    var $header = "<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/tr/rec-html40">";   

    var $footer = "</workbook>";
    var $lines = array ();   
    var $worksheet_title = "table1";   
   
    function addrow ($array) {   
  
 
        $cells = "";   
           
 
        foreach ($array as $k => $v):   
               
            // 加个字符串与数字的判断 避免生成的 excel 出现数字以字符串存储的警告   
            if(is_numeric($v)) {   
                // 防止首字母为 0 时生成 excel 后 0 丢失   
                if(substr($v, 0, 1) == 0) {   
                    $cells .= "<cell><data ss:type="string">" . $v . "</data></cell> ";   
                 } else {   
                    $cells .= "<cell><data ss:type="number">" . $v . "</data></cell> ";   
                 }   
             } else {   
                $cells .= "<cell><data ss:type="string">" . $v . "</data></cell> ";   
             }   
  
        endforeach;   
  
        // transform $cells content into one row   
        $this->lines[] = "<row> " . $cells . "</row> ";   
  
     }   
     
    function addarray ($array) {   
  
        // run through the array and add them into rows   
        foreach ($array as $k => $v):   
            $this->addrow ($v);   
        endforeach;   
  
     }   
   
    function setworksheettitle ($title) {   
  
        // strip out special chars first   
        $title = preg_replace ("/[\|:|/|?|*|[|]]/", "", $title);   
  
        // now cut it to the allowed length   
        $title = substr ($title, 0, 31);   
  
        // set title   
        $this->worksheet_title = $title;   
  
     }   
 
    function generatexml ($filename) {   
  
 
         header("content-type: application/vnd.ms-excel; charset=utf-8");   
         header("content-disposition: inline; filename="" . $filename . ".xls"");   
 
        echo strips教程lashes ($this->header);   
        echo " <worksheet ss:name="" . $this->worksheet_title . ""> <table> ";   
        echo "<column ss:index="1" ss:autofitwidth="0" ss:width="110"/> ";   
        echo implode (" ", $this->lines);   
        echo "</table> </worksheet> ";   
        echo $this->footer;   
  
     }   
  
}   
 
  
/**
*   非框架使用方法
*
*   require_once('excel.php');
*   $doc = array (
*        0 => array ('中国', '中国人', '中国人民', '123456");
*   );
*   $xls = new excel;
*   $xls->addarray ( $doc );
*   $xls->generatexml ("mytest");
*/  

?>

<?

       header("content-type:application/vnd.ms-excel");

       header("content-disposition:filename=test.xls");

       echo "test1";

       echo "test2";

       echo "test1";

       echo "test2";

       echo "test1";

       echo "test2";

       echo "test1";

       echo "test2";

       echo "test1";

       echo "test2";

       echo "test1";

       echo "test2";

?>

方法三

<?
  header("content-type:   application/octet-stream"); 
  header("accept-ranges:   bytes"); 
  header("content-type:application/vnd.ms-excel");   
  header("content-disposition:attachment;filename=export_excel_gshjsl.xls");   
  
  $tx='表头'; 
  echo   $tx." ";
  echo   "编号"." "; 
  echo   "姓名"." "; 
  echo   " ";

 echo "="411481198507150666""." ";
 echo "="0123456""." ";
 echo " ";
 ?>

class mysql {
 var $linkid=null;

    function __construct($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'gbk', $connect = 1) {
     $this -> connect($dbhost, $dbuser, $dbpw, $dbname, $dbcharset, $connect);
    }

    function connect($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'gbk', $connect=1){
     $func = empty($connect) ? 'mysql_pconnect' : 'mysql_connect';
     if(!$this->linkid = @$func($dbhost, $dbuser, $dbpw, true)){
      $this->dbshow('can not connect to mysql!');
     } else {
      if($this->dbversion() > '4.1'){
       mysql_query( "set names gbk");
       if($this->dbversion() > '5.0.1'){
        mysql_query("set sql_mode = ''",$this->linkid);
       }
      }
     }
     if($dbname){
      if(mysql_select_db($dbname, $this->linkid)===false){
       $this->dbshow("can't select mysql database($dbname)!");
      }
     }
    }

    function select_db($dbname){
     return mysql_select_db($dbname, $this->linkid);
    }

    function query($sql){
     if(!$query=@mysql_query($sql, $this->linkid)){
      $this->dbshow("query error:$sql");
     }else{
      return $query;
     }
    }

    function getall($sql, $type=mysql_assoc){
     $query = $this->query($sql);
     while($row = mysql_fetch_array($query,$type)){
      $rows[] = $row;
     }
     return $rows;
    }

    function getone($sql, $type=mysql_assoc){
     $query = $this->query($sql,$this->linkid);
     $row = mysql_fetch_array($query, $type);
     return $row;
    }

 function fetch_array($result,$type = mysql_assoc){
  return mysql_fetch_array($result);
 }

    function affected_rows(){
     return mysql_affected_rows($this->linkid);
    }

    function num_rows(){
     return mysql_num_rows($this->linkid);
    }

    function num_fields($result){
     return mysql_num_fields($result);
    }

    function insert_id(){
     return mysql_insert_id($this->linkid);
    }

    function free_result(){
     return mysql_free_result($this->linkid);
    }

    function error(){
     return mysql_error($this->linkid);
    }

    function errno(){
     return mysql_errno($this->linkid);
    }

    function close(){
     return mysql_close($this->linkid);
    }

    function dbversion(){
     return mysql_get_server_info($this->linkid);
    }

    function dbshow($msg){
     if($msg){
      echo "error：".$msg."<br><br>";
     }else{
      echo "errno：".$this->errno()."<br>error：".$this->error();
     }
     exit;
    }

}