PHP Classes

EasyPagination: Pagination MySQL query records

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2003-10-11 (12 years ago) RSS 2.0 feedStarStarStar 53%Total: 2,480 This week: 1All time: 1,489 This week: 1,063Up
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: 34
All time rank: 835 in Brazil Brazil
Week rank: 579 Down42 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,480All time:1,489
 This week:1This week:1,063Up
 User Ratings  
 All time