OwlCyberSecurity - MANAGER

Edit File: #config.php

<?php
session_start();

define("URL_BASE", "http://".$_SERVER['HTTP_HOST']."/");
define("URL_BASE_GAMES", "http://games.kawaiigames.net/");

$isMobile = !(FALSE === strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'mobile'));

include_once 'languages/config.php';

# FUNCOES DE PAGINACAO ---------------------------------------------------------
class Paginacao{
    private $sqlGeral;
    private $where;
    private $db;
    private $numeroRegistroPorPagina;
    
    private function getPg(){
        return filter_input(INPUT_GET, 'pg') ? (int)filter_input(INPUT_GET, 'pg') : 1 ;
    }
    
    public function __construct($db, $numeroRegistroPorPagina=40){
        $this->db = $db;
        $this->numeroRegistroPorPagina = $numeroRegistroPorPagina;
    }
    
    public function Registros($sqlGeral, $where = array()){
        $this->sqlGeral = $sqlGeral;
        $this->where    = $where;
        $limite         = $this->numeroRegistroPorPagina;
        $pg             = $this->getPg();
        $inicio         = ($pg * $limite) - $limite;
        $query  = $this->db->prepare($this->sqlGeral." LIMIT {$inicio}, {$limite}");
        $query->execute($this->where);
        return $query->fetchAll(PDO::FETCH_ASSOC);
    }
    
    public function links($urlBase) {
        $sql_Total      = $this->sqlGeral;
        $query_Total    = $this->db->prepare($sql_Total);
        $query_Total->execute($this->where);

$query_result = $query_Total->fetchAll(PDO::FETCH_ASSOC);
        $query_count = $query_Total->rowCount(PDO::FETCH_ASSOC);

$qtdPag = ceil($query_count / $this->numeroRegistroPorPagina);

//Cria os links para navegação das paginas
        $linksPaginacao = "";
        $pg = $this->getPg();
        $max_links = 10;
        $links_laterais = ceil($max_links / 2);
        $inicioLink = $pg - $links_laterais;
        $limiteLink = $pg + $links_laterais;

if ($qtdPag > 1 && $pg <= $qtdPag) {

$primeiraPagina = "<li><a href='" . $urlBase . "page/1' title='First'>&laquo;</a></li>";
            $ultimaPagina = "<li><a href='" . $urlBase . "page/{$qtdPag}' title='Last'>&raquo;</a></li>";

$paginaAnterior = $pg - 1;
            $proximoPagina = $pg + 1;

if ($pg > 1) {
                $paginaAnterior = "<li><a href='" . $urlBase . "page/$paginaAnterior' title='Previous'>&lsaquo;</a></li>";
            }

if ($pg < $qtdPag) {
                $proximoPagina = "<li><a href='" . $urlBase . "page/$proximoPagina' title='Next'>&rsaquo;</a></li>";
            }

$linksPaginacaoNumeros = "";

for ($i = $inicioLink; $i <= $limiteLink; $i++) {
                if ($i == $pg) {
                    $linksPaginacaoNumeros .= "<li><a href='javascript:;' class='active'>" . $i . "</a></li>";
                } else {
                    if ($i >= 1 && $i <= $qtdPag) {
                        $linksPaginacaoNumeros .= "<li><a href='" . $urlBase . "page/$i'>" . $i . "</a></li>";
                    }
                }
            }

$linksPaginacao .= '<nav class="text-center"><ul class="pagination">';
            $linksPaginacao .= $primeiraPagina . $paginaAnterior . $linksPaginacaoNumeros . $proximoPagina . $ultimaPagina;
            $linksPaginacao .= '</ul></nav>';
        }
        
        return $linksPaginacao;
    }
}