How can I pass data from database to my HTML template without putting PHP code in my HTML file.
Thanks.
This is my controller
public function index($aRequest)
{
$oModel = new todoModel();
$aTodoList = $oModel->getTodoList();
return array('type' => 'view', 'view' => 'view/index.tpl', 'data' =>
array('aTodoList' => $aTodoList));
}
my Model
public function getTodoList()
{
$aTodoList = [];
$this->oConnection->setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
$sQuery = 'SELECT * FROM t_todolist';
foreach ($this->oConnection->query($sQuery) as $aTodo) {
array_push($aTodoList, array(
'sequence' => $aTodo['sequence'],
'todo' => $aTodo['todo']
));
}
print_r($aTodoList);
return $aTodoList;
}
my tpl -(this is working but it has php code inside)
<div id="todo_list">
<ul id="todo_list_ul">
<?php
foreach ($aTodoList as $aTodo) {
?>
<!-- list here -->
<li><?php echo $aTodo['todo'];?> <a href=""
class="todo_update">update</a> <a class="todo_delete" href="">delete</a></li>
<?php
}
?>
</ul>
<button id="todo_create">create</button>
</div>