PHP Classes

EasyPagination: Pagination MySQL query records

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 53%Total: 2,489 This week: 1All time: 1,548 This week: 560Up
Version License Categories
easypagination 1.0GNU General Publi...Databases
Description 

Author

This class is meant to present the records of a MySQL database query split between multiple pages. It features:

- Setting current page
- Setting the records listed in each page
- Getting the total number of records retrieved
- Setting the query for searching records
- Using the same query to gets the total number of records
- Defining the additional parameters that may be necessary on the search and will be passed between pages with the GET method
- Outputs the total number of records
- Outputs the total number of pages based on to the number of records in each page
- Outputs the values of the records of the current page
- Outputs the links for browsing from 1 to 10, 11 to 20, 21 to 30, and so forth

In portuguese:

- Define a página atual
- Define o número de registros por página
- Define o número total de registros retornados
- Método que define a consulta de registros
- Método com mesma consulta acima, porém é usada para retornar o número total de resultados (COUNT)
- Seta os possíveis parâmetros extras que serão usados na pesquisa e passados pelo método GET
- Retorna o número total de registros encontrados pela consulta
- Retorna o número total de páginas de acordo com o número de registros por página
- Retorna o resultado de dados da página atual
- Retorna os links de navegação
- Retorna os links das páginas atuaís de acordo com a página corrente
- Sempre de 1 a 10, de 11 a 20, de 21 a 30, etc
- Retorna os registros atuais de acordo com a página vigente
- Retorna o Conjunto de links de 10 em 10, variando de (X)1,(X+1)1,(X+2)1

Picture of Olavo Alexandrino
Name: Olavo Alexandrino <contact>
Classes: 8 packages by
Country: Brazil Brazil
Age: 42
All time rank: 885 in Brazil Brazil
Week rank: 416 Down36 in Brazil Brazil Down
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Plain text file class.EasyPagination.php Class Class Code
Plain text file class.EasyPagination_1.01.php Class Version 1.01
Accessible without login Plain text file example.php Example Example
Accessible without login Plain text file users.sql Data Table DB (MySQL) for test

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,489
This week:1
All time:1,548
This week:560Up
 User Ratings  
 
 All time
Utility:77%StarStarStarStar
Consistency:70%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:53%StarStarStar
Rank:2248