TYPO3 CMS  TYPO3_6-2
ux_t3lib_DB Class Reference
Inheritance diagram for ux_t3lib_DB:
TYPO3\CMS\Dbal\Database\DatabaseConnection TYPO3\CMS\Core\Database\DatabaseConnection

Additional Inherited Members

- Public Member Functions inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 __construct ()
 
 initialize ()
 
 getSpecifics ()
 
 clearCachedFieldInfo ()
 
 cacheFieldInfo ()
 
 exec_INSERTquery ($table, $fields_values, $no_quote_fields=FALSE)
 
 exec_INSERTmultipleRows ($table, array $fields, array $rows, $no_quote_fields=FALSE)
 
 exec_UPDATEquery ($table, $where, $fields_values, $no_quote_fields=FALSE)
 
 exec_DELETEquery ($table, $where)
 
 exec_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy='', $orderBy='', $limit='')
 
 exec_TRUNCATEquery ($table)
 
 INSERTquery ($table, $fields_values, $no_quote_fields=FALSE)
 
 INSERTmultipleRows ($table, array $fields, array $rows, $no_quote_fields=FALSE)
 
 UPDATEquery ($table, $where, $fields_values, $no_quote_fields=FALSE)
 
 DELETEquery ($table, $where)
 
 SELECTquery ($select_fields, $from_table, $where_clause, $groupBy='', $orderBy='', $limit='')
 
 TRUNCATEquery ($table)
 
 prepare_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy='', $orderBy='', $limit='', array $input_parameters=array())
 
 quoteFieldNames ($select_fields)
 
 quoteFromTables ($from_table)
 
 quoteWhereClause ($where_clause)
 
 fullQuoteStr ($str, $table, $allowNull=FALSE)
 
 quoteStr ($str, $table)
 
 quoteName ($name, $handlerKey=NULL, $useBackticks=FALSE)
 
 MetaType ($type, $table, $maxLength=-1)
 
 MySQLMetaType ($t)
 
 MySQLActualType ($meta)
 
 sql_error ()
 
 sql_errno ()
 
 sql_num_rows ($res)
 
 sql_fetch_assoc ($res)
 
 sql_fetch_row ($res)
 
 sql_free_result ($res)
 
 sql_insert_id ()
 
 sql_affected_rows ()
 
 sql_data_seek ($res, $seek)
 
 sql_field_metatype ($table, $field)
 
 sql_field_type ($res, $pointer)
 
 sql_query ($query)
 
 sql_pconnect ($host=NULL, $username=NULL, $password=NULL)
 
 sql_select_db ($TYPO3_db=NULL)
 
 admin_get_tables ()
 
 admin_query ($query)
 
 handler_getFromTableList ($tableList)
 
 handler_init ($handlerKey)
 
 isConnected ()
 
 runningNative ()
 
 runningADOdbDriver ($driver)
 
 debugHandler ($function, $execTime, $inData)
 
 debug_WHERE ($table, $where, $script='')
 
 debug_log ($query, $ms, $data, $join, $errorFlag, $script='')
 
 debug_explain ($query)
 
- Public Member Functions inherited from TYPO3\CMS\Core\Database\DatabaseConnection
 initialize ()
 
 exec_SELECT_mm_query ($select, $local_table, $mm_table, $foreign_table, $whereClause='', $groupBy='', $orderBy='', $limit='')
 
 exec_SELECT_queryArray ($queryParts)
 
 exec_SELECTgetRows ($select_fields, $from_table, $where_clause, $groupBy='', $orderBy='', $limit='', $uidIndexField='')
 
 exec_SELECTgetSingleRow ($select_fields, $from_table, $where_clause, $groupBy='', $orderBy='', $numIndex=FALSE)
 
 exec_SELECTcountRows ($field, $table, $where='1=1')
 
 INSERTquery ($table, $fields_values, $no_quote_fields=FALSE)
 
 SELECTsubquery ($select_fields, $from_table, $where_clause)
 
 listQuery ($field, $value, $table)
 
 searchQuery ($searchWords, $fields, $table, $constraint=self::AND_Constraint)
 
 prepare_SELECTqueryArray (array $queryParts, array $input_parameters=array())
 
 prepare_PREPAREDquery ($query, array $queryComponents)
 
 fullQuoteStr ($str, $table, $allowNull=FALSE)
 
 fullQuoteArray ($arr, $table, $noQuote=FALSE, $allowNull=FALSE)
 
 quoteStr ($str, $table)
 
 escapeStrForLike ($str, $table)
 
 cleanIntArray ($arr)
 
 cleanIntList ($list)
 
 stripOrderBy ($str)
 
 stripGroupBy ($str)
 
 splitGroupOrderLimit ($str)
 
 getDateTimeFormats ($table)
 
 sql_query ($query)
 
 sql_error ()
 
 sql_errno ()
 
 sql_num_rows ($res)
 
 sql_fetch_assoc ($res)
 
 sql_fetch_row ($res)
 
 sql_free_result ($res)
 
 sql_insert_id ()
 
 sql_affected_rows ()
 
 sql_data_seek ($res, $seek)
 
 sql_field_type ($res, $pointer)
 
 sql_pconnect ($host=NULL, $username=NULL, $password=NULL)
 
 sql_select_db ($TYPO3_db=NULL)
 
 admin_get_dbs ()
 
 admin_get_tables ()
 
 admin_get_fields ($tableName)
 
 admin_get_keys ($tableName)
 
 admin_get_charsets ()
 
 admin_query ($query)
 
 setDatabaseHost ($host='localhost')
 
 setDatabasePort ($port=3306)
 
 setDatabaseSocket ($socket=NULL)
 
 setDatabaseName ($name)
 
 setDatabaseUsername ($username)
 
 setDatabasePassword ($password)
 
 setPersistentDatabaseConnection ($persistentDatabaseConnection)
 
 setConnectionCompression ($connectionCompression)
 
 setInitializeCommandsAfterConnect (array $commands)
 
 setConnectionCharset ($connectionCharset='utf8')
 
 connectDB ($host=NULL, $username=NULL, $password=NULL, $db=NULL)
 
 isConnected ()
 
 getDatabaseHandle ()
 
 setDatabaseHandle ($handle)
 
 debug ($func, $query='')
 
 debug_check_recordset ($res)
 
 __sleep ()
 
