Referência à classe MSQL

Diagrama de heranças da classe MSQL

Membros públicos
	__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 ()

Membros públicos estáticos
static	deleteTable ($tableName, array $where)
static	insertTable ($tableName, array $values)
static	updateTable ($tableName, array $values, array $where)

Campos de Dados
	$db
	$distinct
	$columns
	$tables
	$where
	$groupBy
	$having
	$orderBy
	$forUpdate
	$join
	$parameters
	$command
	$range
	$offsetSQL
	$bind
	$stmt
	$setOperation
	$limit

Documentação dos Construtores & Destrutor

__construct()

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

Documentação das funções

addBetweenCondition()

addBetweenCondition	(		$column,
			$value1,
			$value2 )

addEqualCondition()

addEqualCondition	(		$column,
			$value )

Adiciona uma condicao padrao de equivalencia no WHERE

Parâmetros

string	$column
string	$value

addGreaterCondition()

addGreaterCondition	(		$column,
			$value )

addGreaterEqualCondition()

addGreaterEqualCondition	(		$column,
			$value )

addIlikeCondition()

addIlikeCondition	(		$column,
			$value )

addIlikeConditionUnaccent()

addIlikeConditionUnaccent	(		$column,
			$value )

addInnerJoin()

addInnerJoin	(		$table,
			$cond )

Adiciona tabela com INNER JOIN

Parâmetros

string	$table
string	$cond

addLeftJoin()

addLeftJoin	(		$table,
			$cond )

Adiciona tabela com LEFT JOIN

Parâmetros

string	$table
string	$cond

addLikeCondition()

addLikeCondition	(		$column,
			$value )

addLikeConditionUnaccent()

addLikeConditionUnaccent	(		$column,
			$value )

addNotEqualCondition()

addNotEqualCondition	(		$column,
			$value )

addNotIlikeCondition()

addNotIlikeCondition	(		$column,
			$value )

addNotLikeCondition()

addNotLikeCondition	(		$column,
			$value )

addParameter()

addParameter

(

$value

)

addSmallerCondition()

addSmallerCondition	(		$column,
			$value )

addSmallerEqualCondition()

addSmallerEqualCondition	(		$column,
			$value )

addWhereIn()

addWhereIn	(		$column,
		array	$values )

addWhereNotIn()

addWhereNotIn	(		$column,
		array	$values )

bind()

bind

(

$parameters = null

)

clear()

clear

(

)

Clear MSQL attributes.

clearColumns()

clearColumns

(

)

clearGroupBy()

clearGroupBy

(

)

clearLimit()

clearLimit

(

)

clearOffsetSQL()

clearOffsetSQL

(

)

clearOrderBy()

clearOrderBy

(

)

convertArrayToIn()

convertArrayToIn

(

array

$values = null

)

Converte conjunto de valores para realidade SQL

createFrom()

createFrom	(		$sqltext,
			$params = array() )

Populate the current MSQL instance based on a given SQL instruction.

Parâmetros

string

$sqltext

SQL instruction.

delete()

delete

(

$parameters = null

)

deleteTable()

static deleteTable ( $tableName, array $where )

static

Retorna comando de DELETE para tabela e valores passados

Parâmetros

string	$tableName
array	$where

Retorna

string

endSubCondition()

endSubCondition

(

)

findStr()

findStr	(		$target,
			$source )

getColumns()

getColumns

(

)

Retorna

string

getLimit()

getLimit

(

)

getNewJoins()

getNewJoins

(

)

Retorna

array

getOffsetSQL()

getOffsetSQL

(

)

getOrderBy()

getOrderBy

(

)

getWhere()

getWhere

(

)

Retorna

string

insert()

insert

(

$parameters = null

)

Returns insert command. This method returns the sql insert command.

Parâmetros

array

$parameters

Array of values.

Retorna

string Sql insert command.

insertFrom()

insertFrom

(

$sql

)

insertTable()

static insertTable ( $tableName, array $values )

static

parseSqlCommand()

parseSqlCommand	(	&	$cmd,
			$clause,
			$delimiters )

prepare()

prepare

(

$parameters = null

)

select()

select

(

$parameters = null

)

Returns SQL select command. This method returns the SQL select command.

Parâmetros

array

$parameters

Array of values.

Retorna

string SQL select command

selectCount()

selectCount

(

)

Substitui as colunas para COUNT(*)

setColumns()

setColumns	(		$string,
			$distinct = false )

Set the columns Use this method to set which columns must be used.

Parâmetros

string	$string	Name of the columns.
boolean	$distinct	If you want a distinct select, inform TRUE.

setColumnsOverride()

setColumnsOverride

(

array

$columns

)

Limpa e define novamente as colunas

Parâmetros

array

$columns

setDb()

setDb

(

$db

)

setForUpdate()

setForUpdate

(

$forUpdate = false

)

setGroupBy()

setGroupBy

(

$string

)

Parâmetros

string

$string

Group by columns separated by comma. E.g.: 'column1, column2'

setHaving()

setHaving

(

$string

)

setHavingAnd()

setHavingAnd

(

$string

)

setHavingOr()

setHavingOr

(

$string

)

setJoin()

setJoin	(		$table1,
			$table2,
			$cond,
			$type = 'INNER' )

setLeftJoin()

setLeftJoin	(		$table1,
			$table2,
			$cond )

setLimit()

setLimit

(

$limit

)

setOffset()

setOffset	(		$offset,
			$rows )

setOffsetSQL()

setOffsetSQL

(

$offsetSQL

)

setOrderBy()

setOrderBy

(

$string

)

Parâmetros

string

$string

Order by columns separated by comma. E.g.: 'column1, column2 DESC'

setParameters()

setParameters

(

)

setRange()

setRange

(

)

setRightJoin()

setRightJoin	(		$table1,
			$table2,
			$cond )

SetSetOperation()

SetSetOperation	(		$operation,
		MSQL	$sql )

setTables()

setTables

(

$string

)

Parâmetros

string

$string

Table names separated by comma. E.g.: 'table1, table2'

setWhere()

setWhere	(		$string,
		array	$parameters = null )

Parâmetros

string

$string

Add conditional statement. E.g.: "column <> 'condition'"

setWhereAnd()

setWhereAnd	(		$string,
		array	$parameters = null )

Parâmetros

string

$string

Add AND conditional statement. E.g.: "column <> 'condition'"

setWhereOr()

setWhereOr	(		$string,
		array	$parameters = null )

Parâmetros

string

$string

Add OR conditional statement. E.g.: "column <> 'condition'"

startSubCondition()

startSubCondition

(

)

update()

update

(

$parameters = null

)

updateTable()

static updateTable ( $tableName, array $values, array $where )

static

Retorna comando de UPDATE para tabela e valores passados

Parâmetros

string	$tableName
array	$values
array	$where

Retorna

string

Documentação dos campos e atributos

$bind

$bind

$columns

$columns

$command

$command

$db

$db

$distinct

$distinct

$forUpdate

$forUpdate

$groupBy

$groupBy

$having

$having

$join

$join

$limit

$limit

$offsetSQL

$offsetSQL

$orderBy

$orderBy

$parameters

$parameters

$range

$range

$setOperation

$setOperation

$stmt

$stmt

$tables

$tables

$where

$where

---

A documentação para esta classe foi gerada a partir do seguinte ficheiro:

• classes/database/msql.class.php