data pass through session

[eluser]zreedeecom[/eluser]
Take a look at: User guide > Database Library > Query Results

Code:

function get_user_id(){
  $this->db->where('username', $this->input->post('username'))->where('password', $this->input->post('password'));
  $q = $this->db->get('users');
  if ( $q->num_rows() > 0 ) {
    //do something with: $q->result() or $q->row()
    $row = $q->row();
    //Now you can store that ID in a session
    $this->session->set_userdata('user_id', $row->id);
    //or you can return it to your controller to perform other actions
    return $row->id;
  }
  else {
    //No records founded
  }
} //end get_user_id()