CodeIgniter - Pass database array from model to controller and then view

Question

This is probably really simple, but I just started using Code Igniter.

I have the following code in a model and want to get the database query array to pass to the controller and then pass it to a page view.

public function view_user($id){
        $this->db->where('userid', $id);
        $query = $this->db->get('users');
        return $query->result_array();
}

What is the code necessary to get the returned array in the controller?

Thanks in advance for your help!

David Rönnqvist · Accepted Answer · 2013-05-01 09:29:40Z

2

here you Go with perfact answer

Model code

public function view_user($table,$id)
{
        $this->db->where('userid', $id);
        return $this->db->get($table);
}

Now in controller Call your Method Like

$this->load->model('model_name');
$data['array_name']= $this->model_name->view_user('Tabelname',$id)->result();

If u want to Get Only single row Insted of result write ->row(); in above statement

now load your view and pass the $data as 2nd pararameter

$this->load->view('viewname',$data)

now in your VIEW

Acesss Array Like

  <?php foreach($array_name as $row)?>

edited May 1, 2013 at 9:29

David Rönnqvist

56.7k18 gold badges171 silver badges209 bronze badges

answered May 1, 2013 at 8:19

Nishant Lad

6162 gold badges7 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

CodeIgniter - Pass database array from model to controller and then view

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