php中把session保存到MySQL数据库中示例

<?php
/**
 * SessionMysql 数据库存储类
 */

defined('IN_QIAN') or exit('Access Denied');

class SessionMysql {

 public $lifetime = 1800; // 有效期，单位：秒（s），默认30分钟
 public $db;
 public $table;

 /**
  * 构造函数
  */
 public function __construct() {
  $this->db = Base::loadModel('SessionModel');
  $this->lifetime = Base::loadConfig('system', 'session_lifetime');
  session_set_save_handler(
   array(&$this, 'open'),  // 在运行session_start()时执行
   array(&$this, 'close'),  // 在脚本执行完成 或 调用session_write_close() 或 session_destroy()时被执行，即在所有session操作完后被执行
   array(&$this, 'read'),  // 在运行session_start()时执行，因为在session_start时，会去read当前session数据
   array(&$this, 'write'),  // 此方法在脚本结束和使用session_write_close()强制提交SESSION数据时执行
   array(&$this, 'destroy'), // 在运行session_destroy()时执行
   array(&$this, 'gc')   // 执行概率由session.gc_probability 和 session.gc_divisor的值决定，时机是在open，read之后，session_start会相继执行open，read和gc
  );
  session_start(); // 这也是必须的，打开session，必须在session_set_save_handler后面执行
 }
 /**
  * session_set_save_handler open方法
  *
  * @param $savePath
  * @param $sessionName
  * @return true
  */
 public function open($savePath, $sessionName) {
  return true;
 }
 /**
  * session_set_save_handler close方法
  *
  * @return bool
  */
 public function close() {
  return $this->gc($this->lifetime);
 }
 /**
  * 读取session_id
  *
  * session_set_save_handler read方法
  * @return string 读取session_id
  */
 public function read($sessionId) {
  $condition = array(
   'where' => array(
    'session_id' => $sessionId
   ),
   'fields' => 'data'
  );
  $row = $this->db->fetchFirst($condition);
  return $row ? $row['data'] : '';
 }
 /**
  * 写入session_id 的值
  *
  * @param $sessionId 会话ID
  * @param $data 值
  * @return mixed query 执行结果
  */
 public function write($sessionId, $data) {
  $userId = isset($_SESSION['userId']) ? $_SESSION['userId'] : 0;
  $roleId = isset($_SESSION['roleId']) ? $_SESSION['roleId'] : 0;
  $grouId = isset($_SESSION['grouId']) ? $_SESSION['grouId'] : 0;
  $m = defined('ROUTE_M') ? ROUTE_M : '';
  $c = defined('ROUTE_C') ? ROUTE_C : '';
  $a = defined('ROUTE_A') ? ROUTE_A : '';
  if (strlen($data) > 255) {
   $data = '';
  }
  $ip = get_ip();
  $sessionData = array(
   'session_id' => $sessionId,
   'user_id'  => $userId,
   'ip'   => $ip,
   'last_visit' => SYS_TIME,
   'role_id'  => $roleId,
   'group_id'  => $grouId,
   'm'    => $m,
   'c'    => $c,
   'a'    => $a,
   'data'   => $data,
  );
  return $this->db->insert($sessionData, 1, 1);
 }
 /**
  * 删除指定的session_id
  *
  * @param string $sessionId 会话ID
  * @return bool
  */
 public function destroy($sessionId) {
  return $this->db->delete(array('session_id' => $sessionId));
 }
 /**
  * 删除过期的 session
  *
  * @param $lifetime session有效期（单位：秒）
  * @return bool
 */
 public function gc($lifetime) {
  $expireTime = SYS_TIME - $lifetime;
  return $this->db->delete("`last_visit`<$expireTime");
 }
}

<?php
function Thunder($url, $type='en') {
$url ='http://www.111cn.net';
if($type =='en'){
return "thunder://".base64_encode("AA".$url."ZZ");
}else{
return substr(base64_decode(substr(trim($url),10)),2,-2);
}
}

$url ='http://www.111cn.net';
echo Thunder($url);

输出结果

thunder://QUFodHRwOi8vd3d3LjExMWNuLm5ldFpa
 
?>

//获取指定日期所在月的第一天和最后一天
 function GetTheMonth($date){
 $firstday = date("Y-m-01",strtotime($date));
 $lastday = date("Y-m-d",strtotime("$firstday +1 month -1 day"));
 return array($firstday,$lastday);
}

function getdays($day){
$lastday=date('Y-m-d',strtotime("$day Sunday"));
$firstday=date('Y-m-d',strtotime("$lastday -6 days"));
return array($firstday,$lastday);
}
print_r(getdays('2012-06-2'));

$date= 要处理的日期 
* $step  0= 本月   ,正负表示得到本月前后的月份日期
 * $date= 要处理的月份
 * Enter description here ...
 */
