Mysql Access session instance

Files:
Common/Common. config. php
Include/session. inc. php
Session_test.php
Get_session_test.php
Get_session_test2.php

Common. config. php

<? Php
/*
* Common config
* By the day after my fall in love
*/

/*
* Database config
*/
Define ("DBTYPE", "mysql ");
$ Database = array
(
"Mysql" => array
(
"Default" => array
(
"Host" => "localhost ",
"User" => "root ",
"Password" => "",
"Dbname" => ""
),
"Session" => array
(
"Host" => "localhost ",
"User" => "session ",
"Password" => "session ",
"Dbname" => "sessions"
)
)
);

?>

Session. inc. php

 
<? Php
// Use mysql to store the session function table
// By: the day after my fall in love

If (! Isset ($ include_path) $ include_path =;

If (! Is_array ($ database ))
{
Include ($ include_path. "common/Common. config. php ");
}

$ DBsess = $ database [DBTYPE] ["session"];
$ DBsess_link = mysql_connect ($ DBsess ["host"], $ DBsess ["user"], $ DBsess ["password"])
Or die ("Error: <em> Can not connect to Mysql server. </em> ");

$ SESS_LIFE = get_cfg_var ("session. gc_maxlifetime ");

Function sess_open ($ path, $ name)
{
Return true;
}

Function sess_close ()
{
Return true;
}

Function sess_read ($ id)
{
Global $ DBsess, $ DBsess_link;
Mysql_select_db ($ DBsess ["dbname"]);
$ Now = time ();
$ Result = mysql_query ("SELECT 'data' FROM 'session'
WHERE 'id' = $ id AND 'expiry _ time'> $ now ", $ DBsess_link );
If (list ($ data) = mysql_fetch_row ($ result ))
{
Return $ data;
}
Return false;
}

Function sess_write ($ id, $ data)
{
Global $ DBsess, $ DBsess_link, $ SESS_LIFE;
Mysql_select_db ($ DBsess ["dbname"]);

$ Expiry_time = time () + $ SESS_LIFE;

If (! Get_magic_quotes_gpc ())
{
$ Data = addslashes ($ data );
}

$ Now = time ();

$ Result = mysql_query ("INSERT into 'session' ('id', 'expiry _ time', 'data')", $ DBsess_link );

If (! $ Result)
{
$ Result = mysql_query ("UPDATE 'session' SET 'data' = $ data, 'expiry _ time' = $ expiry_time
WHERE 'id' = $ id AND 'expiry _ time'> $ now ", $ DBsess_link );
}

Return $ result;
}

Function sess_destroy ($ id)
{
Global $ DBsess, $ DBsess_link;
Mysql_select_db ($ DBsess ["dbname"]);
$ Query = mysql_query ("delete from 'session 'WHERE 'id' = $ id ");
Return $ query;
}

Function sess_gc ($ maxlifetime)
{
Global $ DBsess, $ DBsess_link;
$ Query = mysql_query ("delete from 'session' WHERE 'expiry _ time' <". time (), $ DBsess_link );
Return mysql_affected_rows ($ DBsess_link );

}

Session_module_name ();
Session_set_save_handler ("sess_open", "sess_close", "sess_read", "sess_write", "sess_destroy", "sess_gc ");

?>

Session_test.php

<? Php
// Test for using session
Include ("common/Common. config. php ");
Include ("include/session. inc. php ");

Session_start ();

$ _ SESSION ["abc"] = "A: I will be back! ";
$ _ SESSION ["meto"] = "B: Me too ";
Echo "<a href =" get_session_test.php "> click me </a> ";

?>

Get_session_test.php

<? Php
// Test for using session
Include ("common/Common. config. php ");
Include ("include/session. inc. php ");

Session_start ();
/*
* Www.knowsky.com
*/
$ _ SESSION ["c"] = "<br> C: I will follow U. ^ 0 ^! ";
Print ($ _ SESSION ["abc"]);
Print ("<br> ");
Print ($ _ SESSION ["meto"]);
Echo "<br> ".
"<A href =" get_session_test2.php "> click again </a> ";

?>

Get_session_test2.php

<? Php
// Get_session_test2.php
// Test for using session
Include ("common/Common. config. php ");
Include ("include/session. inc. php ");

Session_start ();
Print ($ _ SESSION ["c"]);
?>