Methods

Public

__construct(): Constructor.
__destruct(): Default destructor; does nothing other than provide a safe fallback for calls to parent::__destruct().
__toString(): Returns this object as an SQL statement string.
_multiHaving(): Backend support for multiHaving().
_multiWhere(): Backend support for multiWhere().
apiVersion(): Reports the API version for this class.
bind(): Adds data to bind into the query.
clear(): Clears query properties and row sources.
cols(): Adds 1 or more columns to the SELECT, without regard to a FROM or JOIN.
countPages(): Get the count of rows and number of pages for the current query.
distinct(): Makes the query SELECT DISTINCT.
dump(): Convenience method for getting a dump the whole object, or one of its properties, or an external variable.
fetch(): Fetch the results based on the current query properties.
fetchAll(): Fetches all rows from the database using sequential keys.
fetchAssoc(): Fetches all rows from the database using associative keys (defined by the first column).
fetchCol(): Fetches the first column of all rows as a sequential array.
fetchOne(): Fetches one row from the database.
fetchPairs(): Fetches an associative array of all rows as key-value pairs (first column is the key, second column is the value).
fetchPdo(): Fetches a PDOStatement result object.
fetchSql(): Builds the SQL statement and returns it as a string instead of executing it.
fetchValue(): Fetches the very first value (i.e., first column of the first row).
from(): Adds a FROM table and columns to the query.
fromSelect(): Adds a sub-select and columns to the query.
getPaging(): Gets the number of rows per page.
group(): Adds grouping to the query.
having(): Adds a HAVING condition to the query by AND.
innerJoin(): Adds an INNER JOIN table and columns to the query.
join(): Adds a JOIN table and columns to the query.
leftJoin(): Adds a LEFT JOIN table and columns to the query.
limit(): Sets a limit count and offset to the query.
limitPage(): Sets the limit and count by page number.
locale(): Looks up class-specific locale strings based on a key.
multiHaving(): Adds multiple HAVING conditions to the query.
multiWhere(): Adds multiple WHERE conditions to the query.
orHaving(): Adds a HAVING condition to the query by OR.
orWhere(): Adds a WHERE condition to the query by OR.
order(): Adds a row order to the query.
quote(): Safely quotes a value for an SQL statement.
quoteInto(): Quotes a value and places into a piece of text at a placeholder.
quoteMulti(): Quote multiple text-and-value pieces.
setPaging(): Sets the number of rows per page.
unbind(): Unsets bound data.
where(): Adds a WHERE condition to the query by AND.

Protected

_addSource(): Adds a row source (from table, from select, or join) to the sources array.
_buildFrom(): Builds $this->_parts['from'] using a 'from' source.
_buildJoin(): Builds $this->_parts['join'] using a 'join' source.
_buildSelect(): Builds $this->_parts['from'] using a 'select' source.
_countSubSelect(): When doing a countPages(), count using a subselect.
_exception(): Convenience method for returning exceptions with localized text.
_hasCountCond(): Determines if there is a COUNT() in any of the condition snippets.
_join(): Support method for adding JOIN clauses.
_nameCols(): Support method for finding a table name and column names.
_origAlias(): Returns an identifier as an "original" name and an "alias".

Private

None.

Methods

Public

Protected

Private

Local

Navigation