Home | Classes | Modules | Annotated | Functions | Files

PagedQuery Class Reference

Inherits Query.

List of all members.

Public Member Functions

• PagedQuery (&$conn, $sql=null, $page=1, $rowsPerPage=25)
• setPage ($p)
• getPage ()
• setRowsPerPage ($r)
• getRowsPerPage ()
• calculateStart ()
• getTotalRecordCount ()

---

Constructor & Destructor Documentation

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

---

Member Function Documentation

PagedQuery::setPage ( $  p)

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

PagedQuery::getPage ()

Get current page. Returns int

PagedQuery::setRowsPerPage ( $  r)

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

PagedQuery::getRowsPerPage ()

Get number of rows per page. Returns int

PagedQuery::calculateStart ()

Calculate startrow / max rows based on current page and rows-per-page. private Returns void

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 mixed int Total number of records - disregarding page, maxrows, etc. on success, SQLException on failure

---

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