zend framework mvc model and generating dynamic reports

Question

hi all,

i am using zend framework to develop my php applications using mvc model.

i want to generate some reports from database. but i dont know how to separate models and views in this case.

i fetch information from db, then i should iterate through them and make a html table. then pass this table to a class, making pdf file from the html table.

how should i make this html table in my view then pass it to my model and generating pdf file?!

Answer 1

//in controller
$this->view->data = $model->getData($parameter);

//in model
pulic function getData($parameter)
{
  $sql = $this->select()->where('parameter = ?',$parameter);
  return $this->fetchAll($sql);
}

//in view
...
foreach($this->data as $item)
{
  echo '<tr>';
  echo '<td>';
  echo $item->name;
  echo '</td>';
  echo '</tr>';
}