TYPO3 CMS  TYPO3_7-6
TYPO3\CMS\Dbal\Database\AdodbPreparedStatement Class Reference
Inheritance diagram for TYPO3\CMS\Dbal\Database\AdodbPreparedStatement:
TYPO3\CMS\Dbal\Database\DatabaseConnection TYPO3\CMS\Core\Database\DatabaseConnection

Public Member Functions

 __construct ($query, array $queryComponents, \TYPO3\CMS\Dbal\Database\DatabaseConnection $databaseConnection)
 
 prepare ()
 
 store_result ()
 
 bind_param ($types, $var1, $_=null)
 
 reset ()
 
 execute ()
 
 fetch_fields ()
 
 fetch ()
 
 data_seek ($offset)
 
 close ()
 
 __get ($name)
 
- 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=[])
 
 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)
 
 getMetadata ($type, $table, $field, $maxLength=-1)
 
 MySQLMetaType ($t)
 
 MySQLActualType ($meta)
 
 getEquivalentIndexDefinition ($indexSQL)
 
 getEquivalentFieldDefinition ($fieldSQL)
 
 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 ()
 
 sql_select_db ()
 
 admin_get_tables ()
 
 admin_query ($query)
 
 handler_getFromTableList ($tableList)
 
 handler_init ($handlerKey)
 
 isConnected ()
 
 runningNative ()
 
 runningADOdbDriver ($driver)
 
 getServerVersion ()
 
 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
static 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)
 
 SELECT_mm_query ($select, $local_table, $mm_table, $foreign_table, $whereClause='', $groupBy='', $orderBy='', $limit='')
 
 listQuery ($field, $value, $table)
 
 searchQuery ($searchWords, $fields, $table, $constraint=self::AND_Constraint)
 
 prepare_SELECTqueryArray (array $queryParts, array $input_parameters=[])
 
 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 ()
 
 sql_select_db ()
 
 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 ()
 
 isConnected ()
 
 getDatabaseHandle ()
 
 setDatabaseHandle ($handle)
 
 getServerVersion ()
 
 debug ($func, $query='')
 
 debug_check_recordset ($res)
 
 __sleep ()
 

Protected Attributes

 $databaseConnection
 
 $query
 
 $queryComponents
 
 $parameters
 
 $recordSet
 
- Protected Attributes inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 $printErrors = false
 
 $table2handlerKeys = []
 
 $lastQuery = ''
 
 $lastParsedAndMappedQueryArray = []
 
 $resourceIdToTableNameMap = []
 
 $cache_handlerKeyFromTableList = []
 
 $cache_mappingFromTableList = []
 
 $cacheIdentifier = 'DatabaseConnection_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 = []
 
 $isConnected = false
 
 $link = null
 
 $preProcessHookObjects = []
 
 $postProcessHookObjects = []
 

Additional Inherited Members

- Public Attributes inherited from TYPO3\CMS\Dbal\Database\DatabaseConnection
 $debug = false
 
 $conf = []
 
 $mapping = []
 
 $handlerCfg
 
 $handlerInstance = []
 
 $lastHandlerKey = ''
 
 $cache_autoIncFields = []
 
 $cache_fieldType = []
 
 $cache_primaryKeys = []
 
 $SQLparser
 
 MYSQLI_TYPE_CHAR
 
- 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)
 
 updateLastInsertId ($table, array $fieldValues)
 
 determineHandlerType ($res)
 
 map_needMapping ($tableList, $fieldMappingOnly=false, array &$parsedTableList=[])
 
 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)
 
 getSelectMmQueryParts ($select, $local_table, $mm_table, $foreign_table, $whereClause='', $groupBy='', $orderBy='', $limit='')
 
 checkConnectionCharset ()
 
 disconnectIfConnected ()
 
 explain ($query, $from_table, $row_count)
 
- Static Protected Attributes inherited from TYPO3\CMS\Core\Database\DatabaseConnection
static $dateTimeFormats
 

