\Query

Summary

Methods

Properties

Constants

__construct()
__call()
where()
whereor()
from()
join()
on()
select()
orderby()
fill()
hasWhere()
get()
getcolumn()
getall()
getLastQueryTotal()
count()
exists()
delete()
insert()
update()
getLastQuery()

$fixTable

No constants found

No protected methods found

No protected properties found

N/A

initClauses()
resetClause()
addStatement()
condition()
buildQuery()
buildQueryWhere()
buildQueryWhereor()
buildQueryHaving()
buildQueryFrom()
buildQueryLeftjoin()
buildQueryInnerjoin()
buildQueryJoin()
buildQuerySelect()
buildQueryLimit()
buildQueryPage()
buildQueryOrderby()
buildQueryGroupby()
buildWhereArray()

$clauses
$statements
$parameters
$mainTable
$currentTableAlias
$error
$lastsql
$lastparams
$values

N/A

File: framework/class/query.class.php
Package: Default
Class hierarchy: \Query

Properties

$fixTable

$fixTable :

Type

$clauses

$clauses :

Type

$statements

$statements :

Type

$parameters

$parameters :

Type

$mainTable

$mainTable :

Type

$currentTableAlias

$currentTableAlias :

Type

$error

$error :

Type

$lastsql

$lastsql :

Type

$lastparams

$lastparams :

Type

$values

$values :

Type

Methods

__construct()

__construct()

__call()

__call(  $clause,   $statement = array())

Parameters

	$clause
	$statement

where()

where(  $condition,   $parameters = array(),   $operator = 'AND')

Parameters

	$condition
	$parameters
	$operator

whereor()

whereor(  $condition,   $parameters = array())

Parameters

	$condition
	$parameters

from()

from(  $tablename,   $alias = '')

Parameters

	$tablename
	$alias

join()

join(  $clause,   $tablename,   $alias = '')

Parameters

	$clause
	$tablename
	$alias

on()

on(  $condition,   $parameters = array())

Parameters

	$condition
	$parameters

select()

select(  $field)

Parameters

$field

orderby()

orderby(  $field,   $direction = 'ASC')

Parameters

	$field
	$direction

fill()

fill(  $field,   $value = '')

Parameters

	$field
	$value

hasWhere()

hasWhere()

get()

get()

getcolumn()

getcolumn(  $field = '')

Parameters

$field

getall()

getall(  $keyfield = '')

Parameters

$keyfield

getLastQueryTotal()

getLastQueryTotal()

count()

count()

exists()

exists()

delete()

delete()

insert()

insert()

update()

update()

getLastQuery()

getLastQuery()

initClauses()

initClauses()

resetClause()

resetClause(  $clause = '')

Parameters

$clause

addStatement()

addStatement(  $clause,   $statement,   $parameters = array())

Parameters

	$clause
	$statement
	$parameters

condition()

condition(  $operator,   $condition,   $parameters = array())

Parameters

	$operator
	$condition
	$parameters

buildQuery()

buildQuery()

buildQueryWhere()

buildQueryWhere()

buildQueryWhereor()

buildQueryWhereor()

buildQueryHaving()

buildQueryHaving()

buildQueryFrom()

buildQueryFrom()

buildQueryLeftjoin()

buildQueryLeftjoin()

buildQueryInnerjoin()

buildQueryInnerjoin()

buildQueryJoin()

buildQueryJoin(  $clause)

Parameters

$clause

buildQuerySelect()

buildQuerySelect()

buildQueryLimit()

buildQueryLimit()

buildQueryPage()

buildQueryPage()

buildQueryOrderby()

buildQueryOrderby()

buildQueryGroupby()

buildQueryGroupby()

buildWhereArray()

buildWhereArray()