Codeigniter Session - Access Userdata value for all users from DB

Question

I am using Codeigniter's Session class to store session values in the database. Contained within the userdata field is the user's username and other values.

I want to get the username from each userdata field where the lastactivity is >= let's say 5 minutes.

The only way I can think to accomplish this is:

search for users active in last 5 minutes
get the userdata for each row returned
unserialise userdata
extract username

However this seems like the long way. Is there a cleaner/better way to do this?

Do u want to store all username etc. data from your database whose lastactivity > x to CI Session ? — sandip
– sandip, Commented Feb 16, 2013 at 6:10
The userdata field in the DB will contain a few different values, I just need to extract one of those. — Mr Wednesday
– Mr Wednesday, Commented Feb 16, 2013 at 6:20

Mansoorkhan Cherupuzha · Accepted Answer · 2013-02-16 07:30:04Z

1

Try this code.

$query = $this->db->select('user_data')->get('ci_sessions');

$user = array(); /* array to store the user data we fetch */

foreach ($query->result() as $row)
{
    $udata = unserialize($row->user_data);

    /* put data in array using username as key */
    $user[$udata['user_name']] = $udata['user_role']; 
}

from the result array, u can fetch needed information.

answered Feb 16, 2013 at 7:30

Mansoorkhan Cherupuzha

1,7611 gold badge24 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mr Wednesday Over a year ago

That's identical to the solution I listed and said I was trying to avoid if possible. I realise it may be necessary but only as a last resort.

Collectives™ on Stack Overflow

Codeigniter Session - Access Userdata value for all users from DB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related