PHP uses MySQL to manage Session callback Functions

Copy codeThe Code is 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 is written out before classes are destroyed
// (See http://bugs.php.net/bug.php? Id = 33772 for details)
@ Session_write_close ();
} // _ Destruct
}
?>