- Public Attributes inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 $debug = FALSE
 
 $conf = array()
 
 $mapping = array()
 
 $handlerCfg
 
 $handlerInstance = array()
 
 $lastHandlerKey = ''
 
 $cache_autoIncFields = array()
 
 $cache_fieldType = array()
 
 $cache_primaryKeys = array()
 
 $SQLparser
 
- Public Attributes inherited from TYPO3\CMS\Core\Database\DatabaseConnection
const AND_Constraint = 'AND'
 
const OR_Constraint = 'OR'
 
 $debugOutput = FALSE
 
 $debug_lastBuiltQuery = ''
 
 $store_lastBuiltQuery = FALSE
 
 $explainOutput = 0
 
 $default_charset = 'utf8'
 
- Protected Member Functions inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 getFieldInfoCache ()
 
 analyzeCachingTables ()
 
 analyzeExtensionTables ()
 
 parseAndAnalyzeSql ($sql)
 
 getCompleteFieldInformation ()
 
 getCacheableString (array $fieldInformation)
 
 analyzeFields ($parsedExtSQL)
 
 mapCachedFieldInfo (array $fieldInfo)
 
 exec_query (array $queryParts)
 
 query ($query)
 
 SELECTqueryFromArray (array $params)
 
 compileSelectParameters (array $params)
 
 getQueryComponents ($select_fields, $from_table, $where_clause, $groupBy, $orderBy, $limit)
 
 precompileSELECTquery (array $components)
 
 quoteSELECTsubquery (array $components)
 
 _quoteFieldNames (array $select_fields)
 
 _quoteFromTables (array $from_table)
 
 _quoteWhereClause (array $where_clause)
 
 quoteGroupBy ($groupBy)
 
 _quoteGroupBy (array $groupBy)
 
 quoteOrderBy ($orderBy)
 
 _quoteOrderBy (array $orderBy)
 
 determineHandlerType ($res)
 
 map_needMapping ($tableList, $fieldMappingOnly=FALSE, array &$parsedTableList=array())
 
 map_assocArray ($input, $tables, $rev=FALSE)
 
 map_remapSELECTQueryParts ($select_fields, $from_table, $where_clause, $groupBy, $orderBy)
 
 getMappingKey ($tableName)
 
 getFreeMappingKey ($tableName)
 
 map_sqlParts (&$sqlPartArray, $defaultTable)
 
 map_subquery (&$parsedQuery)
 
 map_genericQueryParsed (&$parsedQuery)
 
 map_fieldNamesInArray ($table, &$fieldArray)
 
- Protected Member Functions inherited from TYPO3\CMS\Core\Database\DatabaseConnection
 query ($query)
 
 setSqlMode ()
 
 checkConnectionCharset ()
 
 disconnectIfConnected ()
 
 handleDeprecatedConnectArguments ($host=NULL, $username=NULL, $password=NULL, $db=NULL)
 
 explain ($query, $from_table, $row_count)
 
- Protected Attributes inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 $printErrors = FALSE
 
 $table2handlerKeys = array()
 
 $lastQuery = ''
 
 $lastParsedAndMappedQueryArray = array()
 
 $resourceIdToTableNameMap = array()
 
 $cache_handlerKeyFromTableList = array()
 
 $cache_mappingFromTableList = array()
 
 $cacheIdentifier = 't3lib_db_fieldInfo'
 
 $installerSql = NULL
 
 $queryCache
 
 $mysqlDataTypeMapping
 
 $dbmsSpecifics
 
- Protected Attributes inherited from TYPO3\CMS\Core\Database\DatabaseConnection
 $databaseHost = ''
 
 $databasePort = 3306
 
 $databaseSocket = NULL
 
 $databaseName = ''
 
 $databaseUsername = ''
 
 $databaseUserPassword = ''
 
 $persistentDatabaseConnection = FALSE
 
 $connectionCompression = FALSE
 
 $connectionCharset = 'utf8'
 
 $initializeCommandsAfterConnect = array()
 
 $isConnected = FALSE
 
 $link = NULL
 
 $preProcessHookObjects = array()
 
 $postProcessHookObjects = array()
 
- Static Protected Attributes inherited from TYPO3\CMS\Core\Database\DatabaseConnection
static $dateTimeFormats
 

Detailed Description

Deprecated:
since 6.0 will be removed in 7.0

Definition at line 1442 of file LegacyClassesForIde.php.