PHPDevShell 3.1.3-Stable
PHP OOP RAD Development Framework
pagination Class Reference
Inheritance diagram for pagination:
PHPDS_dependant

Public Member Functions

 query ($sql)
 searchFilter ()
 finalQuery ($params)
 queryCondition ()
 filterQuery ()
 th ()
 navPages ()
 searchForm ()

Data Fields

 $filter = array()
 $sql = ''
 $condition = ''
 $dateColumn = ''
 $columns = array()
 $extraCond = ''
 $limitCount = 0
 $showSplitLinks = true
 $defaultOrderColumn = ''
 $defaultOrder = 'DESC'

Protected Attributes

 $totalRows
 $currentPage = 1

Detailed Description

Contains methods to handle pagination, searching and filtering. PHPMailer could also be used.

Author:
Jason Schoeman

Member Function Documentation

filterQuery ( )

Creates filter string to be included with query.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
string
finalQuery ( params)

Combines filters and query together.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Parameters:
Canreceive as many parameter as possible...
Returns:
array
navPages ( )

Creates HTML navigation pages to be used in templates.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
string
string iPHPDS_dbConnector the connector used to carry the query ( sql)

Replaces original query model to include pagination.

Parameters:
stringActual SQL to be converted to pages.
Returns:
array

A link between the query and the actual database server.

Set this to the connector class name if you want something else than the default one

queryCondition ( )

Checks if system should use where or and in condition.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
string
searchFilter ( )

Creates and stores filters to be used when searching or ordering.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
void
searchForm ( )

Creates search form to be used in templates for searching and navigating.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
string
th ( )

Creates row heading for rows of tubular data. Also ads order options.

Author:
Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.
Returns:
string

Field Documentation

$columns = array()
$condition = ''
$currentPage = 1 [protected]
$dateColumn = ''
$defaultOrder = 'DESC'
$defaultOrderColumn = ''
$extraCond = ''
$filter = array()
$limitCount = 0
$showSplitLinks = true
$sql = ''
$totalRows [protected]

The documentation for this class was generated from the following files:
 All Data Structures Files Functions Variables Enumerations