<?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>