Codeigniter pass db result object from model to controller

Question

I am still quite new to Codeigniter and have a noob problem I need some help with.

I am trying to set the auto incremented id number for each user to the session data as user_id. eg:

Controller:

$username = $this->input->post('username');
$this->load->model('membership_model');
$user_id = $this->membership_model->getUser_id(); 

$data = array(
    'session_id' => $str = do_hash($str),
    'user_id' => $user_id,
    'username' => $username,
    'is_logged_in' => true
);          
$this->session->set_userdata($data);
redirect('site/members_area');

Model:

public function getUser_id()
{

    $session_username = $this->session->userdata('username');

    $q = $this->db->get_where('membership', array('username' => $session_username), 1);

    if($q->num_rows() > 0) {
        foreach($q->result() as $row) {
            $row->id;
            $row->username;
        }
        return $data;
    }
}

My problem is I am not sure how to pass the $row->id; object from the model to the controller to be used as the user_id.

Can someone please provide some advice or am I approaching this in the wrong way?

Thank you in advance for any assistance provided.

why not use an already existing security model for CI? There are plenty there. (I know this does not address your question tho). — Jakub
– Jakub, Commented Oct 4, 2011 at 4:54

Jakub · Accepted Answer · 2011-10-04 04:55:36Z

1

Its quite simple, just return the id:

public function getUser_id()
{

    $session_username = $this->session->userdata('username');

    $q = $this->db->get_where('membership', array('username' => $session_username), 1);

    if($q->num_rows() > 0) {
       $row = $q->row(); 
       return $row->id;
    }
    return false;  // else return false
}

answered Oct 4, 2011 at 4:55

Jakub

20.5k8 gold badges67 silver badges93 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter pass db result object from model to controller

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related