Storing Session Data in Database By Codeigniter

Storing Session Data in Database By Codeigniter

Codeigniter storing session data in database. In Codeigniter by default session store in the files that is not good in the security point of view. we can not store bulk data in session. If we want to store more data we need to find the alternative solution for that, so the alternative solution is that store session in the database. Codeigniter have natively avaliable this, we can easily store the session in database we just need to do some config changes.

First Create a database table

1 2 3 4 5 6 7

CREATE TABLE IF NOT EXISTS `ci_sessions` (         `id` varchar(40) NOT NULL,         `ip_address` varchar(45) NOT NULL,         `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,         `data` blob NOT NULL,         KEY `ci_sessions_timestamp` (`timestamp`) );

After creating the database table now you just need to open config.php file and in this file you need to enable database for session and also specify the table name.following are the setting for config.php file.

1 2 3 4 5 6

$config['sess_driver'] = 'database'; $config['sess_cookie_name'] = 'ci_sessions'; $config['sess_expiration'] = 7200; $config['sess_save_path'] = 'ci_sessions'; //It is your table name name $config['sess_match_ip'] = FALSE; $config['sess_time_to_update'] = 300;

Now you go to the autoload.php, and add “session” to the drivers element:

1	$autoload['library'] = array('session');