CODEWITHSUNDEEP
phpcodeigniter
Fatim
Fatim

Reputation: 163

CodeIgniter calling model on view?

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;
      }

Upvotes: 5

Views: 39385

Answers (5)

Engr Saddam Zardari
Engr Saddam Zardari

Reputation: 1049

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'];                      
    }
?>

Upvotes: 3

Mohammed Sufian
Mohammed Sufian

Reputation: 1781

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 }

Upvotes: 19

The Odd Developer
The Odd Developer

Reputation: 929

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.

Upvotes: 1

Jice06
Jice06

Reputation: 221

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;
}

Upvotes: 2

Igor S.
Igor S.

Reputation: 3350

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) {

}

Upvotes: 0

Related Questions