<?php
ini_set('session.save_handler','user');
session_set_save_handler("open", "close", "read", "write", "destroy", "gc");
function open () {
// 打开数据库链接 连接数据库
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
}
function close() {
// 关闭数据库链接
echo 'close';
}
//读session
function read($session_id) {
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
$sql="select * from session where session_id='{$session_id}'";
return $pdo->query($sql)->fetch();
}
//写session
function write ($session_id, $session_value) {
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
$session_maxtime=time();
$sql="replace into session (session_id,session_maxtime,session_value) values('{$session_id}','{$session_maxtime}','{$session_value}')";
$pdo->exec($sql);
}
function destroy($session_id) {
// 销毁指定session
$sql="delete from session where session_id='{$session_id}'";
$pdo->exec($sql);
}
function gc() {
// 删除所有过期的session
}
session_start();
$_SESSION['name']='chen';
ini_set('session.save_handler','user');
session_set_save_handler("open", "close", "read", "write", "destroy", "gc");
function open () {
// 打开数据库链接 连接数据库
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
}
function close() {
// 关闭数据库链接
echo 'close';
}
//读session
function read($session_id) {
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
$sql="select * from session where session_id='{$session_id}'";
return $pdo->query($sql)->fetch();
}
//写session
function write ($session_id, $session_value) {
$pdo=new PDO('mysql:host=localhost;dbname=study10','root','root');
$pdo->exec('set names utf8');
$session_maxtime=time();
$sql="replace into session (session_id,session_maxtime,session_value) values('{$session_id}','{$session_maxtime}','{$session_value}')";
$pdo->exec($sql);
}
function destroy($session_id) {
// 销毁指定session
$sql="delete from session where session_id='{$session_id}'";
$pdo->exec($sql);
}
function gc() {
// 删除所有过期的session
}
session_start();
$_SESSION['name']='chen';