User-define-session-inc.php file code:
Copy codeThe Code is as follows:
<? Php
Function mysession_open ($ save_path, $ session_name)
{
@ Mysql_connect ("localhost", "root", "1981427") // You must connect to the database server before selecting a database.
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("the database does not exist or is unavailable ");
Return true;
}
Function mysession_close ()
{
Return true;
}
Function mysession_read ($ key)
{
@ Mysql_connect ("localhost", "root", "1981427") // You must connect to the database server before selecting a database.
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("the database does not exist or is unavailable ");
$ Expiry_time = time (); // get the Session expiration time
// Execute an SQL statement to obtain the Session Value
$ Query = @ mysql_query ("select session_data from mysession"
. "Where session_key = '$ key' and session_expiry> $ expiry_time ")
Or die ("SQL statement execution failed ");
If ($ row = mysql_fetch_array ($ query ))
Return $ row ['session _ data'];
Else
Return false;
}
Function mysession_write ($ key, $ data)
{
@ Mysql_connect ("localhost", "root", "1981427") // You must connect to the database server before selecting a database.
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("the database does not exist or is unavailable ");
$ Expiry_time = time () + 1200; // get the Session expiration time
// Query whether the Session key value already exists
$ Query = @ mysql_query ("select session_data from mysession"
. "Where session_key = '$ key '")
Or die ("SQL statement execution failed ");
// If the data does not exist, insert the data; otherwise, update the data.
If (mysql_numrows ($ query) = 0)
{
// Execute the SQL statement to insert the Session Value
$ Query = @ mysql_query ("insert into mysession values ('$ key',' $ data', $ expiry_time )")
Or die ("SQL statement execution failed ");
}
Else
{
// Execute an SQL statement to update the Session Value
$ Query = @ mysql_query ("update mysession set"
. "Session_data = '$ data', session_expiry = $ expiry_time"
. "Where session_key = '$ key '")
Or die ("SQL statement execution failed ");
}
Return $ query;
}
Function mysession_destroy ($ key)
{
@ Mysql_connect ("localhost", "root", "1981427") // You must connect to the database server before selecting a database.
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("the database does not exist or is unavailable ");
// Execute the SQL statement to delete the Session
$ Query = @ mysql_query ("delete from mysession where session_key = '$ key '")
Or die ("SQL statement execution failed ");
Return $ query;
}
Function mysession_gc ($ expiry_time)
{
@ Mysql_connect ("localhost", "root", "1981427") // You must connect to the database server before selecting a database.
Or die ("database server connection failed ");
@ Mysql_select_db ("test") // select the database mydb
Or die ("the database does not exist or is unavailable ");
$ Expiry_time = time ();
// Execute the SQL statement to delete the Session
$ Query = @ mysql_query ("delete from mysession where session_expiry <$ expiry_time ")
Or die ("SQL statement execution failed ");
Return $ query;
}
// Set custom Session Storage
Session_set_save_handler ('mysession _ open ',
'Mysession _ close ',
'Mysession _ read ',
'Mysession _ write ',
'Mysession _ destroy ',
'Mysession _ gc ');
?>
Copy codeThe Code is as follows:
<? Php
Include ('user-define-session-inc.php '); // contains the file defined by session_set_save_handler
Session_start ();
$ _ SESSION ['username'] = "zhuzhao ";
$ _ SESSION ['Password'] = "123456 ";
?>
Copy codeThe Code is as follows:
<? Php
Include ('user-define-session-inc.php '); // contains the file defined by session_set_save_handler
Session_start ();
Echo "UserName:". $ _ SESSION ['username']. "<BR> ";
Echo "PassWord:". $ _ SESSION ['Password']. "<BR> ";
?>