Set user data from query result in CodeIgniter session

Question

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?

Nil'z · Accepted Answer · 2013-07-08 09:11:18Z

2

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');

answered Jul 8, 2013 at 9:11

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

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

3 Comments

axmug Over a year ago

I tried this but it doesn't work. When I try to retrieve the username I watch vale and the name must be alexander. What's wrong?

Nil'z Over a year ago

First echo your query and run it in your phpmyadmin. To echo the query: echo $this->db->last_qeury();. Second, print your $data array and see if you are fetching the correct result from the db. Third, print the session print_r($this->session->all_userdata());.

axmug Over a year ago

Yes, it works now. I can watch the username and I can save it in the session table. The problem was that the query I typed was wrong.

Drixson Oseña · Accepted Answer · 2013-07-08 08:32:05Z

0

You can try this:

$result = $this->db->get_where($table, array('username' =>$this->input->post('drcorreo'))); 
$result->result_array();

for documentation you may read it in here Codeigniter

answered Jul 8, 2013 at 8:32

Drixson Oseña

3,6313 gold badges25 silver badges36 bronze badges

Collectives™ on Stack Overflow

Set user data from query result in CodeIgniter session

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related