static function find_paginated($page = 1, $fields = "*", $where_clause = "", $order = "ASC")
{
$total_count = static::count_all();
$pagination = new Pagination($page, $total_count, ITEMS_PER_PAGE);
$query = "SELECT {$fields} FROM `" . static::$table_name . "` ";
$query .= $where_clause;
$query .= "ORDER BY `" . ID . "` {$order} ";
$query .= "LIMIT " . ITEMS_PER_PAGE . " ";
$query .= "OFFSET " . $pagination->offset();
return static::find_by_query($query);
}
/**
* Return a subset of property objects to use
* in pagination of records
* @param object $paginationObj A pagination object
* @return array An array of property objects
*/
public static function getSubsetOfProperties(Pagination $paginationObj)
{
$db = Database::getInstance();
$mysqli = $db->getConnection();
$sql = "SELECT * FROM property p ORDER BY name ASC ";
$sql .= "LIMIT " . $mysqli->real_escape_string($paginationObj->per_page) . " ";
$sql .= "OFFSET " . $paginationObj->offset();
return static::findBySql($sql);
}
redirect_to($_SERVER['PHP_SELF']);
die;
}
}
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
$per_page = JOBS_PER_SEARCH;
$total_count = Job::count_all();
$smarty->assign('total_count', $total_count);
$smarty->assign('page', $page);
$pagination = new Pagination($page, $per_page, $total_count);
$smarty->assign('previous_page', $pagination->previous_page());
$smarty->assign('has_previous_page', $pagination->has_previous_page());
$smarty->assign('total_pages', $pagination->total_pages());
$smarty->assign('has_next_page', $pagination->has_next_page());
$smarty->assign('next_page', $pagination->next_page());
$offset = $pagination->offset();
$sql = " SELECT * FROM " . TBL_JOB;
$sql .= " LIMIT {$per_page} ";
$sql .= " OFFSET {$offset} ";
$lists = Job::find_by_sql($sql);
$manage_lists = array();
if ($lists && is_array($lists)) {
$i = 1;
foreach ($lists as $list) {
unset($employer);
if (!empty($list->fk_employer_id) && $list->fk_employer_id != 0) {
$employer = Employer::find_by_id($list->fk_employer_id);
}
$manage_lists[$i]['id'] = $list->id;
$manage_lists[$i]['job_title'] = $list->job_title;
$manage_lists[$i]['spotlight'] = $list->spotlight == "Y" ? "Spotlight Job" : "Standard Job";
<?php
include "includes/header.php";
$page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
$items_per_page = 2;
$items_total_count = Photo::count_all();
$pages = ceil($items_total_count / $items_per_page);
$paginate = new Pagination($page, $items_per_page, $items_total_count);
$query = "SELECT * FROM photos ";
$query .= " LIMIT {$items_per_page} ";
$query .= "OFFSET {$paginate->offset()}";
$photos = Photo::find_this_query($query);
?>
<div class="row">
<!-- Blog Entries Column -->
<div class="col-md-12">
<div class="thumbnails row">
<?php
foreach ($photos as $photo) {
?>
<div class="col-xs-6 col-md-3">
<a href="<?php
echo 'photo.php?id=' . $photo->id;
?>
" class="thumbnail">
<img class="gallery_photo img-responsive"
src="<?php
/**
* Add pagination
*
* @param int $limit the number of items per page
* @param array $options and optional array with options for the pagination class
* @return object a sliced set of data
*/
public function paginate($limit, $options = array())
{
if (is_a($limit, 'Pagination')) {
$this->pagination = $limit;
return $this;
}
$pagination = new Pagination($this->count(), $limit, $options);
$pages = $this->slice($pagination->offset(), $pagination->limit());
$pages->pagination = $pagination;
return $pages;
}
<?php
require_once '../includes/initialize.php';
?>
<?php
include_layout_template("header.php");
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$record_no = 3;
$total_records = Photograph::count();
// $photo_object = new Photograph();
// $photos = $photo_object->find_all();
$pagination = new Pagination($page, $record_no, $total_records);
$sql_query = "SELECT * FROM photograph ";
$sql_query .= "LIMIT {$record_no} ";
$sql_query .= "OFFSET {$pagination->offset()} ";
$photos = Photograph::find_by_sql($sql_query);
?>
<h2>Photos</h2>
<?php
echo output_message($session->set_get_message());
?>
<?php
foreach ($photos as $photo) {
?>
<div style="float:left;margin-left: 20px; display:inline;">
<a href="photo.php?id=<?php
echo $photo->id;
?>
">
<img src="<?php
print_r($ques_status);
echo "<br/>";*/
$ques_options = $_SESSION['temp_options'];
$pg = new Pagination($page, $per_page, $total_count);
$tt = new Test();
if (isset($_SESSION['first_time'])) {
$tt->Review_Test();
} else {
unset($_SESSION['first_time']);
}
$ques_set = $tt->GetAllQues();
?>
<table width="933" border="0" cellspacing="0" cellpadding="0" class="revtab">
<?php
$check = $per_page * $page > $total_count ? $total_count : $per_page * $page;
for ($i = $pg->offset(); $i < $check; $i++) {
$id = $ques_ids[$i];
?>
<tr>
<td width="53"><?php
echo $i + 1;
?>
</td>
<td width="687" ><?php
echo $ques_set[$i];
?>
</td>
<td><input type="button" class="button orange" onClick="call_test(<?php
echo $id;
?>
,'<?php
$updated_session = [SessionOperator::SORT => $sort];
} else {
HelperOperator::redirectTo("../views/search_view.php");
return;
}
}
}
$cats = getCatIdAndType($searchCategory);
// Set up pagination object
$total = QueryOperator::countFoundAuctions(buildQuery($searchString, $cats, null));
$page = isset($_GET["page"]) ? $_GET["page"] : 1;
$page = $page <= $total ? $page : 1;
$per_page = 15;
$pagination = new Pagination($page, $per_page, $total);
// Get paginated search results
$catsAndAuctions = QueryOperator::searchAuctions(buildQuery($searchString, $cats, $sort, $per_page, $pagination->offset()));
// Update search sessions
$updated_session = array_merge([SessionOperator::SEARCH_RESULT => $catsAndAuctions], $updated_session);
$updated_session = array_merge([SessionOperator::SEARCH_PAGINATION => $pagination], $updated_session);
SessionOperator::setSearch($updated_session);
// Return back to search page
HelperOperator::redirectTo("../views/search_view.php");
function buildQuery($searchString, $searchCategory, $sortOption, $limit = null, $offset = null)
{
$query = null;
// Prepare count query
if (is_null($limit) && is_null($offset)) {
$query = "SELECT COUNT(*) ";
} else {
$query = "SELECT auctions.auctionId, quantity, startPrice, reservePrice, startTime,\n endTime, itemName, itemBrand, itemDescription, items.image, auctions.views,\n item_categories.categoryName as subCategoryName, superCategoryName,\n item_categories.superCategoryId, item_categories.categoryId,\n conditionName, countryName, COUNT(DISTINCT (bids.bidId)) AS numBids,\n COUNT(DISTINCT (auction_watches.watchId)) AS numWatches,\n MAX(bids.bidPrice) AS highestBid,\n case\n when MAX(bids.bidPrice)is not null THEN MAX(bids.bidPrice)\n else startPrice\n end AS currentPrice ";
}
?>
</a> </li>
<?php
}
?>
</ul>
</div>
<div class="rightcol">
<div id="change"><!-- this is to load ajax page when required-->
<p class="name" style="margin-top:-2px;"><span class="txtshd"><?php
echo $user->fullname;
?>
</span ></p>
<?php
$test_record = $test->last_test_record($_SESSION['owner_id'], $_SESSION['uname'], $per_page, $pagination->offset());
if ($test_record) {
echo '<table class="records">';
echo "<tr style='font-size:18px;' align='center'><td>Previous Records:</td><td></td><td></td></tr>";
echo "<tr>";
echo "<th>";
echo "Course";
echo "</th>";
echo "<th>";
echo "Date Of Test";
echo "</th>";
echo "<th>";
echo "Score Obtained";
echo "</th>";
echo "<th>";
echo "Questions Correct";
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Menu Name</th>
<th style="color:green">Description</th>
<th style="color:green">Price</th>
<th style="color:red;" colspan="2">Actions</th>
</tr>
</thead>
</tbody>
<?php
$p = new Menu();
$list_of_menu = array();
$list_of_menu = $p->loadMenu($pagination->per_page, $pagination->offset());
foreach ($list_of_menu as $menu) {
?>
<tr>
<td><?php
echo $menu->menu_name;
?>
</td>
<td><?php
echo $menu->menu_description;
?>
</td>
<td><?php
echo $menu->menu_price;
?>
<?php
require_once '../includes/initialize.php';
//Paging
$page = !empty($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 3;
$total_count = Photograph::count_all();
$pagination = new Pagination($page, $per_page, $total_count);
$sql = "select * from photographs limit {$per_page} offset {$pagination->offset()}";
$photos = Photograph::find_by_sql($sql);
include_layout_template("header.php");
?>
<p></p><a href="./admin/list_photos.php">Show Lists</a></p>
<b/>
<?
foreach ($photos as $photo): ?>
<div style="float: left; margin-left:20px;">
<a href="photo.php?id=<?= $photo->id ?>">
<img src="../<? echo $photo->image_path(); ?>" width="150"/>
</a>
<p><?= $photo->caption ?></p>
</div>
<?php endforeach; ?>
public static function paginer(Condition $listeConditions = NULL, $nbElementsParPage, $pageCourante = 1)
{
// Création d'un objet Pagination qui contiendra toutes les caractéristiques
$pagination = new Pagination();
// On définit ensuite les caractéristiques de la pagination
$pagination->setNbElementsParPage($nbElementsParPage);
$pagination->setNbElementsTotal(self::compter());
$pagination->setPageCourante($pageCourante);
$pagination->calculer();
$pagination->setListeElements(self::obtenirTout($listeConditions, $pagination->offset(), $nbElementsParPage));
return $pagination;
}
function getSearchResultLoop($s, $max_pp = null)
{
if (!isset($this->p)) {
$s = $this->conn->real_escape_string(urldecode($s));
$loop_first_search_query = "SELECT * FROM c_posts WHERE (post_content LIKE '%{$s}%' OR post_excerpt LIKE '%{$s}%' OR post_title LIKE '%{$s}%' OR post_description LIKE '%{$s}%' OR link_title LIKE '%{$s}%' OR tags LIKE '%{$s}%') AND post_status <> 'Initialized'";
$this->res = $this->conn->query($loop_first_search_query);
dbQueryCheck($this->res, $this->conn);
$this->search_res_count = $this->res->num_rows;
// set search result count, should be accessed only after function call
$this->p = 'set';
}
if (!isset($loop_search_query)) {
$s = $this->conn->real_escape_string(urldecode($s));
$pagination = new Pagination($max_pp, $this->search_res_count);
$loop_search_query = "SELECT * FROM c_posts WHERE (post_content LIKE '%{$s}%' OR post_excerpt LIKE '%{$s}%' OR post_title LIKE '%{$s}%' OR post_description LIKE '%{$s}%' OR link_title LIKE '%{$s}%' OR tags LIKE '%{$s}%') AND post_status <> 'Initialized' ";
$loop_search_query .= "LIMIT {$pagination->per_page} ";
$loop_search_query .= "OFFSET {$pagination->offset()}";
}
if (!isset($this->j)) {
$this->res = $this->conn->query($loop_search_query);
dbQueryCheck($this->res, $this->conn);
$this->j = 'set';
}
$this->total_pages = $pagination->totalPages();
$this->hasPreviousPage = $pagination->hasPreviousPage();
$this->hasNextPage = $pagination->hasNextPage();
$this->previousPage = $pagination->previousPage();
$this->nextPage = $pagination->nextPage();
return $this->res->fetch_assoc();
}
$rel_id = get_related_sub_cat($mainct);
$tbl_name = "postcode_location";
$adjacents = 3;
$sql_search_view1 = "SELECT * FROM postcode_location INNER JOIN ad_title_description ON ad_title_description.postcode_loaction_id = postcode_location.id WHERE postcode_location.status ='1' AND postcode_location.{$df}=" . $sub_cat_id . " AND postcode_location.id !=" . $newpostid;
//$sub_cat_id;
$total_pages = mysql_query($sql_search_view1);
$total_num_rows = mysql_num_rows($total_pages);
$total_pages = $total_num_rows;
$page = !empty($_GET['page']) ? $_GET['page'] : 1;
// Setting a default value to the page
$per_page = 10;
// message to show per page
$pagination = new Pagination($page, $per_page, $total_num_rows);
// create an object of clas agination
// end of pagination default variables
$sql_search_view = "SELECT * FROM postcode_location INNER JOIN ad_title_description ON ad_title_description.postcode_loaction_id = postcode_location.id WHERE postcode_location.status ='1' AND postcode_location.{$df}=" . $sub_cat_id . " AND postcode_location.id !=" . $newpostid . " LIMIT {$per_page} OFFSET {$pagination->offset()}";
$result_search_view = mysql_query($sql_search_view);
$num_rows_views = mysql_num_rows($result_search_view);
if ($num_rows_views > 0) {
while ($row_search_view = mysql_fetch_array($result_search_view)) {
$user_id = $row_search_view['user_id'];
$post_id = $row_search_view['postcode_loaction_id'];
$published_date = $row_search_view['date'];
$town = $row_search_view['town'];
$daysago = (strtotime($cdate) - strtotime($published_date)) / (60 * 60 * 24);
$select_image_query = "SELECT postcode_loaction_id,file_name FROM users_images WHERE postcode_loaction_id='" . $post_id . "' ";
$run_image_query = mysql_query($select_image_query);
$fetch_image_query = mysql_fetch_array($run_image_query);
$image_name = $fetch_image_query['file_name'];
//End Image//
$title = $row_search_view['title'];
<?php
require_once $libpath = substr(str_replace('\\', '/', __DIR__), 0, -28) . 'library/initialize.php';
if (!$session->is_logged_in()) {
redirect_to(HOME . "login");
}
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) htmlspecialchars($_GET['page']) : 1;
// 2. records per page ($per_page)
$per_page = 7;
// 3. Find the total count of ads/photos/products
$ads = Product::find_by_field("user_id", $_SESSION['user_id']);
$total_count = 0;
if ($ads) {
foreach ($ads as $ad) {
$total_count++;
}
} else {
$ads = [];
}
$pagination = new Pagination($page, $per_page, $total_count);
$products = Product::find_by_field("user_id", $_SESSION['user_id'], ["limit" => $per_page, "offset" => $pagination->offset()]);
if (!$products) {
$products = [];
}
include $dir_admin . 'dashboard.php';
<div class="col-xs-4">
<a href="#myModalsignup" data-toggle="modal"><button class="btn btn-success"><span class="glyphicon glyphicon-plus"></span>Add New Event</button></a>
<h3>Active event Lists</h3>
<tbody>
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Event Name</th>
<th style="color:red;"colspan="2">Actions</th>
</tr>
</thead>
</tbody>
<?php
$ev = new Event();
$list_of_event = array();
$list_of_event = $ev->loadEvent($pagination->per_page, $pagination->offset());
foreach ($list_of_event as $event) {
?>
<tr>
<td><?php
echo $event->event_name;
?>
</td>
<td>
<a href="event_modal.php?event_id=<?php
echo $event->event_id;
?>
" data-toggle="modal">
<button id="btn_edit" class="btn btn-primary">
<span class="glyphicon glyphicon-edit"></span> Edit
</button>
}
}
$tbl_name = "postcode_location";
$adjacents = 3;
$sql_search_view1 = "SELECT *\n\nFROM postcode_location\n\nINNER JOIN ad_title_description ON ad_title_description.postcode_loaction_id = postcode_location.id WHERE postcode_location.status ='1'\n\nAND postcode_location.{$df} IN (" . $urlids . ") order by postcode_location.date desc";
$total_pages = mysql_query($sql_search_view1);
$total_num_rows = mysql_num_rows($total_pages);
$total_pages = $total_num_rows;
$page = !empty($_GET['page']) ? $_GET['page'] : 1;
// Setting a default value to the page
$per_page = 10;
// message to show per page
$pagination = new Pagination($page, $per_page, $total_num_rows);
// create an object of clas agination
// end of pagination default variables
$sql_search_view = "SELECT * FROM postcode_location INNER JOIN ad_title_description ON ad_title_description.postcode_loaction_id = postcode_location.id WHERE postcode_location.status ='1' AND postcode_location.{$df} IN (" . $urlids . ") order by postcode_location.date desc LIMIT {$per_page} OFFSET {$pagination->offset()}";
$result_search_view = mysql_query($sql_search_view);
$mappins = mysql_query($sql_search_view);
$mrk_cnt = 0;
while ($obj = mysql_fetch_array($mappins)) {
$lat[$mrk_cnt] = $obj['lat'];
// save the lattitude
$lng[$mrk_cnt] = $obj['lang'];
// save the longitude
$inf[$mrk_cnt] = $obj['title'];
// save the info-window
$mrk_cnt++;
// increment the marker counter
}
//$res->close();
// Now we have the lattitude, longitude and info-window text for each marker
<h3>List of Town</h3>
<tbody>
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Town Name</th>
<th style="color:red;" >Actions</th>
</tr>
</thead>
</tbody>
<?php
$t = new Address();
$list_of_town = array();
$list_of_town = $t->loadAllTowns($pagination->per_page, $pagination->offset());
foreach ($list_of_town as $town) {
?>
<tr>
<td><?php
echo $town->town_name;
?>
</td>
<td>
<a href="town_modal.php?town_id=<?php
echo $town->town_id;
?>
" data-toggle="modal">
<button id="btn_edit" class="btn btn-primary">
<span class="glyphicon glyphicon-edit"></span> Edit
<hr/>
<tbody>
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Customer Name</th>
<th style="color:green">Email Address</th>
<th style="color:green">Message</th>
<th style="color:red;"colspan="2">Actions</th>
</tr>
</thead>
</tbody>
<?php
$ev = new Comments();
$list_of_comment = array();
$list_of_comment = $ev->loadComments($pagination->per_page, $pagination->offset());
foreach ($list_of_comment as $comm) {
?>
<tr>
<td><?php
echo $comm->customer_name;
?>
</td>
<td><?php
echo $comm->email;
?>
</td>
<td><?php
echo $comm->message;
?>
</td>
<?php
//pagination code
$current_page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
$per_page = 20;
$total_count = $route_object->count_all();
$pagination = new Pagination($current_page, $per_page, $total_count);
$sql = "SELECT * FROM routes";
$sql .= " LIMIT " . $per_page;
$sql .= " OFFSET " . $pagination->offset();
$routes = $route_object->find_by_sql($sql);
//check login
if ($session->is_logged_in()) {
if ($session->object_type == 6) {
//commuter
$user = $commuter_object->find_by_id($_SESSION['id']);
$profile_picture = $photo_object->get_profile_picture($session->object_type, $user->id);
}
}
<a href="#myModalsignup" data-toggle="modal"><button class="btn btn-success"><span class="glyphicon glyphicon-plus"></span>Add New Member</button></a>
<h3>Active member Lists</h3>
<tbody>
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Member Name</th>
<th style="color:red;" colspan="2">Actions</th>
</tr>
</thead>
</tbody>
<?php
$add = new Member();
$list_of_member = array();
$list_of_member = $add->loadMember($pagination->per_page, $pagination->offset());
foreach ($list_of_member as $member) {
?>
<tr>
<td><?php
echo $member->member_name;
?>
</td>
<td>
<a href="../functions/inactive_teamMember.php?id=<?php
echo $member->member_id;
?>
">
<button class="btn btn-danger"><span class="glyphicon glyphicon-remove-circle">
</span> Set to Inactive</button></a>
public static function find_all_pagination($page, $per_page, $total_count, $myid)
{
$pagination = new Pagination($page, $per_page, $total_count);
return self::find_by_sql("SELECT *\n\t\tFROM exercise\n\t\tHAVING plan_id != {$myid}\n\t\tORDER BY latitude\n\t\tLIMIT {$per_page}\n\t\tOFFSET {$pagination->offset()}");
}
<h3>List of Barangay</h3>
<tbody>
<table class="table table-striped table-bordered table-hover table-responsive">
<thead>
<tr>
<th style="color:green">Barangay Name</th>
<th style="color:red;" >Actions</th>
</tr>
</thead>
</tbody>
<?php
$b = new Address();
$list_of_brgy = array();
$list_of_brgy = $b->loadAllBarangays($pagination->per_page, $pagination->offset());
foreach ($list_of_brgy as $brgy) {
?>
<tr>
<td><?php
echo $brgy->brgy_name;
?>
</td>
<td>
<a href="barangay_modal.php?brgy_id=<?php
echo $brgy->brgy_id;
?>
" data-toggle="modal">
<button id="btn_edit" class="btn btn-primary">
<span class="glyphicon glyphicon-edit"></span> Edit
<?php
require_once $libpath = substr(str_replace('\\', '/', __DIR__), 0, -29) . 'library/initialize.php';
// 1. the current page number ($current_page)
$page = !empty($_GET['page']) ? (int) htmlspecialchars($_GET['page']) : 1;
// 2. records per page ($per_page)
$per_page = 6;
// 3. total record count ($total_count)
$total_count = Product::count_all();
$pagination = new Pagination($page, $per_page, $total_count);
$products = Product::find_all(["limit" => $per_page, "offset" => $pagination->offset()]);
include $dir_public . 'index.php';
case $sec:
$sec_name = $s['title'];
$QNA->section = $s['id'];
$qs = $QNA->get_questions();
$count = count($qs);
$pag = new Pagination($count, $cp, $rpp);
$offset = $pag->offset();
$qs = $QNA->get_questions($rpp, $offset);
break 2;
// breaks out of the two casses (foreach and switch)
// breaks out of the two casses (foreach and switch)
default:
$qs = $QNA->get_questions();
$count = count($qs);
$pag = new Pagination($count, $cp, $rpp);
$offset = $pag->offset();
$qs = $QNA->get_questions($rpp, $offset);
$sec_name = 'All';
break;
}
}
$pageTitle = "Stories";
$sec = "questions";
include ROOT_PATH . 'inc/head.php';
?>
<body>
<div class="ui container section">
<div class="ui large search" id="ent">
<div class="ui icon input">
<input type="text" autocomplete="off" id="sec_ent">
</div>
$order_name = !empty($_GET["order_name"]) ? $_GET["order_name"] : 'id';
$order_type = !empty($_GET["order_type"]) ? $_GET["order_type"] : 'ASC';
//echo get_where_string($class_name);
$page = !empty($_GET['page']) ? (int) $_GET["page"] : 1;
$per_page = 20;
$where = get_where_string($class_name);
$total_count = $class_name::count_all_where($where);
$pagination = new Pagination($page, $per_page, $total_count);
require_once LIB_PATH . DS . 'download' . DS . 'download_csv.php';
$sql = "SELECT * FROM {$table_name} ";
$sql .= " " . get_where_string($class_name);
if (isset($order_name)) {
$sql .= " ORDER BY {$order_name} {$order_type} ";
}
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
//echo "<p>$sql</p>";
//unset($_GET);
$result_class = $class_name::find_by_sql($sql);
$query_string = remove_get(array('view', 'page'));
$view_full_table = !empty($_GET) ? (int) $_GET["view"] : 0;
if ($view_full_table == 1) {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(0);
$page_link_text = $class_name::$page_name . " short view";
//$add_view="&view=".u(1);
$offset = "col-md-offset-2";
} else {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(1);
$page_link_text = $class_name::$page_name . " full view";
$offset = '';
}
public function findWithPaginate($table, $page, $per_page)
{
$total = $this->countAll($table)->total;
$p = new Pagination($page, $per_page, $total);
$sql = "SELECT * FROM {$table} WHERE deleted_at IS NULL ORDER BY created_at DESC LIMIT :per_page OFFSET :offset";
//
$q = $this->conn->prepare($sql);
$q->execute(array(':per_page' => $per_page, ':offset' => $p->offset()));
$count = $q->rowCount();
if ($count > 0) {
while ($r = $q->fetch(PDO::FETCH_OBJ)) {
$data[] = $r;
}
$data[] = $p;
return $data;
} else {
return false;
}
}
