Hello,

started as a feature request for the new session lib in 1.6 to support storage of userdata and flashdata optional in a database, i have released NGSession bc the current session lib in CI v1.6 still stores any userdata or flash variables in the cookie.

NGSession can be used transparently using cookies or the database. When using a database, only the session_id is stored in the cookie.

Overview
- NGSession is based on a combination of Codeignitors Session.php in version 1.6 and DBSession.
- Fully compatible with Codeignitors Session.php in version 1.54 and 1.6 and DBSession.
- Designed as drop-in replacement for CI Session and/or DBSession.
- Any config option like encryption and any functionallity like flash session variables are fully supported.
- When using a database, only the session_id is stored in a cookie. Any other data is stored in the database.
- When using without a database, all data is stored in a cookie.
- Both modi work fully tansparent.

More details can be found in the wiki: NGSession

The lib should work with CI v1.54 and v1.60.

Any feedback is appreciated.

Wolfgang

P.S. Thank you to the CI / EE Team for providing such a great framework.

This looks interesting, you should post it in the “Ignited Code” forum.

Also, what are the advantages of your library over the DB_Session library ?

i think this is the fact, that you can use it AS cookie session AND database session.

keep me posted with test and bug, i’ll do some test on my side also.

Alex007 - 02 February 2008 01:50 PM

This looks interesting, you should post it in the “Ignited Code” forum.

I appologize, you are right.

If an Admin is reading this, i kindly ask to move this thread into the correct forum.

Also, what are the advantages of your library over the DB_Session library ?

As sikkle stated: The lib can handle transparently sessions using cookies AND database without changing any code. So you can use one lib regardless wether you want sessions in database or not.
Give it a try: start using cookies and then change the config to use database.
If you had a valid cookie session, a new database session will start and thats it.
(Since it is a drop in replacement you can simply replace the CI session lib, given you have added the required database field ‘session-data’ as you would for DB Session)

Pls let me know if you find any bugs. I use it in my current project (using JS EXT, CI 1.6) and it works flawless for me.

Using NGAuth (not released so far) i also keep the user_groups (memberships/roles of the logged-in user like admin, manager, user etc.) in the session data. That is something i would not want, if the session data were hold in a cookie.

Hello,

I am note sure how to “use” the custom session data saved in the DB.
What I am looking for is a way to tell if a user is logged in or not.
What I tried before was to simply add a new field (user) into the table
and then create a query checking for the username in the sessions table but this
I was not able to do with the original CI 1.6 session library.

From what I can see now, using the NGSession, the custom data is saved to the DB which is good, but how do I “extract” it to get the functionality that I was looking for (see above).

Saved data.

Kind Regards,
Daniel

You do not have to deal with the database - just get/set sessiondata as you would using CI’s session.
As i said before: The lib works transparent for cookies and database storage.

But here a simple example:

This works when using cookies and when using database.

Really the point is to serialize all userdata (and flashdata) so they can be stored in _one_ database field. This allows to save any user/flashdata without actually having to modify the table structure.

The serialization itself works similar for using cookies and for database.

To help you, here an example of my login procedure.
The code won’t work by copy / paste but should give you the idea. You will see, that i use the session API rather than direct access to the session table.
Note: The db syntax matches the new CI 1.6 activerecord implementation (so won’t work on CI 1.5x)

Hello.

I get the database error when i try to load the NGSsession library:

An Error Was Encountered

Error Number:

ERROR: syntax error at or near “)” at character 29

SELECT * FROM (“ci_sessions”) WHERE “session_id” = ‘1d4860f4de1d6656fd6cc8227ca40b77’ AND “ip_address” = ‘xxx.xxx.xxx.xxx’ AND “user_agent” = ‘Mozilla/5.0 (X11; U; Linux i686; PL; rv:1.7.12) Ge’

I use postgres database. My ci_sessions table looks like that:

ci_sessions (
  session_id character varying(40) DEFAULT 0 NOT NULL primary key,
  ip_address character varying(16) DEFAULT 0 NOT NULL,
  user_agent character varying(50) NOT NULL,
  last_activity integer DEFAULT 0 NOT NULL,
  session_data text DEFAULT ‘’::text NOT NULL
);

My config.php:

$config[‘sess_cookie_name’]      = ‘ci_session’;
$config[‘sess_expiration’]      = 7200;
$config[‘sess_encrypt_cookie’]  = FALSE;
$config[‘sess_use_database’]  = TRUE;
$config[‘sess_table_name’]      = ‘ci_sessions’;
$config[‘sess_match_ip’]      = TRUE;
$config[‘sess_match_useragent’]  = TRUE;
$config[‘sess_time_to_update’]    = 300;

And my controller:

class Main extends Controller {

  function __construct()
  {
      parent::Controller();
      $this->load->library(‘session’);
  }
}

Is there a problem with database library (sth with postgres)? Or am I doing sth wrong?
I’d appreciate any help…

edit: i’ve found a solution… -> http://codeigniter.com/forums/viewthread/70389/

Thx for posting the link to the solution to fix the postgre AR driver.

Does the lib work for you?

Works great:)
Thanks for the lib.

This is my big concern about these session libraries.

Can I store an object in a session and can this object be written to the database?