php 7.3.4 将SESSION存入MYSQL

数据库

php版本 7.3.4

连接数据库 后设置session

<?php

function _session_open()

{
global $con;

$servername = "127.0.0.1";

$username = "root";

$password = "rootroot";

$database = "session";

$con = new mysqli($servername, $username, $password);

if ($con->connect_error) {
die("连接失败" . $con->connect_error);

return (false);

}

echo '连接数据库成功

';

if ($con->select_db($database) == false) {
die("数据库中没有此库名");

return (false);

}

return (true);

}

//封装session_close()函数,关闭数据库连接

function _session_close()

{
global $con;

$con->close();

return (true);

}

//封装session_read()函数,该函数只能返回字符串

function _session_read($key)

{
	global $con;
	// $sql = "insert into session (session_key,session_data,timeout) value('333','222','111') ";
	// $cont->query($sql);
	$sql = "select session_key,session_data from session where session_key='$key'";

	$result = $con->query($sql);

	if ($result->num_rows > 0) {
		$row = mysqli_fetch_object($result);
		// $row = json_encode($row);
		// return $row;
		return serialize($row);  //  好像PHP 版本不同此处返回的方式不同  此处错误  可能导致数据库写不进数据  或 出现 图1  错误  图1 在下面
	} else {
		return "";

	}

}

//根据sessionId判断数据存在,存在修改,否则修改,并且设置超时时间为1分钟

function _session_write($key, $data)

{
global $con;

$timeout = time() + 60;

$sql = "select session_data from session where session_key='$key'";

$result = $con->query($sql);


if ($result->num_rows == 0) {
$sql = "insert into session(session_key,session_data,timeout) value('$key','$data','$timeout')";

} else {
$sql = "update session set session_data='$data' , timeout='$timeout' where session_key='$key'";

}

$res = $con->query($sql);

return (true);

}

//封装session_destroy()函数,根据$key 值将数据库中的session删除

function _session_destroy($key)

{
global $con;

$sql = "delete from session where session_key='$key'";

$con->query($sql);

return (true);

}

//封装session_gc()函数,根据给出的实效时间删除过期Session

function _session_gc()

{
global $con;

$timeout = time();

$sql = "delete from session where timeout";

$con->query($sql);

return (true);

}

//设置session存储到数据库中

session_set_save_handler('_session_open', '_session_close', '_session_read', '_session_write', '_session_destroy', '_session_gc');
//启动session
session_start();
//设置session
$_SESSION['u'] = 'ming';

$_SESSION['a'] = 18;

图1
Warning: session_start(): Failed to read session data: user

Failed to decode session object. Session has been destroyed

连接数据库 获取session

<?php
function _session_open()

{
global $con;

$servername = "127.0.0.1";

$username = "root";

$password = "rootroot";

$database = "session";

$con = new mysqli($servername, $username, $password);

if ($con->connect_error) {
die("连接失败" . $con->connect_error);

return (false);

}

echo '连接数据库成功

';

if ($con->select_db($database) == false) {
die("数据库中没有此库名");

return (false);

}

return (true);

}

//封装session_close()函数,关闭数据库连接

function _session_close()

{
global $con;

$con->close();

return (true);

}

//封装session_read()函数,该函数只能返回字符串

function _session_read($key)

{
global $con;

$sql = "select session_key,session_data from session where session_key='$key'";

$result = $con->query($sql);

if ($result->num_rows > 0) {
$row = mysqli_fetch_object($result);

// $row = json_encode($row);

return serialize($row);

} else {
return "";

}

}

//根据sessionId判断数据存在,存在修改,否则修改,并且设置超时时间为1分钟

function _session_write($key, $data)

{
global $con;

$timeout = time() + 60;

$sql = "select session_data from session where session_key='$key'";

$result = $con->query($sql);

if ($result->num_rows == 0) {
$sql = "insert into session(session_key,session_data,timeout) value('$key','$data','$timeout')";

} else {
$sql = "update session set session_data='$data' , timeout='$timeout' where session_key='$key'";

}

$con->query($sql);

return (true);

}

//封装session_destroy()函数,根据$key 值将数据库中的session删除

function _session_destroy($key)

{
global $con;

$sql = "delete from session where session_key='$key'";

$con->query($sql);

return (true);

}

//封装session_gc()函数,根据给出的实效时间删除过期Session

function _session_gc()

{
global $con;

$timeout = time();

$sql = "delete from session where timeout";

$con->query($sql);

return (true);

}

//设置session存储到数据库中

session_set_save_handler('_session_open', '_session_close', '_session_read', '_session_write', '_session_destroy', '_session_gc');

session_start();
//获取session
var_dump($_SESSION['a']);
echo 5555;

结果

类 的写法仅供参考：https://blog.csdn.net/liusaint1992/article/details/49199947