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

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

Mysql存取session實(shí)例

瀏覽:8日期: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ù)庫
主站蜘蛛池模板: 免费看国产片在线观看 | 久久不卡| 日日碰碰| 久久国产精品一区 | 看黄色.com| 国产成人精品一区二 | 一区二区久久 | 国产成人综合一区二区三区 | 日韩在线视频一区 | 亚洲一区二区中文 | 亚洲免费在线观看 | 欧美一级片免费播放 | 国产一区二区三区四区三区 | 欧美日韩在线第一页 | av网站网址| 91电影院| 日韩视频一| 一区二区福利 | 一区二区三区精品视频 | 国产成人精品免费 | 日本久久精品一区二区 | 九色91视频 | 天天干夜夜操 | 欧美精品一区在线 | 日韩一区二区三区在线视频 | 国产亚洲精品成人av久久ww | 日韩欧美在线一区二区 | 国产专区在线视频 | 五月婷综合 | 久久伊人久久 | 伊人免费视频 | 亚洲aaa在线观看 | 狠狠天天| 拍真实国产伦偷精品 | 成人午夜精品久久久久久久3d | 九九成人| 中文字幕av网 | 日本久久久久 | 欧美日韩高清一区 | 国产美女一区 | 中文字幕亚洲精品 |