您好,欢迎访问一九零五行业门户网

Mysql存取session实例

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 恋太后天
*/
/*
* 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
//使用mysql存放session 函数表
// by 恋太后天 2005-4-28
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 `sessions` 
                           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 `sessions` (`id`, `expiry_time`,  `data`), $dbsess_link);
    if ( !$result )
    {
        $result = mysql_query(update `sessions` 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 `sessions` 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="http://www.php1.cn/">
?>
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="http://www.php1.cn/">
?>
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"]);
?>
其它类似信息

推荐信息