<?php require_once "Templates/MiniTemplator.class.php"; $Content = new MiniTemplator(); $Content->readTemplateFromFile("Templates/LoginPageTemplate.htm"); $Content->generateOutput(); ?>
$regionName = $row['region_name']; $t->setVariable("regionName", $regionName); $t->addBlock("region"); } // Query and forloop for wine grape variety dropdown values $grapeQuery = "select variety from grape_variety"; foreach ($db->query($grapeQuery) as $row) { $grapeVarName = $row['variety']; $t->setVariable("grapeVarName", $grapeVarName); $t->addBlock("grapeVar"); } // Query and forloop to determine max year $queryMaxYear = "SELECT MAX(year) FROM wine"; foreach ($db->query($queryMaxYear) as $row) { $maxYear = $row['MAX(year)']; $t->setVariable("maxYear", $maxYear); } // Query and forloop to determine min year $resultMinYear = "SELECT MIN(year) FROM wine"; foreach ($db->query($resultMinYear) as $row) { $minYear = $row['MIN(year)']; $t->setVariable("minYear", $minYear); } $db = null; // close the database connection } catch (PDOException $e) { echo $e->getMessage(); } // mini templator generateing output using asociated HTML page $t->generateOutput();