PHP session_sava_path（）到MySQL表

Question

I've been looking into making my own session handler for my PHP application, simply because I want to store the session data in a MySQL Memory table instead of on the local filesystem.

There are 4 main reasons for me to do this.

1. The MySQL server is local, so reading from memory will be faster.
2. Being able to list active users
3. Making an easy way for an admin to read and modify a user session, without having them logging ind and out.
4. Being able to run scripts after a session timeout, or a user "idle" variable in the session.

I can't seem to find any easy way for doing this.

I could use memcached, but it would result in doubling the session data in the memory on my server.

Does anybody know of an easy way, to force PHP at run-time, to use a MySQLi resource as session storage?

Answer 1

Actually Mysql offers a memcache interface that first uses memory and can later on persitent into a real database table.

It can be simply configured via php.ini after you've create the tabels in your database server (see here):

; when using the "memcache" extension:
session.save_handler=memcache
; when using the "memcached" extension:
; session.save_handler=memcached

session.save_path="tcp://localhost:11211"

You find it outlined here with PHP examples:

• Not only SQL - memcache and MySQL 5.6 (14 Apr 2011; by Johannes Schlüter)
• MySQL, Memcache, PHP revised (30 Sep 2012; by Johannes Schlüter)