<?php
require_once "../includes/initialize.php";
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
// 2. records per page ($per_page)
$per_page = 3;
// 3. total record count ($total_count)
$total_count = Photograph::count_all();
// Find all photos
// use pagination instead
//$photos = Photograph::find_all();
$pagination = new Pagination($page, $per_page, $total_count);
// Instead of finding all records, just find the records
// for this page
$sql = "SELECT * FROM photographs ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$photos = Photograph::find_by_sql($sql);
// Need to add ?page=$page to all links we want to
// maintain the current page (or store $page in $session)
?>
<?php
include_layout_template('header.php');
?>
<?php
foreach ($photos as $photo) {
?>
<div style="float: left; margin-left: 20px;">
<?php
require_once "../includes/initialize.php";
/**
* First I need to get the page number and in the event it is empty, like on
* first getting to the site.
* @var int
*/
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
$per_page = 5;
$count = Photograph::count_all();
// $photos = Photograph::find_all();
$pagination = new Pagination($page, $per_page, $count);
$sql = $pagination->build_sql("photographs");
$photos = Photograph::find_by_sql($sql);
?>
<?php
include_layout_template("header.php");
?>
<h2>Photographs</h2>
<?php
echo output_message($message);
?>
<div>
<?php
foreach ($photos as $photo) {
?>
<div id="photo">
<figure>
