Load multiple models within same function of controller

Question

I have two functions in my model as

class Jobseeker_model extends CI_Model
{
    public function __construct()
    {
        parent::__construct();
        $this->load->database();
    }
public function result_getall($id)
    {
        $this->db->select('*');    
        $this->db->from('tbl_jobseeker');
        $this->db->where('tbl_jobseeker.User_id',$id);
        $this->db->join('tbl_work_exp', 'tbl_jobseeker.User_id = tbl_work_exp.User_id','left');
    $query = $this->db->get();
return $query->row();
    }
    public function select($id) 
    {   
        $this->db->select('*'); 
        $this->db->from('tbl_qualification');
        $this->db->where('tbl_qualification.User_id',$id);
        $query = $this->db->get();
        return $query->result();

    }
}

And in my controller I have a function as

public function display()
    {
      $id = $this->session->userdata('user_id');
      $data['row'] = $this->jobseeker_model->result_getall($id);
      $res['a'] = $this->jobseeker_model->select($id);
      $this->load->view('jobseeker_display.php', $data,$res);
}

It is not possible to display the view page.. I could pass two variables into my view page.right?

have a look at this: stackoverflow.com/questions/12849725/… — Insane Skull
– Insane Skull, Commented Sep 9, 2015 at 10:40

Scorpion · Accepted Answer · 2015-09-09 10:48:03Z

4

You can pass your any number of variables/arrays using a single array. In Controller:

public function display() {
      $id = $this->session->userdata('user_id');
      $data['var1'] = $this->jobseeker_model->result_getall($id);
      $data['var2'] = $this->jobseeker_model->select($id);
      $this->load->view('jobseeker_display.php', $data);
}

In View:

`$var1` and `$var2` will be available.

answered Sep 9, 2015 at 10:48

Scorpion

3962 silver badges14 bronze badges

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

Comments

Saty · Accepted Answer · 2015-09-09 10:37:39Z

1

You can pass your two variable using single srray

public function display()
    {
      $id = $this->session->userdata('user_id');
      $data['row'] = $this->jobseeker_model->result_getall($id);
      $data['a'] = $this->jobseeker_model->select($id);
      $this->load->view('jobseeker_display.php', $data);
     }

Views

foreach($a as $data){
// your code
}

echo $row->column_name;

answered Sep 9, 2015 at 10:37

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Comments

Keval Rathi · Accepted Answer · 2015-09-09 10:38:24Z

1

Try this

public function display()
    {
      $id = $this->session->userdata('user_id');
      $data['row'] = $this->jobseeker_model->result_getall($id);
      $data['a'] = $this->jobseeker_model->select($id);
      $this->load->view('jobseeker_display.php', $data);
}

answered Sep 9, 2015 at 10:38

Keval Rathi

9866 silver badges21 bronze badges

1 Comment

Keval Rathi Over a year ago

If you want $res then use this, $data['res']['a'] = $this->jobseeker_model->select($id);

Collectives™ on Stack Overflow

Load multiple models within same function of controller

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related