function AssignTabMonth($date,$step){
$date= date("Y-m-d",strtotime($step." months",strtotime($date)));//得到处理后的日期（得到前后月份的日期） 
$u_date = strtotime($date);
$days=date("t",$u_date);// 得到结果月份的天数

//月份第一天的日期
$first_date=date("Y-m",$u_date).'-01';
for($i=0;$i<$days;$i++){
$for_day=date("Y-m-d",strtotime($first_date)+($i*3600*24));
}
return $first_date.'至'.$for_day;

/**
* 发送soap请求
*/
private function _soap()
{
$client = new SoapClient($this->serviceUrl);
$info = new stdClass();
$info->arg0 = $this->xml;
$param = array($info);
$response = $client->__call(“sfexpressService”,$param);
return $response->return ;
}

/**
* 拼接出请求的xml
*/
public function createXml()
{
$xml = ‘
’.$this->user.’,’.$this->passWord.’

invoice_no.’” />

’;
$this->xml = $xml;
}

#!/usr/bin/php -q
<?php
 
start: fwrite(STDOUT,"===========Vhost Script===========＼n");
fwrite(STDOUT,"= Choose an operation ＼n");
fwrite(STDOUT,"= 1.Create 2.Delete 3.Exit＼n");
fwrite(STDOUT,"==================================＼n");
$operate = trim(fgets(STDIN));
if ( $operate == 1  ){
fwrite(STDOUT,"Please Enter a  Domain Name:");
$domain = trim(fgets(STDIN));
$path = "/home/sites/{$domain}";
$nginx_conf = "/etc/nginx/sites/{$domain}";
$nginx_template = "/etc/nginx/template/site_conf";
$apache_conf = "/etc/httpd/conf/httpd.conf";
$conf_str = "";
 
//变量初始化
 
if( file_exists($path ) ) exit ("Domain Existed!＼n");
else mkdir($path,0700);
if(file_exists($nginx_conf)) exit ("Nginx Config file existed!＼n");
else {
    $conf_str = file_get_contents( $nginx_template );
}
 
//目录检测及配置文件拷贝
 
eval ( "＼$conf_str = ＼"$conf_str＼";" );
 
$succes = file_put_contents($nginx_conf,$conf_str);
if( !$succes ) exit ("Write Config File Fauile!");
else echo "Create Vhost success!＼n";
goto start;
//写入配置文件
}
else if ($operate == 2){
    $confs_dir = dir("/etc/nginx/sites");
    $confs_list = array();
    $count = 0;
    while ( false !== ( $conf_file = $confs_dir->read() ) ){
        if( $conf_file == "." ) continue;
        if( $conf_file == ".." ) continue;
        if ( is_file( $confs_dir->path ."/". $conf_file) ) {
            $confs_list[$count++] =  $conf_file;
        }
    }
    echo "Select a site by number which to delete:＼n";
    if( count( $confs_list ) >0 )
        foreach ( $confs_list as $k=>$v ){
            echo "{$k}. $v＼n";
        }
    $index = trim(fgets(STDIN));
    if( in_array ( $index,array_keys( $confs_list ) ) ){
        copy(  $confs_dir->path ."/". $confs_list[$index],"/etc/nginx/backup/{$confs_list[$index]}" );
        unlink ( $confs_dir->path ."/". $confs_list[$index] );
        exec("tar -zcf  /home/sites/{$confs_list[$index]}.tar.gz /home/sites/".$confs_list[$index] );
        exec("rm -Rf /home/sites/".$confs_list[$index]);
    }
    //删除指定配置，并保存备份
}
else if( $operate == 3 ) {
    exit;
}
else {
 exit ("No Operation Selected!");
}?>

server {
listen 80;
server_name {$domain};
access_log /var/log/nginx/{$domain}_access_log;
error_log /var/log/nginx/{$domain}_error_log;

root {$path};

#不记录对站点图标访问
location = /favicon.ico {
log_not_found off;
access_log off;
}

#不记录对robots.txt的访问
location = /robots.txt {
allow all;
log_not_found off;
access_log off;
}

location = / {
try_files @proxy;
}

location / {
index index.htm index.html index.php;
try_files ＼$uri @proxy;
}

#匹配html
location ~* ＼.(html|htm)$ {
expires 30s;
gzip off;
add_header Content-Encoding gzip;
try_files ＼$uri ＼$uri/ /wp-content/cache/supercache/＼$http_host/＼$request_uri/index.html.gz @proxy;
}

#匹配图片、脚本文件等
location ~* ＼.(jpe?g|gif|png|ico|css|js|flv|swf|avi|zip|rar|svg|tgz|gz|rar|bz2|doc|xls|exe|pdf|ppt|txt|tar|mp3)$ {
expires 30d;
}

#传递给apache
location @proxy {
index index.htm index.html index.php;
proxy_pass   http://127.0.0.1:81;
include /etc/nginx/proxy.conf;
}
}