久久福利_99r_国产日韩在线视频_直接看av的网站_中文欧美日韩_久久一

您的位置:首頁技術(shù)文章
文章詳情頁

Mysql存取session實例

瀏覽:4日期:2023-10-26 18:17:59

files:common/Common.config.phpinclude/session.inc.phpsession_test.phpget_session_test.phpget_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 函數(shù)表// 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 sessioninclude ('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.gepszalag.com/bcjs/get_session_test.php'>click me</a>';

?>

get_session_test.php

<?php// test for using sessioninclude ('common/Common.config.php');include ('include/session.inc.php');

session_start();/** www.mypchelp.cn*/$_SESSION['c'] = '<br>C: I will follow U. ^0^!';print($_SESSION['abc']);print('<br>');print($_SESSION['meto']);echo '<br>'. '<a href='http://www.gepszalag.com/bcjs/get_session_test2.php'>click again</a>';

?>

get_session_test2.php

<?php//get_session_test2.php// test for using sessioninclude ('common/Common.config.php');include ('include/session.inc.php');

session_start();print($_SESSION['c']);?>

標(biāo)簽: MySQL 數(shù)據(jù)庫
主站蜘蛛池模板: 亚洲精品国产成人 | 精品久久久久久久久久久久久久 | 特大毛片 | 麻豆免费短视频 | 999这里只有是极品 免费的一级黄色片 | 国产欧精精久久久久久久 | 午夜草民福利电影 | 成人免费一区二区三区视频网站 | 欧美另类国产 | 君岛美绪一区二区三区 | 夜夜操com | 一区二区三区在线播放 | 国产精品久久久久aaaa九色 | 国产免费黄色 | 欧美成人精品一区二区 | 国产一区二区三区免费观看 | 国产精品美女久久久久久免费 | 精品国产乱码久久久久久闺蜜 | porn在线视频 | 黄色一级片免费播放 | 亚洲国产高清在线 | 狠久久| 成人精品免费视频 | 久久成人一区 | 亚洲欧美日韩精品 | 欧美日韩精品一二区 | 免费福利视频一区二区三区 | 欧美日韩在线一区二区三区 | 国产一区在线观看视频 | 91精品国产色综合久久 | 网站av| 黄色影视网址 | 久久久久久网站 | 亚洲欧洲一区二区 | www国产在线观看 | 国产一区不卡 | 亚洲精品乱码久久久久久蜜糖图片 | 欧美精品一二三 | 欧美专区在线 | 国产综合久久久 | 欧美一区二区三区电影 |