Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

PagedQuery Class Reference

Inherits Query.

List of all members.

Public Member Functions

• __construct ( Connection $conn, $sql, $page, $rowsPerPage )
• void setPage ( $p )
• int getPage ()
• setRowsPerPage ( $r )
• int getRowsPerPage ()
• int getTotalRecordCount ()

---

Member Function Documentation

PagedQuery::__construct ( Connection $conn, $sql = null, $page = 1, $rowsPerPage = 25 )

void PagedQuery::setPage ( $p )

Set the current page number (First page is 1). Parameters int  $p Returns void

int PagedQuery::getPage ( )

Get current page. Returns int

PagedQuery::setRowsPerPage ( $r )

Set the number of rows per page. Parameters int  $r

int PagedQuery::getRowsPerPage ( )

Get number of rows per page. Returns int

int PagedQuery::getTotalRecordCount ( )

Gets the total number (un-LIMITed) of records. This method will perform a query that executes un-LIMITed query. This method is not performance-conscious, so don't call this repeatedly for the same query. Returns int Total number of records - disregarding page, maxrows, etc. Exceptions SQLException

---

This file is part of the Creole[php5] library.