Codeigniter - how to get data from a model query into controller function

Question

I'm having trouble understanding how to get data (single row) from a model query into a controller function in codeigniter. I've searched the stack overflow posts, but no luck. I have a query in a model like this:

function login($email, $sha1Pass) {
    $loginArray = array('email' => $email, 'pw' => $sha1Pass);
    $this->db->select('lid, email, pw');
    $this->db->from('login');
    $this->db->where($loginArray);
    $query = $this->db->get();
    return $query->row();
}

There will only be 1 returned row [lid, email, pw]

I then have a controller that calls this model query.

$report['row'] = $this->LoginCheck->login($email, $encp);

What I need is 2 fields from the database from the row and assign them to a variable like this:

$lid = $report['lid'];
$email = $report['email'];

lid and email are the fields from the database.

doitlikejustin · Accepted Answer · 2013-08-15 22:20:58Z

1

You can access them like:

$lid = $report['row']->lid;
$email = $report['row']->email;

answered Aug 15, 2013 at 22:20

doitlikejustin

6,3312 gold badges44 silver badges69 bronze badges

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

Comments

Dr.jacky · Accepted Answer · 2016-04-13 06:04:51Z

0

Try this:

Login_model

public function auth($nm,$pwd)
{
    $this->db->select('uname,password');
    $q1=$this->db->get_where('user_details',array('uname'=>$nm,'password'=>$pwd));
    return $q1->row();
}

//you can call this method from controller like

$data['query']=$this->Log_Model->auth($unm,$pswd);

//And you can create session variable like,

$this->session->set_userdata('uname',$data['query']->uname);

edited Apr 13, 2016 at 6:04

Dr.jacky

3,6036 gold badges58 silver badges98 bronze badges

answered Apr 13, 2016 at 5:18

dhaval Patel

1

Comments

user10450523 · Accepted Answer · 2018-10-03 09:56:36Z

0

If you view set this

$lid = $report['lid'];
$email = $report['email'];

Then add some on model to get query as

function login($email, $sha1Pass) {
$loginArray = array('email' => $email, 'pw' => $sha1Pass);
$this->db->select('lid, email, pw');
$this->db->from('login');
$this->db->where($loginArray);
$query = $this->db->get();
return $query->row_array();
}

just set row() to row_array()

answered Oct 3, 2018 at 9:56

user10450523

Comments

mahesh talaviya · Accepted Answer · 2018-12-06 06:29:09Z

0

  $data = array(
        'username' => $_POST['fullname'],
        'useremail' => $_POST['email'],
        'social_login_id' => $_POST['bq_user_id'],
        'social_login_type' => $loginType,
        'login_status' => 'online',
        'is_active' =>1,
    );
    $this->db->insert($this->TABLE, $data);

answered Dec 6, 2018 at 6:29

mahesh talaviya

1272 silver badges15 bronze badges

1 Comment

Ali Over a year ago

Hi, This may answer the question, please provide some explanation of your code.

Collectives™ on Stack Overflow

Codeigniter - how to get data from a model query into controller function

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related