Generic class to query the database

Located in /myMVC/GenericSQL.php (line 26)

myMVC_TypeCheck
   |
   --myMVC_DatabaseConnector
      |
      --myMVC_BaseDB
         |
         --myMVC_GenericSQL

Inherited Variables

Inherited from myMVC_BaseDB

myMVC_BaseDB::$autoincrement
myMVC_BaseDB::$counters
myMVC_BaseDB::$engine
myMVC_BaseDB::$fields
myMVC_BaseDB::$finders
myMVC_BaseDB::$oldValues
myMVC_BaseDB::$pk
myMVC_BaseDB::$table
myMVC_BaseDB::$uniques
myMVC_BaseDB::$values

Inherited from myMVC_DatabaseConnector

myMVC_DatabaseConnector::$database
myMVC_DatabaseConnector::$login
myMVC_DatabaseConnector::$password
myMVC_DatabaseConnector::$server

static executeQuery (line 46)

Sends the given query to the engine an returns the result as array

• return: The result as array of arrays or NULL if no data was found
• throws: myMVC_DatabaseException On generic problem
• access: public

array executeQuery (string $sql, [boolean $linear = false], [$assoc $assoc = false])

• string $sql: The SQL query
• boolean $linear: If true, all data will returned as one numeric array, otherwise (default) they will returned as array of arrays
• $assoc $assoc: If true data will be returned as associative array. Default: false

static quoteSql (line 87)

Quotes a string to use in a SQL-Query

• return: A secure SQL-String (quoted)
• access: public

string quoteSql (string $value)

• string $value: The string with the Query

static quoteSqlForLike (line 101)

Quotes a string to use in a SQL-Query (with LIKE)

• return: A secure SQL-String (quoted)
• access: public

string quoteSqlForLike (string $value, [string $prefix = '%'], [string $suffix = '%'])

• string $value: The string with the Query
• string $prefix: (normally %) added BEFORE the string
• string $suffix: (normally %) added AFTER the string

Constructor __construct (line 31)

Constructor.

• access: public

myMVC_GenericSQL __construct ()

---

Redefinition of:

myMVC_BaseDB::__construct()

Constructor

Inherited Methods

Inherited From myMVC_BaseDB

myMVC_BaseDB::__construct()
myMVC_BaseDB::callCounter()
myMVC_BaseDB::callFinder()
myMVC_BaseDB::callIterator()
myMVC_BaseDB::checkFields()
myMVC_BaseDB::checkUniques()
myMVC_BaseDB::createWhere()
myMVC_BaseDB::delete()
myMVC_BaseDB::deleteAll()
myMVC_BaseDB::findAll()
myMVC_BaseDB::findByParameter()
myMVC_BaseDB::findByPK()
myMVC_BaseDB::findBySQLQuery()
myMVC_BaseDB::getCountAll()
myMVC_BaseDB::getCountByParameter()
myMVC_BaseDB::isRecordUnique()
myMVC_BaseDB::iterateAll()
myMVC_BaseDB::now()
myMVC_BaseDB::nowFormatted()
myMVC_BaseDB::registerCounter()
myMVC_BaseDB::registerFinder()
myMVC_BaseDB::save()
myMVC_BaseDB::saveValues()
myMVC_BaseDB::sqlExportByParameter()
myMVC_BaseDB::__call()

Inherited From myMVC_DatabaseConnector

myMVC_DatabaseConnector::__construct()
myMVC_DatabaseConnector::errno()
myMVC_DatabaseConnector::error()
myMVC_DatabaseConnector::execute()
myMVC_DatabaseConnector::executeSelect()
myMVC_DatabaseConnector::freeResult()
myMVC_DatabaseConnector::getDatabaseConnection()
myMVC_DatabaseConnector::getRowsNum()
myMVC_DatabaseConnector::getValueArrayFromResult()
myMVC_DatabaseConnector::getValuesFromResult()
myMVC_DatabaseConnector::quoteSqlString()
myMVC_DatabaseConnector::quoteSqlStringForLike()

Inherited From myMVC_TypeCheck

myMVC_TypeCheck::checkAutoIncrementalId()
myMVC_TypeCheck::checkBoolNotNull()
myMVC_TypeCheck::checkBoolNull()
myMVC_TypeCheck::checkDateNotNull()
myMVC_TypeCheck::checkDateNull()
myMVC_TypeCheck::checkDateTimeNotNull()
myMVC_TypeCheck::checkDateTimeNull()
myMVC_TypeCheck::checkDomainnameNotNull()
myMVC_TypeCheck::checkDomainnameNull()
myMVC_TypeCheck::checkEMailNotNull()
myMVC_TypeCheck::checkEMailNull()
myMVC_TypeCheck::checkIPNotNull()
myMVC_TypeCheck::checkIPNull()
myMVC_TypeCheck::checkMacNotNull()
myMVC_TypeCheck::checkMacNull()
myMVC_TypeCheck::checkMaskNotNull()
myMVC_TypeCheck::checkMaskNull()
myMVC_TypeCheck::checkNetworkNotNull()
myMVC_TypeCheck::checkNetworkNull()
myMVC_TypeCheck::checkSignedIntNotNull()
myMVC_TypeCheck::checkSignedIntNull()
myMVC_TypeCheck::checkSignedMediumIntNotNull()
myMVC_TypeCheck::checkSignedMediumIntNull()
myMVC_TypeCheck::checkSignedSmallIntNotNull()
myMVC_TypeCheck::checkSignedSmallIntNull()
myMVC_TypeCheck::checkSignedTinyIntNotNull()
myMVC_TypeCheck::checkSignedTinyIntNull()
myMVC_TypeCheck::checkString255NotNull()
myMVC_TypeCheck::checkString255Null()
myMVC_TypeCheck::checkTextNotNull()
myMVC_TypeCheck::checkTextNull()
myMVC_TypeCheck::checkTimeNotNull()
myMVC_TypeCheck::checkTimeNull()
myMVC_TypeCheck::checkUnsignedIntNotNull()
myMVC_TypeCheck::checkUnsignedIntNull()
myMVC_TypeCheck::checkUnsignedMediumIntNotNull()
myMVC_TypeCheck::checkUnsignedMediumIntNull()
myMVC_TypeCheck::checkUnsignedSmallIntNotNull()
myMVC_TypeCheck::checkUnsignedSmallIntNull()
myMVC_TypeCheck::checkUnsignedTinyIntNotNull()
myMVC_TypeCheck::checkUnsignedTinyIntNull()
myMVC_TypeCheck::checkURLNotNull()
myMVC_TypeCheck::checkURLNull()