NDB Session Class

NDB Session Class for CodeIgniter (Version 2.1)

---

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: {{{ #!php $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 EXISTSSessions(sess_idVARCHAR(40) NOT NULL ,sess_ipVARCHAR(16) NOT NULL ,sess_user_agentVARCHAR(120) NOT NULL ,sess_date_activityDATETIME NOT NULL ,sess_date_expireDATETIME NOT NULL ,sess_date_expire_idDATETIME 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'] = '/'; `

Changelog

---

• From 2.0 to 2.1 - Change database structure and Session Class

Help and Support

---

If any issues, mistakes or bugs report them on BitBucket ...

---

Copyright 2011 - 2012 by Denis Molan. All Rights Reserved