CodeIgniter Project Tutorial 11 – Storing Sessions in the Database

Code Igniter By Builder

I show you how to store sessions in the database and some advantages to storing the sessions this way. We also see how easy it is to get the amount of users currently logged in when using database sessions.

Just adding a note to this: One user can have multiple sessions stored in DB, ie, they delete their account and register again, or by using different devices to access the site, I upgraded the SQL to check for a DISTINCT value in user_data:

SELECT count(DISTINCT user_data) as count FROM ci_sessions WHERE user_data LIKE ‘%logged_in”;i:1%’

Become an awesome software developer!
http://anthonyvipond.com/training

Add me on LinkedIn
https://www.linkedin.com/in/anthony1981

Email: anthonytrading81 @ gmail

source