CodeIgniter call model to view?

Question

I have a view that maps a data table, this data is generated on the model. How can I name this model in my view for publication in my view ...? What is the equivalent of what I want to do with codeIgniter in php:

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

Answer 1

try using $CI =& get_instance()

then load your model as follows:

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

then call your model function as follows:

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

then display with foreach

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

Answer 2

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

,

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

:

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

Answer 3

. . , . ... foreach.

Answer 4

.

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

Answer 5

. : MVC

:

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

:

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

}