Inherited From atkMysqlQuery

atkMysqlQuery::$m_fieldquote

Inherited From atkQuery

atkQuery::$m_aliases

atkQuery::$m_conditions

atkQuery::$m_db

atkQuery::$m_distinct

atkQuery::$m_expressions

atkQuery::$m_fieldaliases

atkQuery::$m_fields

atkQuery::$m_generatedAlias

atkQuery::$m_groupbys

atkQuery::$m_joinaliases

atkQuery::$m_joins

atkQuery::$m_limit

atkQuery::$m_offset

atkQuery::$m_orderbys

atkQuery::$m_quotedfields

atkQuery::$m_reservedNames

atkQuery::$m_searchconditions

atkQuery::$m_searchmethod

atkQuery::$m_tables

Inherited From atkMysqlQuery

atkMysqlQuery::buildCount()

Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.

atkMysqlQuery::regexpCondition()

Generate an SQL searchcondition for a regular expression match.

atkMysqlQuery::soundexCondition()

Generate an SQL searchcondition for a soundex match.

atkMysqlQuery::_addLimiter()

Prepare the query for a limit.

Inherited From atkQuery

atkQuery::addCondition()

Add a query condition (conditions are where-expressions that are AND-ed)

atkQuery::addExpression()

Add's an expression to the select query

atkQuery::addField()

Add's a field to the query

atkQuery::addFields()

Add multiple fields at once

atkQuery::addGroupBy()

Add a group-by statement

atkQuery::addJoin()

Add join to Join Array

atkQuery::addOrderBy()

Add order-by statement

atkQuery::addSearchCondition()

Add search condition to the query. Basically similar to addCondition, but searchconditions make use of the searchmode setting to determine whether the different searchconditions should be and'ed or or'ed.

atkQuery::addSequenceField()

Add's a sequence field to the query.

atkQuery::addTable()

Add table to Tables array

atkQuery::atkquery()

Initialize all variables

atkQuery::betweenCondition()

Get the between condition

atkQuery::buildCount()

Builds the SQL Select COUNT(*) query. This is different from select, because we do joins, like in a select, but we don't really select the fields.

atkQuery::buildDelete()

Builds the SQL Delete query

atkQuery::buildInsert()

Builds the SQL Insert query

atkQuery::buildSelect()

Builds the SQL Select query

atkQuery::buildUpdate()

Builds the SQL Update query

atkQuery::clearExpressions()

Clear expression list.

atkQuery::clearFields()

Clear field list.

atkQuery::create()

Static factory method. This method returns a new instance of a query object for the current database.

atkQuery::deAlias()

Search Alias in alias array

atkQuery::exactCondition()

Generate a searchcondition that checks whether $value matches $field exactly.

atkQuery::exactNumberCondition()

Generate a searchcondition that check number/decimal literal values

atkQuery::executeDelete()

Wrapper function to execute a delete query

atkQuery::executeInsert()

Wrapper function to execute an insert query

atkQuery::executeSelect()

Wrapper function to execute a select query.

atkQuery::executeUpdate()

Wrapper function to execute an update query

atkQuery::getDb()

Returns the database instance.

atkQuery::greaterthanCondition()

Generate searchcondition with greater than

atkQuery::greaterthanequalCondition()

Generate searchcondition with greater than

atkQuery::lessthanCondition()

Generate searchcondition with less than

atkQuery::lessthanequalCondition()

Generate searchcondition with less than

atkQuery::notNullCondition()

Generate a searchcondition that checks if the field is not null.

atkQuery::nullCondition()

Generate a searchcondition that checks if the field is null.

atkQuery::quoteField()

If we set a m_fieldquote you can pass a field to this function and it will quote all the identifiers (db, table, column, etc...) in the field.

atkQuery::quoteFields()

Quote an array of fields if m_fieldquote is set.

atkQuery::setDb()

Sets the database instance.

atkQuery::setDistinct()

Set the 'distinct' mode for the query.

atkQuery::setLimit()

Set a limit to the number of results.

atkQuery::setSearchMethod()

Sets this queries search method.

atkQuery::substringCondition()

Generate a searchcondition that checks whether $field contains $value .

atkQuery::wildcardCondition()

Generate a searchcondition that accepts '*' as wildcard character.

atkQuery::_addFrom()

Add FROM clause to query.

atkQuery::_addLimiter()

Add limiting clauses to the query.

atkQuery::_addOrderBy()

Add the ORDER BY clause