Example #1
0
<?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">