Referência à classe MQuery

Diagrama de heranças da classe MQuery

Membros públicos
	__construct ()
	_query ()
	_error ()
	_close ()
	_setmetadata ()
	getError ()
	open ($maxrows=NULL, $offset=NULL, $stmt=NULL)
	close ()
	setConnection (&$conn)
	setSQL (&$sql)
	setSQLCommand ($sqlCommand)
	setOrder ($order)
	isFiltered ()
	addFilter ($field, $oper, $value, $conector='AND')
	applyFilter ()
	setPageLength ($pagelength)
	getPageCount ()
	getPage ($pageno)
	getCSV ($filename='', $separator=';')
	setFetchType ($fetchType)
	getFetchType ()
Membros públicos herdados de MDataSet
	movePrev ()
	moveNext ()
	moveTo ($row)
	moveFirst ()
	moveLast ()
	getRowCount ()
	getColumnCount ()
	getColumnName ($colNumber)
	getColumnNames ()
	getColumnNumber ($colName)
	getValue ($colName)
	fields ($fieldName)
	getRowValues ()
	getRowObject ()
&	SetRowObject ($object)
	getFieldValues ()
	eof ()
	bof ()
	chunkResult ($key=0, $value=1, $showKeyValue=false)
	chunkResultMany ($key, $values, $type='S', $separator='')
	treeResult ($group, $node)
	asXML ($root='root', $node='node')

Campos de Dados
const	FETCH_NUM = 'n'
const	FETCH_ASSOC = 'a'
const	FETCH_BOTH = 'b'
const	FETCH_OBJ = 'o'
	$conn
	$objSql
	$sql
	$error
	$statement
	$fetched
	$maxrows
	$offset
	$order
	$filtered
	$pagelength
	$queryfilter
	$_miolo
Campos de Dados herdados de MDataSet
	$result
	$row
	$rowCount
	$colCount
	$eof
	$bof
	$metadata
	$type

Atributos Protegidos
	$fetchType = self::FETCH_NUM

Documentação dos Construtores & Destrutor

__construct()

__construct

(

)

Brief Description. Complete Description.

Retorna

(tipo) desc

Reimplementado de MDataSet.

Reimplementado em FirebirdQuery, MSSQLQuery, MysqlQuery, ODBCQuery, Oracle8Query, PostgresQuery e SQLiteQuery.

Documentação das funções

_close()

_close ( )

abstract

Reimplementado em FirebirdQuery, MSSQLQuery, MysqlQuery, ODBCQuery, Oracle8Query, PostgresQuery e SQLiteQuery.

_error()

_error ( )

abstract

Reimplementado em FirebirdQuery, MSSQLQuery, MysqlQuery, ODBCQuery, Oracle8Query, PostgresQuery e SQLiteQuery.

_query()

_query ( )

abstract

Reimplementado em FirebirdQuery, MSSQLQuery, MysqlQuery, ODBCQuery, Oracle8Query, PostgresQuery e SQLiteQuery.

_setmetadata()

_setmetadata ( )

abstract

Reimplementado em FirebirdQuery, MSSQLQuery, MysqlQuery, ODBCQuery, Oracle8Query, PostgresQuery e SQLiteQuery.

addFilter()

addFilter	(		$field,
			$oper,
			$value,
			$conector = 'AND' )

applyFilter()

applyFilter

(

)

close()

close

(

)

getCSV()

getCSV	(		$filename = '',
			$separator = ';' )

getError()

getError

(

)

getFetchType()

getFetchType

(

)

Retorna

character Get the fetch type.

getPage()

getPage

(

$pageno

)

getPageCount()

getPageCount

(

)

isFiltered()

isFiltered

(

)

open()

open	(		$maxrows = NULL,
			$offset = NULL,
			$stmt = NULL )

Execute query.

Parâmetros

integer	$maxrows	Maximum number of rows of the result.
integer	$offset	Query offset.
type	$stmt	Statement.

Retorna

boolean Return true if the query was successful.

Excepções

EDatabaseQueryException

setConnection()

setConnection

(

&

$conn

)

setFetchType()

setFetchType

(

$fetchType

)

Parâmetros

character

$fetchType

Set fetch type. Use MQuery::FETCH_* constants.

setOrder()

setOrder

(

$order

)

setPageLength()

setPageLength

(

$pagelength

)

setSQL()

setSQL

(

&

$sql

)

setSQLCommand()

setSQLCommand

(

$sqlCommand

)

Documentação dos campos e atributos

$_miolo

$_miolo

$conn

$conn

$error

$error

$fetched

$fetched

$fetchType

$fetchType = self::FETCH_NUM

protected

$filtered

$filtered

$maxrows

$maxrows

$objSql

$objSql

$offset

$offset

$order

$order

$pagelength

$pagelength

$queryfilter

$queryfilter

$sql

$sql

$statement

$statement

FETCH_ASSOC

const FETCH_ASSOC = 'a'

FETCH_BOTH

const FETCH_BOTH = 'b'

FETCH_NUM

const FETCH_NUM = 'n'

FETCH_OBJ

const FETCH_OBJ = 'o'

---

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

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