<?php require_once dirname(__FILE__) . './vendor/autoload.php'; //autoload packages $db = new Database(); $item = new Item($db->conn); $category = new Category($db->conn); $stmt = $item->readAll(); $num = $stmt->rowCount(); //while ($row = $categories->fetch(PDO::FETCH_ASSOC)){ extract($row); //echo $name; //} //dump($categories); // page given in URL parameter, default page is one $page = isset($_GET['page']) ? $_GET['page'] : 1; $cat = isset($_GET['category']) ? $_GET['category'] : ''; // set number of records per page $records_per_page = 3; // calculate for the query LIMIT clause $from_record_num = $records_per_page * $page - $records_per_page; if ($cat != '') { } else { $categories = $category->readAll(); } $categories = $category->readAll(); $categoriess = $category->readAll(); require 'templates/header.php'; ?> <!--gallery--> <div class="gallery">