php怎么把session保存到MySql数据库中

<?php
class CustomSession{
 private static $db_host="localhost";
 private static $db_user="root";
 private static $db_password="";
 private static $database="session";

 private $conn;

 public static function getInstance(){
  static $instance=null;
  if($instance==null){
   $instance=new CustomSession();
  }

  return $instance;
 }

 public function __construct(){
  session_set_save_handler(
  array($this,"open"),
  array($this,"close"),
  array($this,"read"),
  array($this,"write"),
  array($this,"destroy"),
  array($this,"gc")
  );
 }

 public function __destruct(){
  session_write_close();
 }

 public function open(){
  $this->conn=mysql_connect(CustomSession::$db_host,CustomSession::$db_user,CustomSession::$db_password);
  mysql_select_db(CustomSession::$database,$this->conn);
 }

 public function close(){

  mysql_close($this->conn);
 }

 public function read($id){
  $escaped_id=mysql_escape_string($id);
  $res=$this->query("select * from `session` where `sessionid`='$escaped_id'");
  if($row=mysql_fetch_assoc($res)){
   $this->query("update `session` set `timetamp`=UTC_TIMESTAMP() where `sessionid`='$escaped_id'");
   return $row['data'];
  }
  return "";
 }

 public function write($id,$data){
  $query="replace into `session` (`sessionid`,`data`,`ip`,`timestamp`) values ('%s','%s','%s',UNIX_TIMESTAMP(UTC_TIMESTAMP()))";
  $this->query(sprintf($query,mysql_escape_string($id),mysql_escape_string($data),$_SERVER["REMOTE_ADDR"]));//www.111cn.net
 }

 public function destroy($id){
  $escaped_id=mysql_escape_string($id);
  $res=$this->query("delete from `session` where `id`='$escaped_id'");
  return (mysql_affected_rows($res)==1);
 }

 public function gc($lifetime){
  $this->query("delete from `session` where UNIX_TIMESTAMP(UTC_TIMESTAMP())-`timestamp` > $lifetime");
 }

 public function query($query){
  $res=mysql_query($query,$this->conn);
  return $res;
 }
}

?>

<?php
include('./CustomSession.class.php');

CustomSession::getInstance();

session_start();

$_SESSION['username']='feng';

print_r($_SESSION);

?>

<?php 

002 /** 

003  * 

004  * 防盗链外部资源下载处理类 

005  *  

006  * @author 清风 <xrcc_bk@126.com> 

007  * @link   http://blog.emtalk.net 

008  *  

009  */

