无法将php的session存入数据库
<code><?php ob_end_clean(); if((int)ini_get('session.auto_start') > 0) { ini_set('session.auto_start',0); } function zen_session_open() { global $zen_session_db; $zen_session_db = new mysqli('localhost','root','wh36524','phptest'); return TRUE; } function zen_session_close() { global $zen_session_db; return $zen_session_db -> close(); } function zen_session_read($sid) { global $zen_session_db; $sql = 'select session_value from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db -> errno) { die($zen_session_db->error); } if($query -> num_rows == 1) { $data = $query->fetch_assoc(); return $data['session_value']; } else { return ""; } } function zen_session_write($sid,$data) { global $zen_session_db; $sql = 'select count(*) from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db->errno) { die($zen_session_db->error); } if($query->num_rows > 0) { $sql = 'update session set session_value="'.$data.'",expire='.(time()+60*60).' where session_id="'. $sid.'"'; $zen_session_db->query($sql); } else { $sql = 'insert into session values("'.$sid.'","'.(time()+60*60).'","'.$data.'")'; $zen_session_db->query($sql); } /* if($zen_session_db->affected_rows > 0) { return TRUE; } else { return FALSE; } */ return TRUE; } function zen_session_destroy($sid) { global $zen_session_db; $sql = 'delete from session where session_id="'.$sid.'"'; $zen_session_db->query($sql); $_SESSION = array(); return TRUE; } function zen_session_gc($time) { global $zen_session_db; $sql = 'delete from session where expire query($sql); return TRUE; } session_set_save_handler('zen_session_open','zen_session_close','zen_session_read','zen_session_write', 'zen_session_destroy','zen_session_gc' ); session_name('zenID'); session_start(); $_SESSION['age'] = 16; $_SESSION['color'] = 'green'; session_write_close(); </code>
不知道怎么回事,比到参考书写的,但是就是无法实现在数据库存储啊,我在另外一个页面拷贝了上面的代码,然后打印$_SESSION数组,但是是空的,不知道是哪里的问题?
<code><?php ob_end_clean(); if((int)ini_get('session.auto_start') > 0) { ini_set('session.auto_start',1); } function zen_session_open() { global $zen_session_db; $zen_session_db = new mysqli('localhost','root','wh36524','phptest'); return TRUE; } function zen_session_close() { global $zen_session_db; return $zen_session_db -> close(); } function zen_session_read($sid) { global $zen_session_db; $sql = 'select session_value from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db -> errno) { die($zen_session_db->error); } if($query -> num_rows == 1) { $data = $query->fetch_assoc(); return $data['session_value']; } else { return ""; } } function zen_session_write($sid,$data) { global $zen_session_db; $sql = 'select count(*) from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db->errno) { die($zen_session_db->error); } if($query->num_rows > 0) { $sql = 'update session set session_value="'.$data.'",expire='.(time()+60*60).' where session_id="'. $sid.'"'; $zen_session_db->query($sql); } else { $sql = 'insert into session values("'.$sid.'","'.(time()+60*60).'","'.$data.'")'; $zen_session_db->query($sql); } /* if($zen_session_db->affected_rows > 0) { return TRUE; } else { return FALSE; } */ return TRUE; } function zen_session_destroy($sid) { global $zen_session_db; $sql = 'delete from session where session_id="'.$sid.'"'; $zen_session_db->query($sql); $_SESSION = array(); return TRUE; } function zen_session_gc($time) { global $zen_session_db; $sql = 'delete from session where expire query($sql); return TRUE; } session_set_save_handler('zen_session_open','zen_session_close','zen_session_read','zen_session_write', 'zen_session_destroy','zen_session_gc' ); session_name('zenID'); session_start(); //$_SESSION['age'] = 16; //$_SESSION['color'] = 'green'; print_r($_SESSION); session_write_close(); </code>
回复内容:
<code><?php ob_end_clean(); if((int)ini_get('session.auto_start') > 0) { ini_set('session.auto_start',0); } function zen_session_open() { global $zen_session_db; $zen_session_db = new mysqli('localhost','root','wh36524','phptest'); return TRUE; } function zen_session_close() { global $zen_session_db; return $zen_session_db -> close(); } function zen_session_read($sid) { global $zen_session_db; $sql = 'select session_value from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db -> errno) { die($zen_session_db->error); } if($query -> num_rows == 1) { $data = $query->fetch_assoc(); return $data['session_value']; } else { return ""; } } function zen_session_write($sid,$data) { global $zen_session_db; $sql = 'select count(*) from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db->errno) { die($zen_session_db->error); } if($query->num_rows > 0) { $sql = 'update session set session_value="'.$data.'",expire='.(time()+60*60).' where session_id="'. $sid.'"'; $zen_session_db->query($sql); } else { $sql = 'insert into session values("'.$sid.'","'.(time()+60*60).'","'.$data.'")'; $zen_session_db->query($sql); } /* if($zen_session_db->affected_rows > 0) { return TRUE; } else { return FALSE; } */ return TRUE; } function zen_session_destroy($sid) { global $zen_session_db; $sql = 'delete from session where session_id="'.$sid.'"'; $zen_session_db->query($sql); $_SESSION = array(); return TRUE; } function zen_session_gc($time) { global $zen_session_db; $sql = 'delete from session where expire query($sql); return TRUE; } session_set_save_handler('zen_session_open','zen_session_close','zen_session_read','zen_session_write', 'zen_session_destroy','zen_session_gc' ); session_name('zenID'); session_start(); $_SESSION['age'] = 16; $_SESSION['color'] = 'green'; session_write_close(); </code>
不知道怎么回事,比到参考书写的,但是就是无法实现在数据库存储啊,我在另外一个页面拷贝了上面的代码,然后打印$_SESSION数组,但是是空的,不知道是哪里的问题?
<code><?php ob_end_clean(); if((int)ini_get('session.auto_start') > 0) { ini_set('session.auto_start',1); } function zen_session_open() { global $zen_session_db; $zen_session_db = new mysqli('localhost','root','wh36524','phptest'); return TRUE; } function zen_session_close() { global $zen_session_db; return $zen_session_db -> close(); } function zen_session_read($sid) { global $zen_session_db; $sql = 'select session_value from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db -> errno) { die($zen_session_db->error); } if($query -> num_rows == 1) { $data = $query->fetch_assoc(); return $data['session_value']; } else { return ""; } } function zen_session_write($sid,$data) { global $zen_session_db; $sql = 'select count(*) from sessions where session_id="'.$sid.'"'; $query = $zen_session_db->query($sql); if($zen_session_db->errno) { die($zen_session_db->error); } if($query->num_rows > 0) { $sql = 'update session set session_value="'.$data.'",expire='.(time()+60*60).' where session_id="'. $sid.'"'; $zen_session_db->query($sql); } else { $sql = 'insert into session values("'.$sid.'","'.(time()+60*60).'","'.$data.'")'; $zen_session_db->query($sql); } /* if($zen_session_db->affected_rows > 0) { return TRUE; } else { return FALSE; } */ return TRUE; } function zen_session_destroy($sid) { global $zen_session_db; $sql = 'delete from session where session_id="'.$sid.'"'; $zen_session_db->query($sql); $_SESSION = array(); return TRUE; } function zen_session_gc($time) { global $zen_session_db; $sql = 'delete from session where expire query($sql); return TRUE; } session_set_save_handler('zen_session_open','zen_session_close','zen_session_read','zen_session_write', 'zen_session_destroy','zen_session_gc' ); session_name('zenID'); session_start(); //$_SESSION['age'] = 16; //$_SESSION['color'] = 'green'; print_r($_SESSION); session_write_close(); </code>
提问应该尽可能多的提供线索,比如你的 SQL
语句是什么样的,这样别人在测试的时候方便多了,我现在还需要自己来创建:
<code>sql</code><code>CREATE TABLE `session` ( `session_id` char(128) DEFAULT NULL, `expire` int(11) DEFAULT NULL, `session_value` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8 </code>
环境信息也尽可能的提供,比如我的代码可以运行在 php 5.5.16-pl0-gentoo
问题1、你的表名有问题,读的时候用了,sessions ; 写的时候是用的 session
问题2、貌似通过 open 方法时打开的数据库链接在其它地方用不了,(这个原因我也不清楚,后面可以了解下为什么),去官方看了下,都是使用的 class 来完成的。所以把你的改成了 OOP 的形式测试可用。
<code><?php ob_end_clean(); if((int)ini_get('session.auto_start') > 0) { ini_set('session.auto_start',0); } class MySqlSessionHandler implements SessionHandlerInterface { private $_db; public function close() { return $this->_db->close(); } public function destroy($sessionn_id) { $sql = 'delete from sessions where session_id="'.$session_id.'"'; $this->_db->query($sql); $_SESSION = array(); return TRUE; } public function gc($maxlifetime) { $sql = 'delete from sessions where expire query($sql); return TRUE; } public function open($save_path, $name) { $this->_db = new mysqli('localhost','root','password','test'); return (boolean)$this->_db; } public function read($session_id) { $sql = 'select session_value from sessions where session_id="'.$session_id.'"'; $query = $this->_db->query($sql); if($this->_db->errno) { die($this->_db->error); } if($query -> num_rows == 1) { $session_data = $query->fetch_assoc(); return $session_data['session_value']; } else { return ""; } } public function write($session_id, $session_data) { $sql = 'select count(*) as count from sessions where session_id="'.$session_id.'"'; $query = $this->_db->query($sql); $result = $query->fetch_assoc(); if($this->_db->errno) { die($this->_db->error); } if($result['count'] > 0) { $sql = 'update sessions set session_value=\''.$session_data.'\',expire='.(time()+60*60).' where session_id="'. $session_id.'"'; $this->_db->query($sql); } else { $sql = 'insert into sessions values("'.$session_id.'","'.(time()+60*60).'",\''.$session_data.'\')'; $this->_db->query($sql); } if($this->_db->affected_rows > 0) { return TRUE; } else { return FALSE; } } } $handler = new MySqlSessionHandler; session_set_save_handler($handler, true); session_name('zenID'); session_start(); $_SESSION['age'] = 17; $_SESSION['color'] = 'green'; $_SESSION['color2'] = 'red'; </code>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
