<?php
$photos = Photo::find_all();
?>
<!-- Navigation -->
<?php
include "includes/navigation.php";
?>
<?php
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
$items_per_page = 4;
$total_items = count($photos);
$paginate = new Paginate($page, $items_per_page, $total_items);
$sql = "SELECT * FROM photos LIMIT {$items_per_page} OFFSET {$paginate->offset()}";
$photos = Photo::find_this_query($sql);
$total_pages = $paginate->total_pages();
?>
<!-- Page Content -->
<div class="container">
<div class="row">
<div class="jumbotron">
<h1>Welcome!</h1>
</div>
<div class="col-md-12">
<div class="thumbnails row">
<?php
foreach ($photos as $photo) {
$id = $photo->photo_id;
$photo_title = $photo->title;
$photo_path = $photo->image_path();
function paginate_total_pages()
{
return Paginate::total_pages();
}
/**
* Count total pages on last find
*
* @return int
*/
static function total_pages()
{
if (!empty(self::$total_pages)) {
return self::$total_pages;
}
return self::$total_pages = ceil(self::total_records() / self::limit());
}