国产成人精品亚洲777人妖,欧美日韩精品一区视频,最新亚洲国产,国产乱码精品一区二区亚洲

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

使用session_set_save_handler函數(shù)重載SESSION存儲(chǔ)方式之MYSQL

瀏覽:144日期:2023-10-26 19:33:49

<? $DB_SERVER = 'server'; /* database server hostname */ $DB_NAME = 'dbname'; /* database name */ $DB_USER = 'root'; /* database user */ $DB_PASS = '*************'; /* database password */

$DB_SELECT_DB = ''; $SESS_LIFE = get_cfg_var('session.gc_maxlifetime');

function sess_open($save_path, $session_name) { global $DB_SERVER, $DB_NAME, $DB_USER, $DB_PASS, $DB_SELECT_DB;

if (! $DB_SELECT_DB = mysql_pconnect($DB_SERVER, $DB_USER, $DB_PASS)) { echo 'SORRY! MYSQL ERROR : Can't connect to $DB_SERVER as $DB_USER'; echo 'MySQL Error: ', mysql_error(); die; }

if (! mysql_select_db($DB_NAME, $DB_SELECT_DB)) { echo 'SORRY! MYSQL ERROR : Unable to select database $DB_NAME'; die; }

return true; }

function sess_close() { return true; }

function sess_read($SessionKey){global $DB_SELECT_DB, $SESS_LIFE;$Query = 'SELECT SessionArray FROM cdb_global_sessions WHERE SessionKey = ''.$SessionKey.'' AND SessionExpTime > ' . time();$Result = mysql_query($Query, $DB_SELECT_DB);

if (list($SessionArray) = mysql_fetch_row($Result)) { return $SessionArray; }

return false; }

function sess_write($SessionKey, $VArray) { global $DB_SELECT_DB, $SESS_LIFE;

$SessionExpTime = time() + $SESS_LIFE; $SessionArray = addslashes($VArray);

$Query = 'INSERT INTO cdb_global_sessions (SessionKey,SessionExpTime,SessionArray) VALUES (''.$SessionKey.'',''.$SessionExpTime.'',''.$SessionArray.'')'; $Result = mysql_query($Query, $DB_SELECT_DB);

if (!$Result){ $Query = 'UPDATE cdb_global_sessions SET SessionExpTime = ''.$SessionExpTime.'', SessionArray = ''.$SessionArray.'' WHERE SessionKey = ''.$SessionKey.'' AND SessionExpTime > ' . time(); $Result = mysql_query($Query, $DB_SELECT_DB); } return $Result; }

function sess_destroy($SessionKey) { global $DB_SELECT_DB;

$Query = 'DELETE FROM cdb_global_sessions WHERE SessionKey = ''.$SessionKey.'''; $Result = mysql_query($Query, $DB_SELECT_DB);

return $Result; }

function sess_gc($maxlifetime) { global $DB_SELECT_DB;

$Query = 'DELETE FROM cdb_global_sessions WHERE SessionExpTime < ' . time(); $Result = mysql_query($Query, $DB_SELECT_DB);

return mysql_affected_rows($DB_SELECT_DB); }

session_set_save_handler( 'sess_open', 'sess_close', 'sess_read', 'sess_write', 'sess_destroy', 'sess_gc');

session_start(); ?>

標(biāo)簽: MySQL 數(shù)據(jù)庫(kù)
主站蜘蛛池模板: 卢湾区| 阜宁县| 镇宁| 阿勒泰市| 镇原县| 正安县| 轮台县| 邢台市| 枣强县| 宝坻区| 民和| 万源市| 西昌市| 遂昌县| 浦城县| 英吉沙县| 峨眉山市| 政和县| 南岸区| 喀什市| 仁布县| 云和县| 刚察县| 炎陵县| 紫阳县| 汉沽区| 灌云县| 桃园市| 碌曲县| 永吉县| 当阳市| 乾安县| 寿阳县| 安丘市| 达拉特旗| 武定县| 石屏县| 长治市| 海晏县| 安塞县| 虎林市|