NDB Session Class

NDB Session Class for CodeIgniter (Version 2.12)

Native Session makes good use of PHP’s native session handling abilities, but it does not allow the use of a database for session storage. Saving user session data into database is more secure on any type of hosting (Shared ... ). \ This library overwrites normal native sassion functions too save user data directly into database and gives us some extra functions over CI Session.

Overview

Is based on Native Session but has database functionality built in.
Compatible with CodeIgniter 1.7 +.
Drop-in replacement for CI’s Session library.
Config options and flash data are supported but not session encryption.
When using with a database, only the session_id is stored in a cookie. Any other data is stored in the database (Nativly would be stored to server /tmp ).
Tested IE6, IE7, IE8, IE9, Firefox 4, Chrome
PHP5+

Donations

Support the developer and u may see more stuff coming
PayPal Support and Verified

Licence

GPL 2.0 and LGPL 2.1

Usage

Same usage as CI Session

Codeigniter Docs

Extras

Write and Access session data from database:

$_SESSION['Data'] = 'Value'; // Access, same as $this->session->userdata('Data');
$_SESSION['Data];  // Write, same as $this->session->set_userdata('Data', 'Value');

Get User Online Count:

$count = $this->session->users_online(300); // Returns all user which are or were active in last 5 min

Parsing session data:

// Enable us to access any session data and manage it, usefull for session management system
// We just past session data from database into session parse function and parse function will return session data in array style so we can access it

$arr_data = $this->session->parse($session_data);
$some_val = $arry_data['session_key'];

Install

Download Session Class and copy it to "appliaction/libraries/"
Insert new database table for Session storage
Autoload or load CI database Class and Session Class
Don't forget to setup database configuration
Have fun

Differences between NDB Session and CI Session

Using native PHP Session functions ( Smaller lib. same security )
No encryption of cookie as only Session ID is stored in cookie (Allready hashed)
Checking valid Session ID differently ( We dont save IP, Useragent and Activity in cookie)
Session garbage collector works differently ( Expired data, Useless data)
After session destroy we create new empty session so u can set new Session data after it
Some CI Session functions removed as not needet (Functions which PHP does it for us)
Extras for setting and accessing Session data( $_SESSION['data'] ...)

Required Database Structure

CREATE  TABLE IF NOT EXISTS `Sessions` (
 `sess_id` VARCHAR(40) NOT NULL ,
 `sess_ip` VARCHAR(16) NOT NULL ,
 `sess_user_agent` VARCHAR(120) NOT NULL ,
 `sess_date_activity` DATETIME NOT NULL ,
 `sess_date_expire` DATETIME NOT NULL ,
 `sess_date_expire_id` DATETIME NOT NULL ,
 `sess_data` TEXT NOT NULL ,
 PRIMARY KEY (`sess_id`) )
ENGINE = InnoDB

Example Configuration (/system/application/config/config.php)

$config['sess_cookie_name']     = 'ci_session';
$config['sess_expiration']      = 3600;  // 1 H
$config['sess_expire_on_close'] = TRUE;
$config['sess_encrypt_cookie']  = FALSE;
$config['sess_use_database']    = TRUE;
$config['sess_table_name']      = 'Sessions';
$config['sess_match_ip']        = TRUE;
$config['sess_match_useragent'] = FALSE;
$config['sess_time_to_update']  = 600;  // 10 min

$config['cookie_prefix'] = '';
$config['cookie_domain'] = '';
$config['cookie_path'] = '/';

Provide feedback

Saved searches

Use saved searches to filter your results more quickly