Source of: /ADI/embeddedLinks/filmesPorEstudio.php
<?php
require_once "HTML/Template/IT.php";
include 'db.inc';
include 'error.inc';
$template = new HTML_Template_IT('.');
$template->loadTemplatefile('filmesPorEstudio_template.html', true, true);
$estudio = $_GET["estudio"];
$bd = dbconnect($connection_string);
if($bd) {
$query = "SELECT nome, ano
FROM filmes
WHERE nomeEstudio = '$estudio'";
$result = pg_query($bd, $query );
$nrows = pg_num_rows($result);
$template->setCurrentBlock("MENSAGEM");
if( $nrows == 0 )
$template->setVariable('MESSAGE', "Nao ha nenhum filme do estudio $estudio");
else {
$template->setVariable('MESSAGE', "Filmes produzidos pelo estudio $estudio");
$template->parseCurrentBlock();
for($i=0; $i<$nrows; $i++) {
$tuple = pg_fetch_array($result,$i);
$template->setCurrentBlock("FILMES");
$template->setVariable('NOME', $tuple['nome']);
$template->setVariable('ANO', $tuple['ano']);
$template->parseCurrentBlock();
}
}
$template->show();
pg_close($bd);
}
?>