~/www/catalog/view/theme/default/template/download/download.tpl
<?php echo $header; ?> <?php echo $content_top; ?> <div class="container"> <div class="row"><?php echo $column_left; ?> <?php if ($column_left && $column_right) { ?> <?php $class = 'col-sm-6'; ?> <?php } elseif ($column_left || $column_right) { ?> <?php $class = 'col-sm-9'; ?> <?php } else { ?> <?php $class = 'col-sm-12'; ?> <?php } ?> <div id="content" class="<?php echo $class; ?>"><?php //echo $my_custom_text; // var_dump ($download_result); if ($download_result->num_rows > 0) { // output data of each row foreach ($download_result as $row){ if ($row["download_id"]) { echo "<div class='download'>ID: " . $row["download_id"]. " - <a href='/system/download/" . $row["filename"]. "'>Download: " . $row["mask"] . "</a></div><br>"; } } } else { echo "0 results"; } ?><?php echo $content_bottom; ?></div> <?php echo $column_right; ?></div> </div> <?php echo $footer; ?>
~/www/catalog/controller/download/download.php
<?php class ControllerDownloadDownload extends Controller { public function index() { // set title of the page $this->document->setTitle("My Download Page"); // define children templates $data['column_left'] = $this->load->controller('common/column_left'); $data['column_right'] = $this->load->controller('common/column_right'); $data['content_top'] = $this->load->controller('common/content_top'); $data['content_bottom'] = $this->load->controller('common/content_bottom'); $data['footer'] = $this->load->controller('common/footer'); $data['header'] = $this->load->controller('common/header'); // set data to the variable $data['my_custom_text'] = "This is my custom page."; $sql = "SELECT * FROM oc_download"; $download_result = $this->db->query($sql); // var_dump ($download_result); $data['download_result'] = $download_result; // call the "View" to render the output if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/download/download.tpl')) { $this->response->setOutput($this->load->view($this->config->get('config_template') . '/template/download/download.tpl', $data)); } else { $this->response->setOutput($this->load->view('default/template/download/download.tpl', $data)); } } } ?>
go to http://icetrousa.com/index.php?route=download/download
reference:
http://code.tutsplus.com/articles/from-beginner-to-advanced-opencart-more-about-mvc–cms-21737