Mysql存取session实例_PHP
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Mysql存取session实例_PHP,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3324字,纯文字阅读大概需要5分钟。
内容图文
files:common/Common.config.php
include/session.inc.php
session_test.php
get_session_test.php
get_session_test2.php
Common.config.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
//使用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:Can not connect to Mysql server.");
$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
// 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 "click me";
?>
get_session_test.php
// test for using session
include ("common/Common.config.php");
include ("include/session.inc.php");
session_start();
/*
* www.knowsky.com
*/
$_SESSION["c"] = "
C: I will follow U. ^0^!";
print($_SESSION["abc"]);
print("
");
print($_SESSION["meto"]);
echo "
".
"click again";
?>
get_session_test2.php
//get_session_test2.php
// test for using session
include ("common/Common.config.php");
include ("include/session.inc.php");
session_start();
print($_SESSION["c"]);
?>
内容总结
以上是互联网集市为您收集整理的Mysql存取session实例_PHP全部内容,希望文章能够帮你解决Mysql存取session实例_PHP所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。