国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

使用session_set_save_handler函數重載SESSION存儲方式之MYSQL

2019-11-17 04:24:01
字體:
來源:轉載
供稿:網友

<?
   $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();
   ?>


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 平顺县| 炉霍县| 香河县| 萨嘎县| 太仆寺旗| 辉南县| 左权县| 莫力| 永康市| 林西县| 鲁甸县| 辉南县| 土默特左旗| 大同市| 尚义县| 运城市| 贡觉县| 京山县| 庐江县| 孟津县| 梁山县| 蒙山县| 锡林郭勒盟| 巴彦淖尔市| 昭苏县| 两当县| 福鼎市| 宁南县| 隆化县| 高邑县| 怀化市| 杭锦后旗| 蓝山县| 太和县| 雷波县| 永吉县| 英德市| 金秀| 白城市| 如皋市| 广昌县|