How to split and parse the serialized data in the ci_session table for a CodeIgniter 3 application
08:03 21 Dec 2015

Codeigniter 3 session table looks like the following

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`)
  );

I can access my current session by

 $this->session

But If I'd like to access a specific session how would I do that.

I can get the session like

$this->db->where('id', 'db256c0b82f8b6ba1e857d807ea613792817157a');
$res = $this->db->get('ci_sessions');
echo $res->row()->data;

I get the following

 __ci_last_regenerate|i:1450694483;email|s:18:"amzadfof@gmail.com";user_code|s:7:"AAA1787";loginInId|i:8;users_id|s:11:"00000000002";active|s:1:"1";username|s:13:"amzadmojumder";fname|s:5:"Amzad";lname|s:8:"Mojumder";phone|s:11:"07900642131";title|s:1:"#";created_on|s:19:"2015-12-17 16:31:56";last_login|s:19:"0000-00-00 00:00:00";in_group|s:15:"2,1,3,4,5,6,7,8";

How could I convert this to an php object or array? I have tried to

 unserialize($res->row()->data);

Also tried

session_decode($res->row()->data);

none of this worked.

php codeigniter session deserialization codeigniter-3