Put the session into MySQL

Session is usually placed in the/tmp directory, and the folder's permissions are everbody readable, this is very scary! School Forum once someone through the session to steal account! So then try to put the session into the database, the table structure and process as follows:
Create a table
Create Sesslib.sql
CREATE TABLE Sesslib (
Data text,
Time datetime,
ID int (one) DEFAULT ' 0 ' not NULL auto_increment,
Sid varchar Not NULL,
PRIMARY KEY (ID),
UNIQUE sid (SID)
);
End
Xx.php customized the session's database path, and when a page needs to use//session, you can include this section, using the following method:
?
Include "xx.php";//xx.php
Session_Start ();
The following session will be used normally
?>
/******************************************************/
xx.php content:
/*****************************************************/
?
$sess _dbh= "";
$sess _maxlifetime=get_cfg_var ("Session.gc_maxlifetime");
function Sess_open ($save _path, $session _name) {
Global $hostname, $dbusername, $dbpassword, $dbname, $sess _dbh;

$sess _dbh=mysql_pconnect ($hostname, $dbusername, $dbpassword) or Die ("Cannot connect to the database!") ");
$sess _dbh=mysql_pconnect (' localhost ', ' test ', ' test ') or Die ("Cannot connect to the database!") ");
mysql_select_db ("$dbname") or Die ("Cannot select a database!") ");
mysql_select_db (' test ') or Die ("Cannot select a database!") ");
return (true);
}
function Sess_close () {
Mysql_close ();
return (true);
}
function Sess_read ($SID) {
Global $sess _DBH;
$result = mysql_query ("Select data from Sesslib where sid= ' $sid '", $sess _DBH);