session存储到mysql数据库_MySQL

根据qq互联中的session类和php官方上的例子，整理

<?phpini_set (&#39;error_reporting&#39;,E_ALL);ini_set(&#39;display_errors&#39;,TRUE);class session{const db_host = &#39;127.0.0.1&#39;;const db_user = &#39;root&#39;;const db_password =&#39;&#39;;const db_name = &#39;test&#39;;const db_table = &#39;tbl_session&#39;;private $lifetime;private $dbHandle;function open($path,$id){  $con = @mysql_connect(self::db_host,self::db_user,self::db_password);  $sel = @mysql_select_db(self::db_name,$con);  $this->lifetime = get_cfg_var("session.gc_maxlifetime");  $this-&gt;dbHandle = $con;  if(!$con || !$sel)      return false;      return true; }function close(){    $this-&gt;gc($this-&gt;lifetime);  return @mysql_close($this-&gt;dbHandle);}function read($id){   $rs = @mysql_query("select session_data data from ".self::db_table." where session_expires dbHandle);    $row = @mysql_fetch_assoc($rs); return $row?$row['data']:'';}function write($id,$data){ $newEXP = time()+ ini_get("session.gc_maxlifetime");   $sel = mysql_query("select * from ".self::db_table." where session_id= '".$id."'",$this-&gt;dbHandle);   if(mysql_affected_rows($this-&gt;dbHandle)){     $rs = @mysql_query("update ".self::db_table." set session_data = '".$data."', session_expires = '".$newEXP."' WHERE session_id = '".$id."'",$this-&gt;dbHandle);     if(@mysql_affected_rows($this-&gt;dbHandle))        return true;   }else{     $rs = @mysql_query("insert into ".self::db_table." (session_id,session_data,session_expires)values('".$id."','".$data."','".$newEXP."')",$this-&gt;dbHandle);    if(@mysql_affected_rows($rs))       return true;   }   return false;}function destroy($id){    @mysql_query("delete from ".self::db_table." where session_id = '".$id."'",$this-&gt;dbHandle);}function gc($lifetime){    @mysql_query("delete from ".self::db_table." where sessoin_expires &gt; '".time()."'",$this-&gt;dbHandle);}}$session = new session();session_set_save_handler(array(&amp;$session,'open'),array(&amp;$session,'close'),array(&amp;$session,'read'),array(&amp;$session,'write'),array(&amp;$session,'destroy'),array(&amp;$session,'gc'));session_start();