Referência à classe sql

Diagrama de heranças da classe sql

Membros públicos
	sql ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='')
	__construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='')
	sql ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='')
	__construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='')
Membros públicos herdados de MSQL
	__construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='', $forUpdate=false)
	setDb ($db)
	setColumns ($string, $distinct=false)
	setColumnsOverride (array $columns)
	clearColumns ()
	getColumns ()
	setTables ($string)
	setGroupBy ($string)
	clearGroupBy ()
	setOrderBy ($string)
	getOrderBy ()
	clearOrderBy ()
	addEqualCondition ($column, $value)
	addNotEqualCondition ($column, $value)
	addBetweenCondition ($column, $value1, $value2)
	addGreaterCondition ($column, $value)
	addGreaterEqualCondition ($column, $value)
	addSmallerCondition ($column, $value)
	addSmallerEqualCondition ($column, $value)
	addNotIlikeCondition ($column, $value)
	addNotLikeCondition ($column, $value)
	addLikeCondition ($column, $value)
	addLikeConditionUnaccent ($column, $value)
	addIlikeCondition ($column, $value)
	addIlikeConditionUnaccent ($column, $value)
	addWhereIn ($column, array $values)
	addWhereNotIn ($column, array $values)
	setWhere ($string, array $parameters=null)
	getWhere ()
	setWhereAnd ($string, array $parameters=null)
	setWhereOr ($string, array $parameters=null)
	getLimit ()
	setLimit ($limit)
	clearLimit ()
	getOffsetSQL ()
	setOffsetSQL ($offsetSQL)
	clearOffsetSQL ()
	setHaving ($string)
	setHavingAnd ($string)
	setHavingOr ($string)
	setJoin ($table1, $table2, $cond, $type='INNER')
	setLeftJoin ($table1, $table2, $cond)
	setRightJoin ($table1, $table2, $cond)
	setForUpdate ($forUpdate=false)
	SetSetOperation ($operation, MSQL $sql)
	bind ($parameters=null)
	prepare ($parameters=null)
	insert ($parameters=null)
	insertFrom ($sql)
	delete ($parameters=null)
	update ($parameters=null)
	select ($parameters=null)
	selectCount ()
	clear ()
	setParameters ()
	addParameter ($value)
	setRange ()
	setOffset ($offset, $rows)
	findStr ($target, $source)
	parseSqlCommand (&$cmd, $clause, $delimiters)
	createFrom ($sqltext, $params=array())
	addInnerJoin ($table, $cond)
	addLeftJoin ($table, $cond)
	getNewJoins ()
	convertArrayToIn (array $values=null)
	startSubCondition ()
	endSubCondition ()

Outros membros herdados
Membros públicos estáticos herdados de MSQL
static	deleteTable ($tableName, array $where)
static	insertTable ($tableName, array $values)
static	updateTable ($tableName, array $values, array $where)
Campos de Dados herdados de MSQL
	$db
	$distinct
	$columns
	$tables
	$where
	$groupBy
	$having
	$orderBy
	$forUpdate
	$join
	$parameters
	$command
	$range
	$offsetSQL
	$bind
	$stmt
	$setOperation
	$limit

Documentação dos Construtores & Destrutor

__construct() [1/2]

__construct	(		$columns = '',
			$tables = '',
			$where = '',
			$orderBy = '',
			$groupBy = '',
			$having = '' )

__construct() [2/2]

__construct	(		$columns = '',
			$tables = '',
			$where = '',
			$orderBy = '',
			$groupBy = '',
			$having = '' )

Documentação das funções

sql() [1/2]

sql	(		$columns = '',
			$tables = '',
			$where = '',
			$orderBy = '',
			$groupBy = '',
			$having = '' )

sql() [2/2]

sql	(		$columns = '',
			$tables = '',
			$where = '',
			$orderBy = '',
			$groupBy = '',
			$having = '' )

---

A documentação para esta classe foi gerada a partir dos seguintes ficheiros:

• classes/compatibility.class.php
• classes/compatibility/sql.class.php