Detailed Description

MySQLi Prepared Statement-compatible implementation for ADOdb.

Notice: Extends to be able to access protected properties solely (thus would be a "friend" class in C++).

Definition at line 25 of file AdodbPreparedStatement.php.

Constructor & Destructor Documentation

◆ __construct()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::__construct (   $query,
array  $queryComponents,
\TYPO3\CMS\Dbal\Database\DatabaseConnection  $databaseConnection 
)

Default constructor.

Parameters
string$query
array$queryComponents
\TYPO3\CMS\Dbal\Database\DatabaseConnection$databaseConnection

Definition at line 59 of file AdodbPreparedStatement.php.

References TYPO3\CMS\Dbal\Database\AdodbPreparedStatement\$databaseConnection, TYPO3\CMS\Dbal\Database\AdodbPreparedStatement\$query, TYPO3\CMS\Dbal\Database\AdodbPreparedStatement\$queryComponents, and TYPO3\CMS\Dbal\Database\DatabaseConnection\query().

Member Function Documentation

◆ __get()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::__get (   $name)

Magic getter for public properties of access by .

Parameters
string$name
Returns
mixed

Definition at line 253 of file AdodbPreparedStatement.php.

◆ bind_param()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::bind_param (   $types,
  $var1,
  $_ = null 
)

Binds variables to a prepared statement as parameters.

Parameters
string$types
mixed$var1The number of variables and length of string types must match the parameters in the statement.
mixed$_[optional]
Returns
bool TRUE on success or FALSE on failure
See also
::bind_param()

Definition at line 98 of file AdodbPreparedStatement.php.

◆ close()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::close ( )

Closes a prepared statement.

Returns
bool TRUE on success or FALSE on failure

Definition at line 241 of file AdodbPreparedStatement.php.

◆ data_seek()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::data_seek (   $offset)

Seeks to an arbitrary row in statement result set.

Parameters
int$offsetMust be between zero and the total number of rows minus one
Returns
bool TRUE on success or FALSE on failure

Definition at line 231 of file AdodbPreparedStatement.php.

◆ execute()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::execute ( )

Executes a prepared query.

Returns
bool TRUE on success or FALSE on failure

Definition at line 136 of file AdodbPreparedStatement.php.

References TYPO3\CMS\Dbal\Database\AdodbPreparedStatement\$query, and TYPO3\CMS\Core\Utility\GeneralUtility\intExplode().

◆ fetch()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::fetch ( )

Fetches a row from the underlying result set.

Returns
array Array of rows or FALSE if there are no more rows.

Definition at line 219 of file AdodbPreparedStatement.php.

◆ fetch_fields()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::fetch_fields ( )

Returns an array of objects representing the fields in a result set.

Returns
array

Definition at line 209 of file AdodbPreparedStatement.php.

◆ prepare()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::prepare ( )

Prepares an SQL statement for execution.

Returns
bool TRUE on success or FALSE on failure

Definition at line 72 of file AdodbPreparedStatement.php.

◆ reset()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::reset ( )

Resets a prepared statement.

Returns
bool TRUE on success or FALSE on failure

Definition at line 126 of file AdodbPreparedStatement.php.

◆ store_result()

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::store_result ( )

Transfers a result set from a prepared statement.

Returns
TRUE on success or FALSE on failure

Definition at line 84 of file AdodbPreparedStatement.php.

Member Data Documentation

◆ $databaseConnection

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::$databaseConnection
protected

◆ $parameters

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::$parameters
protected

Definition at line 45 of file AdodbPreparedStatement.php.

◆ $query

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::$query
protected

◆ $queryComponents

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::$queryComponents
protected

◆ $recordSet

TYPO3\CMS\Dbal\Database\AdodbPreparedStatement::$recordSet
protected

Definition at line 50 of file AdodbPreparedStatement.php.