Session data

[eluser]triplewhat[/eluser]
How do I add information from the database to the session? I am new and trying to learn this. Sorry

I have a model with this info

Code:

function validate()
{
  $this->db->select('username', 'password', 'title');
  $this->db->where('username', $this->input->post('username'));
  $this->db->where('password', $this->input->post('password'));
  $query = $this->db->get('users');
  
  if($query->num_rows == 1)
  {

   return $query;
  }
  
}

And then a controller with this

Code:

public function validate_credentials(){  
  $this->load->model('membership_model');
  $query = $this->membership_model->validate();
  
   if($query) // if the user's credentials validated...
  
   {

    $data = array(
     'username' => $this->input->post('username'),
     'logged_in' => true
    );

    $this->session->set_userdata($data);
    $data['main_content'] = 'home';
    $data['page_title'] = 'title';
    $this->load->view('includes/template', $data);
   }else{  // incorrect username or password
    $this->index();
   }
  }

I am trying to add title to the session

[eluser]InsiteFX[/eluser]

Code:

$data = array(
     'title'     => 'Your Title',
     'username'  => $this->input->post('username'),
     'logged_in' => true
);

// or
$this->session->set_userdata('title', 'your_title');

[eluser]triplewhat[/eluser]
I don't want to set the title there, i want to pull it from the database. It is already set there. The menu will changed based on the users title

[eluser]InsiteFX[/eluser]
Well put it from your database and set it thats how you do it!

[eluser]triplewhat[/eluser]
Its in my database I dont know how to select it, or how to call it, please don't answer me like that. I need examples

[eluser]triplewhat[/eluser]
I selected it in the model, how to i retrieve it in the controller, or is that the wrong way. I need examples please.

[eluser]Ajaxboy[/eluser]
Did you already went through the docs? http://ellislab.com/codeigniter/user-gui...sions.html

[eluser]triplewhat[/eluser]
yes. I dont understand how to get the value of title into an array to add to session data

[eluser]triplewhat[/eluser]
[quote author="InsiteFX" date="1335065627"]Well put it from your database and set it thats how you do it!
[/quote]

And how exactly do I do that

[eluser]Ajaxboy[/eluser]
I created my own session class so I am not making use of the CI session class..

but my understanding is that to get data you would do this:

$this->session->userdata('title');
$this->session->userdata('username');
$this->session->userdata('logged_in');