user::paginate PHP Method

user Class Documentation Usage Examples Of user::paginate Show file Open project: anchorcms/anchor-cms

paginate() public static method

public static paginate ( $page = 1, $perpage = 10 ) 
    public static function paginate($page = 1, $perpage = 10)
    {
        $query = Query::table(static::table());
        $count = $query->count();
        $results = $query->take($perpage)->skip(($page - 1) * $perpage)->sort('real_name', 'desc')->get();
        return new Paginator($results, $count, $page, $perpage, Uri::to('admin/users'));
    }

Usage Example

Example #1
0
<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
function __autoload($class)
{
    require 'include/' . strtolower($class) . '.class.php';
}
$user_obj = new user();
$current_page = 1;
$rec_per_page = 3;
$total_records = $user_obj->paginate();
$total_page_links = ceil($total_records / $rec_per_page);
if (isset($_POST['getCount'])) {
    echo $user_obj->paginate();
    exit;
}
if (isset($_POST['current_page']) && isset($_POST['rec_per_page'])) {
    $current_page = $_POST['current_page'];
    $rec_per_page = $_POST['rec_per_page'];
    $users = $user_obj->getUsers($current_page, $rec_per_page);
    echo json_encode($users);
    exit;
} else {
    $users = $user_obj->getUsers($current_page, $rec_per_page);
}
?>

<!DOCTYPE html>
user
paginate
search