PHP session_sava_path() to MySQL table

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.

The MySQL server is local, so reading from memory will be faster.
Being able to list active users
Making an easy way for an admin to read and modify a user session, without having them logging ind and out.
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?

Look into PHP's function: session_set_save_handler: php.net/manual/en/function.session-set-save-handler.php — user1909426
– user1909426, Commented Dec 24, 2012 at 13:50
Have a look at this answer: stackoverflow.com/questions/5057466/… — Nikolaos Dimopoulos
– Nikolaos Dimopoulos, Commented Dec 24, 2012 at 13:50
The problem with settings the save handler, as people do in the PHP documentation, is that you have to use new functions for your sessions. This means I would have to change alot of code. I'm thing there might be a module, extension or something out there, which replaces/adds functionality to the original session handler. — Drejer
– Drejer, Commented Dec 24, 2012 at 13:54
@Drejer: No you won't. Just use the session save-handler that comes with the memcache extension and you're done. It's a simple setting. — hakre
– hakre, Commented Dec 24, 2012 at 13:58

hakre · Accepted Answer · 2012-12-24 13:57:35Z

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)

edited Dec 24, 2012 at 13:57

answered Dec 24, 2012 at 13:52

hakre

200k55 gold badges454 silver badges867 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP session_sava_path() to MySQL table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related