Source of: /ADI/displayTable_mysql/filmes2.php
<?php
require_once "HTML/Template/IT.php";
include 'inc/db.inc';
$db = dbconnect($hostname,$db_name,$db_user,$db_passwd);
if($db) {
$query = "SELECT * FROM filmes";
if(!($result = @ mysql_query($query,$db )))
showerror();
$template = new HTML_Template_IT('.');
$template->loadTemplatefile('Filmes2_TemplateIT.html', true, true);
$nrows = mysql_num_rows($result);
for($i=0; $i<$nrows; $i++) {
$tuple = mysql_fetch_array($result,MYSQL_ASSOC);
$template->setCurrentBlock("FILMES");
$template->setVariable('NOME', $tuple['nome']);
$template->setVariable('ANO', $tuple['ano']);
$template->setVariable('DURACAO', $tuple['duracao']);
$template->setVariable('ACORES', $tuple['acores']);
$template->setVariable('NOMEESTUDIO', $tuple['nomeestudio']);
$template->setVariable('NOMEREALIZADOR', $tuple['nomerealizador']);
$template->parseCurrentBlock();
} $template->show();
mysql_close($db);
} ?>