Docs For Class DBLMYSQLQuery

Description

Class implementing MYSQL interface.

This class adds MySQL specific code to the DBLSQLQuery class.

DBLQuery
   |
   --DBLSQLQuery
      |
      --DBLMYSQLQuery

Variable Summary

int $c

int $lastRes

Method Summary

DBLMYSQLQuery DBLMYSQLQuery (mixed &$def, mixed $sourceDef)

void buildLimitStatement ()

void connect ()

void error (string $text)

void execSQL (mixed $sql, [mixed $calledInternally = false])

void getNumRows ()

void lastInsertID ()

void nextRecord ()

void noDeletedRecords ()

void noModifiedRecords ()

Variables

int $c (line 21)

var: MYSQL connection link identifier.

int $lastRes (line 25)

var: MYSQL last result identifier.

Inherited Variables

Inherited from DBLSQLQuery

DBLSQLQuery::$generateUniqueID
DBLSQLQuery::$groupBy
DBLSQLQuery::$having
DBLSQLQuery::$idFieldName
DBLSQLQuery::$nextSearchSQL
DBLSQLQuery::$sequenceName
DBLSQLQuery::$where

Inherited from DBLQuery

DBLQuery::$conditions
DBLQuery::$def
DBLQuery::$fields
DBLQuery::$offset
DBLQuery::$orderDef
DBLQuery::$orderReferse
DBLQuery::$records
DBLQuery::$srcDef
DBLQuery::$values

Methods

Constructor DBLMYSQLQuery (line 28)

DBLMYSQLQuery DBLMYSQLQuery (mixed &$def, mixed $sourceDef)

buildLimitStatement (line 37)

void buildLimitStatement ()

Redefinition of:

DBLSQLQuery::buildLimitStatement(): Internal function to build limit statement.

connect (line 57)

Internal - connect if connection was not yet established.

void connect ()

error (line 49)

Internal - display SQL error.

void error (string $text)

string $text: Error text.

execSQL (line 69)

void execSQL (mixed $sql, [mixed $calledInternally = false])

Redefinition of:

DBLSQLQuery::execSQL(): Executes given SQL query.

getNumRows (line 110)

void getNumRows ()

lastInsertID (line 105)

void lastInsertID ()

Redefinition of:

DBLSQLQuery::lastInsertID(): Returns auto increment ID of the last inserted record.

nextRecord (line 90)

void nextRecord ()

Redefinition of:

DBLQuery::nextRecord(): Gets next record from a result set.

noDeletedRecords (line 123)

void noDeletedRecords ()

Redefinition of:

DBLSQLQuery::noDeletedRecords(): Returns number of deleted records.

noModifiedRecords (line 118)

void noModifiedRecords ()

Redefinition of:

DBLSQLQuery::noModifiedRecords(): Returns number of modified records.

Inherited Methods

Inherited From DBLSQLQuery

DBLSQLQuery::DBLSQLQuery()
DBLSQLQuery::addCondition()
DBLSQLQuery::addRecord()
DBLSQLQuery::addSQLCondition()
DBLSQLQuery::buildLimitStatement()
DBLSQLQuery::buildSQL()
DBLSQLQuery::deleteRecord()
DBLSQLQuery::execSQL()
DBLSQLQuery::formatDateTime()
DBLSQLQuery::getDefaultDateTime()
DBLSQLQuery::getNoRows()
DBLSQLQuery::isEmptyDateTime()
DBLSQLQuery::lastInsertID()
DBLSQLQuery::modifyRecord()
DBLSQLQuery::nextUniqueID()
DBLSQLQuery::noDeletedRecords()
DBLSQLQuery::noModifiedRecords()
DBLSQLQuery::parseDateTime()
DBLSQLQuery::reset()
DBLSQLQuery::search()
DBLSQLQuery::setGroupBy()
DBLSQLQuery::setNextSearchSQL()
DBLSQLQuery::setOrder()

Inherited From DBLQuery

DBLQuery::DBLQuery()
DBLQuery::addCondition()
DBLQuery::addRecord()
DBLQuery::addValue()
DBLQuery::clearConditions()
DBLQuery::clearValues()
DBLQuery::deleteRecord()
DBLQuery::formatDateTime()
DBLQuery::getDefaultDateTime()
DBLQuery::isEmptyDateTime()
DBLQuery::modifyRecord()
DBLQuery::nextRecord()
DBLQuery::parseDateTime()
DBLQuery::reset()
DBLQuery::search()
DBLQuery::setFields()
DBLQuery::setLimit()
DBLQuery::setOrder()
DBLQuery::setSource()