CodeIgniter calling model on view?

Question

I have a view which comport a table of data, this data is generated on a model. How can I call this model in my view to be posted on my view...? That's the Equivalent of what I want to do with codeIgniter on php :

while($row = mysql_fetch_array($requet))
      {
// code of displaying my data;
      }

score 19 · Answer 1 · answered Jan 15 '14 at 17:10

19

try using $CI =& get_instance()

then load your model like this:

$CI->load->model('someModel')

then call your model function like this:

$result = $CI->someModel->somefunction()

then display using foreach

foreach($result as $row){ $row->somecolumnName }

answered Jan 15 '14 at 17:10

Mohammed Sufian

1,743
6
35
62

score 3 · Answer 2 · answered Jul 14 '16 at 20:19

3

i called model method like this.

<?php
$CI =& get_instance();
$CI->load->model('MyModel');
$result= $CI->MyModel->MyMethod($parameter)->result_array();        
  foreach($result as $row){ 
         echo $row['column_name'];                      
    }
?>

answered Jul 14 '16 at 20:19

Engr Saddam Zardari

1,057
1
14
27

no need to load model. check this: https://stackoverflow.com/a/56981979/3278639 – Mustafa May 04 '21 at 00:41

Jice06 · Answer 3 · 2014-01-15T14:53:50.087

2

I think it is not a good idea to call a model directly from the view.

Your controller must get data from the model then send it to your view

$this->load->model('my_model');
$my_data['my_array'] = $this->my_model->get_my_data();
$this->load->view('your_view', $my_data);

In your view use it like this

foreach($my_array as $item){
    echo $item;
}

edited Jan 15 '14 at 14:53

answered Jan 15 '14 at 14:48

Jice06

221
2
4

In your view use it like this foreach($my_array as $item){ } – Jice06 Jan 15 '14 at 14:56
There are pages that you may require to run directly in the model, that is why he is asking. For instance, sidebar that needs to be on each page. Getting values from every controller of the page you want to display may not be effective – kimoduor Sep 28 '21 at 13:29

score 1 · Answer 4 · answered Jan 15 '14 at 14:54

1

First Model interacts withe the database.Then load the model and access relevant function in your controller.Finally load the data to view from the controller.That's it...you can show the data simply in a foreach loop.

answered Jan 15 '14 at 14:54

CodeCanyon

929
2
11
36

score 0 · Answer 5 · answered Jan 15 '14 at 14:48

0

You can call model functions form view. Remember: This solution is against MVC pattern

Model:

function getdata() {
  $query = $this->db->query($sql);
  return $query->result_array();
}

View:

foreach($this->modelname->getdata() as $item) {

}

answered Jan 15 '14 at 14:48

Igor S.

3,332
1
25
33

1

@voodoo417 I clearly stated it's against MVC pattern. – Igor S. Jan 15 '14 at 14:52
thank u , can u tell me how can i call attributs ? in my view ? – Fatim Jan 15 '14 at 15:00
@Fatim $item is single row from DB. You can use it inside loop. – Igor S. Jan 15 '14 at 15:04

CodeIgniter calling model on view?

5 Answers5

Linked