Session Data

[eluser]GamingFusion[/eluser]
I was wandering how i would get the membergroup data from ym database table into the session data.

I have looked at the Active record but haven't been able t find what i want. Here is what i have tried

Code:

<?php
$this->db->where('username', $this->input->post('username'));
            $database = $this->db->get('users');
            
            $data = array(
                'username' => $this->input->post('username'),
                'isLoggedIn' => true,
                'membergroup' => $database->result('membergroup')
                
            );
            
?>

[eluser]Thorpe Obazee[/eluser]
Did you really read the User Guide?

[eluser]InsiteFX[/eluser]
HINT: $this->session->user_data('item', 'value')

Enjoy
InsiteFX

P.S. As bargainph stated it's all in the user guide Session Library.

[eluser]GamingFusion[/eluser]
ok i got some where but now i for the membergroup is says array

Code:

<?php
$this->db->where('username', $this->input->post('username'));
            $database = $this->db->get('users');
            
            if ($database->num_rows() > 0)
            {
               $row = $database->row();
            
            $membergroup = $row->membergroup;
            
            }
            
            $data = array(
                'username' => $this->input->post('username'),
                'isLoggedIn' => true,
                'membergroup' => $database->result($membergroup)
                
            );
?>

I want it to get the row of the member that is logged in

[eluser]Mischievous[/eluser]

Code:

$query = "SELECT * FROM users WHERE username = '".$this->input->post('username')."'";
$result = $this->db->query($query);
$check = $result->num_rows();
            
if ($check > 0)
{
    $data = array(
        'username'     => $this->input->post('username'),
        'isLoggedIn'     => TRUE,
        'membergroup'     => $result->row('membergroup')
    );
    $this->session->set_userdata($data);
}

?? not sure what your askin

[eluser]GamingFusion[/eluser]
when i echo the membergroup is returns array still

[eluser]GamingFusion[/eluser]
does anyone know why it is returning "array" instead of what it should?

[eluser]GamingFusion[/eluser]
its working now