TYPO3  7.6
Public Member Functions | Protected Attributes | List of all members
AdodbPreparedStatement Class Reference
Inheritance diagram for AdodbPreparedStatement:
DatabaseConnection 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 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)
 
 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 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)
 
 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=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 ()
 
 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 DatabaseConnection
 $printErrors = false
 
 $table2handlerKeys = array()
 
 $lastQuery = ''
 
 $lastParsedAndMappedQueryArray = array()
 
 $resourceIdToTableNameMap = array()
 
 $cache_handlerKeyFromTableList = array()
 
 $cache_mappingFromTableList = array()
 
 $cacheIdentifier = 'DatabaseConnection_fieldInfo'
 
 $installerSql = null
 
 $queryCache
 
 $mysqlDataTypeMapping
 
 $dbmsSpecifics
 
- Protected Attributes inherited from 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()
 

Additional Inherited Members

- Public Attributes inherited from DatabaseConnection
 $debug = false
 
 $conf = array()
 
 $mapping = array()
 
 $handlerCfg
 
 $handlerInstance = array()
 
 $lastHandlerKey = ''
 
 $cache_autoIncFields = array()
 
 $cache_fieldType = array()
 
 $cache_primaryKeys = array()
 
 $SQLparser
 
- Protected Member Functions inherited from 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=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)
 
- Static Protected Attributes inherited from 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 (   $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 AdodbPreparedStatement\$databaseConnection, AdodbPreparedStatement\$query, AdodbPreparedStatement\$queryComponents, and DatabaseConnection\query().

Member Function Documentation

__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 (   $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 ( )

Closes a prepared statement.

Returns
bool TRUE on success or FALSE on failure

Definition at line 241 of file AdodbPreparedStatement.php.

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 ( )

Executes a prepared query.

Returns
bool TRUE on success or FALSE on failure

Definition at line 136 of file AdodbPreparedStatement.php.

References AdodbPreparedStatement\$query, and GeneralUtility\intExplode().

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 ( )

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

Returns
array

Definition at line 209 of file AdodbPreparedStatement.php.

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 ( )

Resets a prepared statement.

Returns
bool TRUE on success or FALSE on failure

Definition at line 126 of file AdodbPreparedStatement.php.

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
protected

Definition at line 30 of file AdodbPreparedStatement.php.

Referenced by AdodbPreparedStatement\__construct().

$parameters
protected

Definition at line 45 of file AdodbPreparedStatement.php.

$query
protected
$queryComponents
protected

Definition at line 40 of file AdodbPreparedStatement.php.

Referenced by AdodbPreparedStatement\__construct().

$recordSet
protected

Definition at line 50 of file AdodbPreparedStatement.php.