Top rated packages with tag paginate

Recommend this page to a friend!

			All class groups	>	Search tags: paginate

	1. Paginations		paginate

Supplied by: Reneesh T K <e-mail contact>

Split MySQL query result listings

This class can be used to split MySQL database query listings between multiple pages.

It takes as parameters a SQL query, the limit number of result rows to display per page, and the number of the listing page being displayed.

The class executes the query to retrieve the results of the current page and stores the result handle in a class variable.

The class also generates HTML with links to go to the first, last, next, previous and any intermediate page of the listing.

It also generates HTML to display the current page being display and the total number of rows in the result set.

The links trigger the call of a Javascript function that will switch to the page associated with the link.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (91.7%)`	`Good (83.3%)`	`Good (86.1%)`	`Good (97.2%)`	`-`	`-`	`Sufficient (72.5%)`	116
Month:	Not yet rated by the users

	2. queryList		paginate

Supplied by: Oliver Susano <e-mail contact>

query with pagination and previous next

This class executes a SQL query to a MySQL database and paginates the results and displaying previous and next navigation links.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (93.8%)`	`Good (87.5%)`	`-`	`Good (87.5%)`	`-`	`-`	`Sufficient (64.4%)`	478
Month:	Not yet rated by the users

	3. SQL Data Browsing		paginate

Supplied by: Protung Dragos <e-mail contact>

Browse and paginate MySQL query results

This package is meant to display MySQL query results in multiple HTML pages.

It comes with a class for displaying query results in HTML tables and another class for displaying links to browse between all the query result pages.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (90.0%)`	`Good (85.0%)`	`-`	`Good (90.0%)`	`-`	`-`	`Sufficient (62.5%)`	601
Month:	Not yet rated by the users

	4. Generic Easy Pagination		paginate

Supplied by: Olavo Alexandrino <e-mail contact>

Pagination of arbitrary listings

This class is meant to generate an HTML navigation bar for listings to be split in multiple pages.
The class is generic, so it can be used for pagination of arbitrary types of listings.
An example is provided to demonstrate how to paginate the results of a database query using ADODB API.

This class and the example features:

- Setting current page
- Setting the records listed in each page
- Getting the total number of records that were 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 on.

In portuguese:

Esta classe destina-se a gerar uma barra de navegação em HTML para dividir listagens por várias páginas.
A classe é genérica, desse modo pode ser usada para paginar listagens de tipos arbitrários de SGBD.
É fornecido um exemplo que demonstra como paginar os resultados de uma consulta a um banco de dados usando a API ADODB.

Esta classe e o exemplo proporcionam as seguintes capacidades:

- 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)
- Configura 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
- Resultados no formato: 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: Próximos 10 registros para adiante e retorno

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (81.2%)`	`Sufficient (75.0%)`	`-`	`Good (81.2%)`	`-`	`-`	`Not sure (56.2%)`	1052
Month:	Not yet rated by the users

	5. Paginate		paginate

Supplied by: Britto Sebastian <e-mail contact>

Generate paginated navigation links

This is a simple class that can be used to generate paginated navigation links for listings of arbitrary data split between multiple pages.

It takes as parameter the total number of items in a listing, the limit of items to display per page and the number of the current page.

It generates links to the first page, next page, previous page, last page and any intermediate pages upto a limit defined by a class variable.

The links to the first, last, next, previous page show as images.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (58.3%)`	`Not sure (50.0%)`	`Not sure (58.3%)`	`-`	`-`	`-`	`Insufficient (40.0%)`	1969
Month:	Not yet rated by the users

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products