| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> 使用session_set_save_handler函数重载SESSION存储方式之MYSQL shi yong session_set_save_handler han shu chong zai SESSION cun chu fang shi zhi MYSQL
 

使用session_set_save_handler函数重载SESSION存储方式之MYSQL

2008-12-22 08:09:09 编辑來源:互联网 繁體版 评论
 
 
本文为【使用session_set_save_handler函数重载SESSION存储方式之MYSQL】的汉字拼音对照版显示拼音
  <?

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

   ?>原文】【拼音
 
 
 
 
上一篇《优化使用mysql存储session》
下一篇《MySQL数据库索引查询优化的分享》
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
<? $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(); ?>
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
华丽的模特拍摄(8)
华丽的模特拍摄(7)
华丽的模特拍摄(6)
华丽的模特拍摄(5)
八里沟
朝阳宫
天下峨眉 云上金顶
老家(四)
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有