include "function/pagination.php";
$strSQL = "SELECT id, title, projection, img, view, movie FROM `post` ";
$objQuery = $db->query($strSQL);
$num_rows = $objQuery->num_rows;
$per_page = 48; // Per page
$page = isset($_GET["page"]) ? $_GET["page"] : '';
if ($page == '') {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
$page_start = (($per_page * $page) - $per_page);
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
$num_pages = (int) $num_pages;
}
$strSQL .= " ORDER BY id DESC LIMIT $page_start , $per_page";
$objQuery = $db->query($strSQL);
while ($objResult = $objQuery->fetch_assoc()) {
$urlpost = rewrite($objResult['title']);
?>
}?>
$pages = new Paginator;
$pages->items_total = $num_rows;
$pages->mid_range = 10;
$pages->current_page = $page;
$pages->default_ipp = $per_page;
$pages->url_next = $_SERVER["PHP_SELF"] . "?QueryString=value&Page=";
$pages->paginate();
echo $pages->display_pages()
?>