<?php
include 'includes/header.php';
// create DB object
$db = new Database();
$pi = new Picture();
$ca = new Category();
// check url for _GET values
if (isset($_GET['category'])) {
$category = $_GET['category'];
$images = $db->select($pi->getPictureByCategory($category));
$cat = $db->select($ca->getCategoryById($category))->fetch_assoc();
} else {
if (isset($_GET['year'])) {
$year = $_GET['year'];
$images = $db->select($pi->getPictureByYear($year));
} else {
$images = $db->select($pi->getAllPictures());
}
}
$years = $db->select($pi->getPictureYears());
$picture_categories = $db->select($pi->getPictureCategories());
?>
<div class="container">
<div class="header">
<h1 class="title">Pictures</h1>
<?php
if (isset($year)) {
?>
<p class="lead description">Pictures taken in the year <?php
