Session保存到数据库的php类分享

复制代码 代码如下:

<?php

class ssiontodb

{

private $_path = null;

private $_name = null;

private $_pdo = null;

private $_ip = null;

private $_maxlifetime = 0;

public function __construct(pdo $pdo)

{

ssion_t_save_handler(

array(&$this, ‘open’),

array(&$this, ‘clo’),

array(&$this, ‘read’),

array(&$this, R校园笑话大全201316;write’),

array(&$this, ‘destroy’),

array(&$this, ‘gc’)

);

$this->_pdo = $pdo;

$this->_ip = !empty($_rver[‘remote_addr’]) ? $_rver[‘remote_addr’] : null;

$this->_maxlifetime = ini_get(‘ssion.gc_maxlifetime’);

}

public function open($path,$name)

{

return true;2020高考录取通知何时公布

}

public function clo()

{

return true;

}

public function read($id)

{

$sql = ‘lect * from ssion where phpssid = ?’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array($id));

if (!$result = $stmt->fetch(pdo::fetch_assoc)) {

return null;

} elif ($this->_ip != $result[‘client_ip’]) {

return null;

} elif ($result[‘update_time’]+$this->佐藤美和子_maxlifetime < time()){

$this->destroy($id);

return null;

} el {

return汤圆的做法 $result[‘data’];

}

}

public function write($id,$data)

{

$sql = ‘lect * from ssion where phpssid = ?’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array($id));

if ($result = $stmt->fetch(pdo::fetch_assoc)) {

if ($result[‘data’] != $data) {

$sql = ‘update ssion t update_time =? , date = ? whe品牌标语re phpssid = ?’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array(time(), $data, $id));

}

} el {

if (!empty($data)) {

$sql = ‘inrt into ssion (phpssid, update_time, client_ip, data) values (?,?,?,?)’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array($id, time(), $this->_ip, $data));

}

}

return true;

}

public function destroy($id)

{

$sql = ‘delete from ssion where phpssid = ?’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array($id));

return true;

}

public function gc($maxlifetime)

{

$sql = ‘delete from ssion where update_time < ?’;

$stmt = $this->_pdo->prepare($sql);

$stmt->execute(array(time() – $maxlifetime));

return true;

}

}

try{

$pdo = new pdo(‘mysql:host=localhost;dbname=rphp4zf’, ‘root’,’rickyfeng’);

$pdo->tattribute(pdo::attr_errmode, pdo::errmode_exception);

new ssiontodb($pdo);

} catch(pdoexception $e) {

echo ‘error: ‘.$e->getmessage();

}