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)
	setTables ($string)
	setGroupBy ($string)
	setOrderBy ($string)
	setWhere ($string)
	setWhereAnd ($string)
	setWhereOr ($string)
	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)
	clear ()
	setParameters ()
	addParameter ($value)
	setRange ()
	setOffset ($offset, $rows)
	findStr ($target, $source)
	parseSqlCommand (&$cmd, $clause, $delimiters)
	createFrom ($sqltext)

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

Documentação dos Construtores & Destrutor

__construct()

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

Documentação das funções

addParameter()

addParameter

(

$value

)

bind()

bind

(

$parameters = null

)

clear()

clear

(

)

Clear MSQL attributes.

createFrom()

createFrom

(

$sqltext

)

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

Parâmetros

string

$sqltext

SQL instruction.

delete()

delete

(

$parameters = null

)

findStr()

findStr	(		$target,
			$source )

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

)

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

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.

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 )

setOffset()

setOffset	(		$offset,
			$rows )

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

)

Parâmetros

string

$string

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

setWhereAnd()

setWhereAnd

(

$string

)

Parâmetros

string

$string

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

setWhereOr()

setWhereOr

(

$string

)

Parâmetros

string

$string

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

update()

update

(

$parameters = null

)

Documentação dos campos e atributos

$bind

$bind

$columns

$columns

$command

$command

$db

$db

$distinct

$distinct

$forUpdate

$forUpdate

$groupBy

$groupBy

$having

$having

$join

$join

$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:

• /var/docker/solisge-devel/www/solisge/miolo25/classes/database/msql.class.php