010 class BurglarDow{ 

011     /** 

012      * 初始许可下载状态 

013      * @var    allow 

014      * @access private 

015      */

016     private $allow      =  false; 

017     /** 

018      * 初始下载地址 

019      * @var    dowUrl 

020      * @access private 

021      */

022     private $dowUrl     =  null; 

023     /** 

024      * 初始来路域名 

025      * @var    RemoteUrl 

026      * @access private 

027      */

028     private $RemoteUrl  =  null; 

029     /** 

030      * 初始许可资源取用域名列表 

031      * @var    allowUrl 

032      * @access private 

033      */

034     private $allowUrl   =  array(); 

035     /** 

036      * 初始转跳地址 

037      * @var    Location 

038      * @access private 

039      */

040     private $Location   =  null; 

041   

042     public function __construct($dowUrl,$Location,array $allowUrl){ 

043         // 初始下载地址 

044         $this->dowUrl   = $dowUrl; 

045         // 初始许可资源取用域名列表 

046         $this->allowUrl = $allowUrl; 

047         // 初始转跳地址 

048         $this->Location = $Location; 

049   

050         $this->RemoteUrl = @parse_url($_SERVER['HTTP_REFERER']);                                                      // 获取来路域名 

051         if(!is_array($this->RemoteUrl)) 

052             header("HTTP/1.1 301 Moved Permanently"); 

053             header("Location: ".$this->Location); 

054   

055         if(isset($this->RemoteUrl['host'])){ 

056             if(in_array($this->RemoteUrl['host'],$this->allowUrl)){                                                   // 判断是否来至许可域名 

057                 $this->allow  = true;                                                                                 // 下载许可状态为：真 

058             } 

059         } 

060         unset($this->allowUrl,$this->RemoteUrl);                                                                      // 释放内存变量 

061     } 

062   

063     /** 

064      * 防盗链资源下载 

065      * @access public 

066      * @return mixed 

067      */

068     public function dow(){ 

069         $FileInfo = get_headers($this->dowUrl,1);                                                                     // 获取远程文件头部信息 

070   

071         if(true === $this->allow){                                                                                    // 判断是否许可下载资源 

072             //判断配置文件是否存在 

073             if(is_file('Config.ini')){ 

074                 $FileCon = parse_ini_file('Config.ini'); 

075             }else{ 

076                 $FileName   =  basename($FileInfo['Content-Location']); 

077                 $FileConStr = "FileName  = {$FileName}rnFileUrl   = {$FileInfo['Content-Location']}rnFileSize   = {$FileInfo['Content-Length']}"; 

078                 $handle = fopen ('Config.ini', "wb");                                                                 // Config.ini文件不存在则创建文件 

079                 if (fwrite ($handle, $FileConStr) == FALSE) {                                                         // 数据写入文件  

080                     echo "File creation failed ...";  

081                 } 

082                 fclose ($handle);                                                                                     // 关闭一个已打开的文件指针 

083                 $FileCon = parse_ini_file('Config.ini'); 

084             } 

085             if(!empty($$this->dowUrl)){ 

086                 $fp = @fopen($$this->dowUrl, "rb");                                                                   // 二进制模式读取文件 

087                 if (!$fp) 

088                      exit("Download a mistake.nn"); 

089   

090                 // 输出远程资源 

091                 header("Content-type:text/html;charset=utf-8"); 

092                 header('Content-Description: File Transfer'); 

093                 header('Content-Type: application/octet-stream'); 

094                 header('Content-Disposition: attachment; filename='.$FileCon['FileName']); 

095                 header("Accept-Ranges: bytes"); 

096                 header('Content-Transfer-Encoding: binary'); 

097                 header('Expires: 0'); 

098                 header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); 

099                 header('Pragma: public'); 

100                 header('Content-Length: '.$FileCon['FileSize']); 

101                 while (!feof($fp)){ 

102                     set_time_limit(0);                                                                                 // 设置文件最长执行时间 

103                     echo fread($fp, 1024);                                                                             // 输出文件 

104                     flush();                                                                                           // 输出缓冲 

105                     ob_flush();                                                                                        // 输出缓冲区中的内容 

106                 } 

107                 fclose($fp); 

108             }else{ 

109                 header("HTTP/1.1 404 Not Found"); 

110             } 

111         }else{ 

112             header("HTTP/1.1 301 Moved Permanently"); 

113             header("Location: ".$this->Location); 

114         } 

115     } 

116 } 

117 // 远程资源地址 

118 $dowUrl = '/qq/QQ5.1/10055/QQ5.1.exe'; 

119 // 转跳地址 

120 $Location = 'http://www.111cn.net'; 

121 // 许可来路域名列表 

122 $allowUrl = array( 

123     'blog.emtalk.net', 

124 ); 

125 $BurglarDow = new BurglarDow($dowUrl,$Location,$allowUrl); 

126 $BurglarDow -> dow();

<?php
    header('content-type:text/html;charset=utf8');
    $curl = curl_init();
    $data = array('img'=>'@'. dirname(__FILE__).'/img/login.gif');
    curl_setopt($curl, CURLOPT_URL, "http://www.demo.com/uploadimg.php");
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_POST, true);
    curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
    $result = curl_exec($curl);
    curl_close($curl);
    echo json_decode($result);
?>

<?php
    if($_FILES)
    {
        $filename = $_FILES['img']['name'];
        $tmpname = $_FILES['img']['tmp_name'];
        if(move_uploaded_file($tmpname, dirname(__FILE__).'/img/'.$filename))
        {
            echo json_encode('上传成功');
        }
        else
        {
            $data = json_encode($_FILES);
            echo $data;
        }
    }
