<?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();
