Databases: Paginacao Class
Otavio Theiss (contact me)
This class can be used to split in multiple pages listings of data retrieved from a database using ADODB.
It takes a result set object of an already executed query with ADODB PageExecute function.
The class retrieves the total number of pages and total number of rows from the result set object.
It generates a list of links to the first page, last page and any intermediate pages of the list of query results.
The base URL of the links and the link colors are configurable parameters.
The code and comments are in Portuguese. In Portuguese:
Esta classe gera os links de paginação com apenas uma conexão à base de dados.
Para que a classe funcione é obrigatório o uso do pacote ADODB, pois é utilizado o método PageExecute desse pacote.
Click here for detailed information about this class on phpclasses.org
Php Handleiding