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