Copy Code code as follows:
<?php
Class MySession extends Dbsql {
/**
* __CONSTRUCT ()
*/
Public Function __construct () {
Parent::__construct ();
}
/**
* Open ()
*
* @param <String> $sSavePath
* @param <String> $sSessionNames
*
* @return <Boolean> True
*/
Public function open ($sSavePath, $sSessionName) {
return true;
}
/**
* Close ()
*/
Public function Close () {
return true;
}
/**
* Read ()
*
* @param <String> $sSessionId
* @return <String> session data or NULL on error ...
*/
Public function Read ($sSessionId) {
$sSessionId = Addslashes (Trim ($sSessionId));
$SSQL = "SELECT * from tb_session WHERE F_sessionid = ' {$sSessionId} '";
Echo $sSql;
if (false!= ($result = $this->select ($sSql)) {
Var_dump ($result [0][' F_sessiondata ']);
return $result [0][' F_sessiondata '];
} else {
Return ";
}
}
/**
* Write ()
*
* @param <String> $SessionId
* @param <String> $sSessionData
*
* @return <Boolean> True or False
*/
Public function Write ($sSessionId, $sSessionData) {
$arrSession = Array ();
$arrSession [' f_sessionid '] = addslashes (Trim ($sSessionId));
$arrSession [' f_sessiondata '] = addslashes ($sSessionData);
$arrSession [' f_sessioncreated '] = Date ("y-m-d h:i:s");
$arrSession [' f_sessionupdated '] = Date ("Y-m-d h:i:s", time () + 1440);
New session and updated session
if (false!= ($result = $this->insertdata (' tb_session ', $arrSession)) {
return true;
} else {
$arrUpdateSession = Array ();
$arrUpdateSession [' f_sessiondata '] = addslashes ($sSessionData);
$arrUpdateSession [' f_sessionupdated '] = Date ("Y-m-d h:i:s", time () + 1440);
if (false!= ($result = $this->updatedata (' tb_session ', ' "'. Addslashes ($sSessionId)." ' ", ' F_sessionid ', $ arrupdatesession))) {
return true;
} else {
return false;
}
}
}
/**
* Destroy ()
*
* @param <String> $sSessionId
* @return <Boolean> True
*/
Public function Destroy ($SSESSIONID) {
$sSessionId = Addslashes (Trim ($sSessionId));
$this->deldata ($sSessionId, ' F_sessionid ', ' tb_session ');
return true;
}
/**
* GC
*
* @param <int> $nMaxLifeTime seconds
*
* @return <Boolean> True
*/
Public Function GC ($NMAXLIFETIME) {
$dtExpiredTime = Date ("Y-m-d h:i:s", Time ()-$nMaxLifeTime);
$SSQL = "DELETE from tb_session WHERE f_sessionupdated < {$dtExpiredTime}";
Echo $sSql;
$this->delete ($SSQL);
return true;
}
/**
* __DESCTRUCT ()
*
*/
function __destruct () {
Ensure session data are written out before classes are destroyed
(http://bugs.php.net/bug.php?id=33772 for details)
@session_write_close ();
}//__destruct
}
?>