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
echo $year;
?>
<?php
include 'includes/header.php';
$db = new Database();
$pi = new Picture();
$ca = new Category();
$ob = new Obituary();
$us = new User();
$st = new Story();
$stories = $db->select($st->getStoriesAndCategories());
$users = $db->select($us->getAllUsers());
$categories = $db->select($ca->getAllCategories());
$obituaries = $db->select($ob->getAllObituaries());
$images = $db->select($pi->getAllPictures('DESC'));
?>
<div class="col-md-12">
<h3>Stories</h3>
<table class="table table-striped">
<tr>
<th>Story ID#</th>
<th>Title</th>
<th>Category</th>
<th>Submitter</th>
<th>Date</th>
</tr>
<?php
while ($row = $stories->fetch_assoc()) {
?>
<tr>
<td><?php