?>

<?php
$localfile = "php_homepage.txt";
$fp = fopen ($localfile, "r");
$arr_ip = gethostbyname(www.111cn.net);
echo $arr_ip;
$ftp = "ftp://".$arr_ip."/public_html/".$localfile; 
$ch = curl_init();
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_USERPWD, '***:****');
curl_setopt($ch, CURLOPT_URL, $ftp);
curl_setopt($ch, CURLOPT_PUT, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_INFILE, $fp);
curl_setopt($ch, CURLOPT_INFILESIZE, filesize($localfile));
$http_result = curl_exec($ch);
$error = curl_error($ch);
echo $error."<br>";
$http_code = curl_getinfo($ch ,CURLINFO_HTTP_CODE);curl_close($ch);
fclose($fp);
?>

<?php
$vname = 'test'; 
$vtel = '13800000000'; 
generateQRfromGoogle($vname,$vtel);

function generateQRfromGoogle($vname,$vtel,$widhtHeight ='150',$EC_level='L',$margin='0')
{
    if($vname&&$vtel){ 
       $chl = "BEGIN:VCARDnVERSION:3.0". //vcard头信息 
       "nFN:$vname". 
       "nTEL:$vtel". 
       "nEND:VCARD"; //vcard尾信息 
       echo '<img src="http://chart.apis.google.com/chart?chs='.$widhtHeight.'x'.$widhtHeight.'&cht=qr&chld='.$EC_level.'|'.$margin.'&chl='.urlencode($chl).'" alt="QR code" widhtHeight="'.$size.'" widhtHeight="'.$size.'"/>';
    }
}
?>

<?php
$url = "http://www.google.com.hk";
generateQRfromGoogle($url);

function generateQRfromGoogle($chl,$widhtHeight ='150',$EC_level='L',$margin='0')
{
       echo '<img src="http://chart.apis.google.com/chart?chs='.$widhtHeight.'x'.$widhtHeight.'&cht=qr&chld='.$EC_level.'|'.$margin.'&chl='.urlencode($chl).'" alt="QR code" widhtHeight="'.$size.'" widhtHeight="'.$size.'"/>';
}
?>

<select id="teId" name="te_id" onchange="getArea()">
   <option value="1000">--请选择分类--</option>
      <option value="1">房产知识</option>
      <option value="8">房屋买卖</option>
      <option value="16">法律法规</option>
      <option value="24">银行贷款</option>
      <option value="31">房产类型</option>
      <option value="40">装修风水</option>
      <option value="47">房产经纪</option>
      <option value="52">其他问题</option>
      <option value="54">楼盘问答</option>
     </select>
  <span id="teTid" ></span>
  <span></span>
  <select id="wealth" name="wealth">
   <option value="">--请选择悬赏积分--</option>
   <option value="0">我要给0</option>
   <option value="5">我要给5</option>
   <option value="15">我要给15</option>
   <option value="30">我要给30</option>
   <option value="50">我要给50</option>
  </select>

// 创建ajax引擎
 function getXmlHttpObject() {
  var xmlHttpRequest;

  if (window.ActiveXObject) {

   xmlHttpRequest = new ActiveXObject("Microsoft.XMLHTTP");
  } else {

  xmlHttpRequest = new XMLHttpRequest();
 }

 return xmlHttpRequest;
}

var myXmlHttpRequest = "";

function getArea(){
 //alert(ID('teId').value);
 myXmlHttpRequest = getXmlHttpObject();
 // 怎样判断是否可以www.111cn.net
 if (myXmlHttpRequest) {
  // post 发送数据
  var url = "ajax_tiwen.php";
  var date = "teId=" + ID('teId').value;

  myXmlHttpRequest.open("post", url, true);
 
  myXmlHttpRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded; charset=utf-8");
  myXmlHttpRequest.onreadystatechange = TiWen;
  myXmlHttpRequest.send(date);
 }
}