<?php
require '../utils/dbPDO.php';
require '../utils/validate.php';
$dalingk = new dalingkDB();
$db = $dalingk->connect();
$title = 'Product Categories';
$main = '<div class="categories">';
$main .= '<aside>';
foreach ($db->query("SELECT DISTINCT c.catname, c.catid FROM geekcategories c, geekproductcategories pc WHERE pc.catid = c.catid ORDER BY c.catname;") as $row) {
	$main .= "<div><a class=\"\" href='?catid=$row[catid]'>$row[catname]</a></div>";
}
$main .= "</aside>";
if (isset($_GET['catid'])) {
	$selection = htmlspecialchars($_GET['catid']);
	$query = $db->prepare("SELECT catname FROM geekcategories WHERE catid = ?;");
	$query->execute(array($_GET['catid']));
	$row = $query->fetch();
	$main .= "<div class=\"center selecteditem\">You selected <strong>$row[catname]</strong>.</div>";
} else {
    $main .= "<div class=\"right\">Select a category!</div>";
}

$main .= "</div>";
require '../utils/simpleTemplate.php';
?>
