| Server IP : 127.0.0.2 / Your IP : 18.222.226.15 Web Server : Apache/2.4.18 (Ubuntu) System : User : www-data ( ) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : disk_free_space,disk_total_space,diskfreespace,dl,exec,fpaththru,getmyuid,getmypid,highlight_file,ignore_user_abord,leak,listen,link,opcache_get_configuration,opcache_get_status,passthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,php_uname,phpinfo,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,pclose,popen,proc_open,proc_close,proc_get_status,proc_nice,proc_terminate,shell_exec,source,show_source,system,virtual MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/admin/ |
Upload File : |
<?php
//session_start();
require_once('include/db-config.php');
class Pagination
{
/**
* Current Page
*
* @var integer
*/
var $page;
/**
* Size of the records per page
*
* @var integer
*/
var $size;
/**
* Total records
*
* @var integer
*/
var $totalrecords;
/**
* Link used to build navigation
*
* @var string
*/
var $link;
/**
* Class Constructor
*
* @param integer $page
* @param integer $size
* @param integer $total_records
*/
function Pagination($page = null, $size = null, $totalrecords = null)
{
$this->page = $page;
$this->size = $size;
$this->total_records = $totalrecords;
}
/**
* Set's the current page
*
* @param unknown_type $page
*/
function setPage($page)
{
$this->page = 0+$page;
}
/**
* Set's the records per page
*
* @param integer $size
*/
function setSize($size)
{
$this->size = 0+$size;
}
/**
* Set's total records
*
* @param integer $total
*/
function setTotalRecords($total)
{
$this->total_records = 0+$total;
}
/**
* Sets the link url for navigation pages
*
* @param string $url
*/
function setLink($url)
{
$this->link = $url;
}
/**
* Returns the LIMIT sql statement
*
* @return string
*/
function getLimitSql()
{
$sql = "LIMIT " . $this->getLimit();
return $sql;
}
/**
* Get the LIMIT statment
*
* @return string
*/
function getLimit()
{
if ($this->total_records == 0)
{
$lastpage = 0;
echo "aaa";
}
else
{
$lastpage = ceil($this->total_records/$this->size);
echo "bbb";
}
$page = $this->page;
if ($this->page < 1)
{
$page = 1;
echo "ccc";
}
else if ($this->page > $lastpage && $lastpage > 0)
{
$page = $lastpage;
echo "ddd";
}
else
{
$page = $this->page;
echo "ppp";
}
$sql = ($page - 1) * $this->size . "," . $this->size;
return $sql;
}
/**
* Creates page navigation links
*
* @return string
*/
function create_links()
{
$totalItems = $this->total_records;
$perPage = $this->size;
$currentPage = $this->page;
$link = $this->link;
$totalPages = floor($totalItems / $perPage);
$totalPages += ($totalItems % $perPage != 0) ? 1 : 0;
if ($totalPages < 1 || $totalPages == 1){
return null;
}
$output = null;
//$output = '<span id="total_page">Page (' . $currentPage . '/' . $totalPages . ')</span> ';
$loopStart = 1;
$loopEnd = $totalPages;
/*
if ($totalPages > 5)
{
if ($currentPage <= 3)
{
$loopStart = 1;
//$loopEnd = 5;
$loopEnd = 1000;
}
else if ($currentPage >= $totalPages - 2)
{
$loopStart = $totalPages - 4;
$loopEnd = $totalPages;
}
else
{
$loopStart = $currentPage - 2;
$loopEnd = $currentPage + 2;
}
}
*/
if ($loopStart != 1){
$output .= sprintf('<a href="' . $link . '">«</a>', '1');
}
if ($currentPage > 1){
$output .= sprintf('<a href="' . $link . '">Previous</a>', $currentPage - 1);
}
for ($i = $loopStart; $i <= $loopEnd; $i++)
{
if ($i == $currentPage){
$output .= '<a href="" style="border-color:#ffffff; background:#990000; color:#fff;">' . $i . ' </a>';
} else {
$output .= sprintf('<a href="' . $link . '">', $i) . $i . '</a> ';
}
}
if ($currentPage < $totalPages){
$output .= sprintf('<a href="' . $link . '">Next</a>', $currentPage + 1);
}
if ($loopEnd != $totalPages){
$output .= sprintf('<a href="' . $link . '">»</a>', $totalPages);
}
return '<div class="right">' . $output . '</div>';
}
}
?>