Source of: /ADI/displayTable_mysql/filmes6_action.php
<?php
require_once "HTML/Template/IT.php";
include 'inc/db.inc';
echo "<pre>\n\$_SERVER \n";
foreach ($_SERVER as $k => $v) {
echo "{$k} => {$v}";
print "\n";
}
print "\n \n";
echo "\$_GET \n";
foreach ($_GET as $k => $v) {
echo "{$k} => {$v}";
print "\n";
}
print "\n \n";
echo "\$_POST \n";
foreach ($_POST as $k => $v) {
echo "{$k} => {$v}";
print "\n";
}
print "\n \n";
echo "\$_COOKIE \n";
foreach ($_COOKIE as $k => $v) {
echo "{$k} => {$v}";
print "\n";
}
echo "</pre>\n";
function displayFilmes($result)
{
$template = new HTML_Template_IT('.');
$template->loadTemplatefile('filmes6_action_templateIT.html', true, true);
$nrows = mysql_num_rows($result);
if( $nrows > 0 ) {
for($i=0; $i<$nrows; $i++) {
$tuple = mysql_fetch_array($result,MYSQL_ASSOC);
$nome = $tuple['nomefilme'];
$ano = $tuple['anofilme'];
$template->setCurrentBlock("FILMES");
$template->setVariable('NOMEFILME', $nome);
$template->setVariable('ANO', $ano);
$template->parseCurrentBlock();
} } $template->show();
}
$db = dbconnect($hostname,$db_name,$db_user,$db_passwd);
if($db) {
if (isset($_POST["nomeactor"])) {
$query = 'SELECT nomefilme, anofilme FROM participa WHERE nomeactor="' . $_POST["nomeactor"] . '"';
if(!($result = @ mysql_query($query,$db )))
showerror();
displayFilmes($result);
} mysql_close($db);
} ?>