phpcodeignitersessionresultset

Set user data from query result in CodeIgniter session

I want to know where I can retrieve the result of a query in Codeigniter.

The code:

$this->db->where('usuario', $this->input->post('drcorreo')); 
$cdb = $this->db->get('usuarios');

How do I save the name of the user from this query in the session class?

Solution

  • Try this:

    ### saving in the session ###
$rs = $this->db->where('usuario', $this->input->post('drcorreo'))->get('usuarios');
if($rs->num_rows() > 0){
    $data   = $rs->row_array();     #for a single tuple use result_array() for multiple tuples
    $this->session->set_userdata('usuario', $data['usuario']);  #saving it in session
}

### to retrieve dfrom the session ###
$usuario    = $this->session->userdata('usuario');