Login   Register  
PHP Classes
elePHPant
Icontem

EasyPagination: Pagination MySQL query records

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (11 years ago) RSS 2.0 feedStarStarStar 53%Total: 2,471 All time: 1,454 This week: 1,445Up
Version License Categories  
easypagination 1.0GNU General Public Lice...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: 33
All time rank: 825 in Brazil Brazil
Week rank: 305 Down26 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,471All time:1,454
 This week:0This week:1,445Up
 User Ratings  
 
 All time
Utility:77%StarStarStarStar
Consistency:70%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:53%StarStarStar
Rank:1433