<?php // class file require 'BasicDB.php'; // connection $db = new BasicDB('localhost', 'testdb', 'testuser', 'password'); // pagination example $totalRecord = $db->select('users')->from('count(user_id) as total')->total(); $pageLimit = 4; $pageParam = 'page'; $pagination = $db->pagination($totalRecord, $pageLimit, $pageParam); $query = $db->select('users')->orderby('user_id', 'DESC')->limit($pagination['start'], $pagination['limit'])->run(); print_r($query); echo $db->showPagination('http://localhost/test/?' . $pageParam . '=[page]');