Inheritance diagram for TYPO3\CMS\Core\Database\DatabaseConnection:

Public Member Functions
	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
const	AND_Constraint = 'AND'

const	OR_Constraint = 'OR'

	$debugOutput = FALSE

	$debug_lastBuiltQuery = ''

	$store_lastBuiltQuery = FALSE

	$explainOutput = 0

	$default_charset = 'utf8'

Protected Member Functions
	query ($query)

	setSqlMode ()

	checkConnectionCharset ()

	disconnectIfConnected ()

	handleDeprecatedConnectArguments ($host=NULL, $username=NULL, $password=NULL, $db=NULL)

	explain ($query, $from_table, $row_count)

Protected Attributes
	$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
static	$dateTimeFormats

Detailed Description

Contains the class "DatabaseConnection" containing functions for building SQL queries and mysqli wrappers, thus providing a foundational API to all database interaction. This class is instantiated globally as $TYPO3_DB in TYPO3 scripts.

TYPO3 "database wrapper" class (new in 3.6.0) This class contains

abstraction functions for executing INSERT/UPDATE/DELETE/SELECT queries ("Query execution"; These are REQUIRED for all future connectivity to the database, thus ensuring DBAL compliance!)
functions for building SQL queries (INSERT/UPDATE/DELETE/SELECT) ("Query building"); These are transitional functions for building SQL queries in a more automated way. Use these to build queries instead of doing it manually in your code!
mysqli wrapper functions; These are transitional functions. By a simple search/replace you should be able to substitute all mysql*() calls with $GLOBALS['TYPO3_DB']->sql*() and your application will work out of the box. YOU CANNOT (legally) use any mysqli functions not found as wrapper functions in this class! See the Project Coding Guidelines (doc_core_cgl) for more instructions on best-practise

This class is not in itself a complete database abstraction layer but can be extended to be a DBAL (by extensions, see "dbal" for example) ALL connectivity to the database in TYPO3 must be done through this class! The points of this class are:

To direct all database calls through this class so it becomes possible to implement DBAL with extensions.
To keep it very easy to use for developers used to MySQL in PHP - and preserve as much performance as possible when TYPO3 is used with MySQL directly...
To create an interface for DBAL implemented by extensions; (Eg. making possible escaping characters, clob/blob handling, reserved words handling)
Benchmarking the DB bottleneck queries will become much easier; Will make it easier to find optimization possibilities.

USE: In all TYPO3 scripts the global variable $TYPO3_DB is an instance of this class. Use that. Eg. $GLOBALS['TYPO3_DB']->sql_fetch_assoc()

Author: Kasper Skårhøj kaspe.nosp@m.rYYY.nosp@m.Y@typ.nosp@m.o3.c.nosp@m.om

Definition at line 46 of file DatabaseConnection.php.

Member Function Documentation

◆ __sleep()

TYPO3\CMS\Core\Database\DatabaseConnection::__sleep ( )

Serialize destructs current connection

Returns: array All protected properties that should be saved

Definition at line 1929 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ admin_get_charsets()

TYPO3\CMS\Dbal\Database\DatabaseConnection::admin_get_charsets ( )

Returns information about the character sets supported by the current DBM This function is important not only for the Install Tool but probably for DBALs as well since they might need to look up table specific information in order to construct correct queries. In such cases this information should probably be cached for quick delivery.

This is used by the Install Tool to convert tables with non-UTF8 charsets Use in Install Tool only!

Returns: array Array with Charset as key and an array of "Charset", "Description", "Default collation", "Maxlen" as values

Returns information about the character sets supported by the current DBM This function is important not only for the Install Tool but probably for DBALs as well since they might need to look up table specific information in order to construct correct queries. In such cases this information should probably be cached for quick delivery.

This is used by the Install Tool to convert tables tables with non-UTF8 charsets Use in Install Tool only!

Returns: array Array with Charset as key and an array of "Charset", "Description", "Default collation", "Maxlen" as values

Definition at line 1402 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\query().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\admin_get_tables().

◆ admin_get_dbs()

TYPO3\CMS\Dbal\Database\DatabaseConnection::admin_get_dbs ( )

Listing databases from current MySQL connection. NOTICE: It WILL try to select those databases and thus break selection of current database. This is only used as a service function in the (1-2-3 process) of the Install Tool. In any case a lookup should be done in the _DEFAULT handler DBMS then. Use in Install Tool only!

Returns: array Each entry represents a database name

Exceptions

Definition at line 1304 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\query(), TYPO3\CMS\Core\Database\DatabaseConnection\setDatabaseName(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_select_db().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\sql_select_db().

◆ admin_get_fields()

TYPO3\CMS\Dbal\Database\DatabaseConnection::admin_get_fields ( $tableName )

Returns information about each field in the $table (quering the DBMS) In a DBAL this should look up the right handler for the table and return compatible information This function is important not only for the Install Tool but probably for DBALs as well since they might need to look up table specific information in order to construct correct queries. In such cases this information should probably be cached for quick delivery.

Parameters

string $tableName Table name

Returns: array Field information in an associative array with fieldname => field row

Definition at line 1359 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\query().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\admin_get_tables().

◆ admin_get_keys()

TYPO3\CMS\Dbal\Database\DatabaseConnection::admin_get_keys ( $tableName )

Returns information about each index key in the $table (quering the DBMS) In a DBAL this should look up the right handler for the table and return compatible information

Parameters

string $tableName Table name

Returns: array Key information in a numeric array

Definition at line 1378 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\query().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\admin_get_tables().

◆ admin_get_tables()

TYPO3\CMS\Core\Database\DatabaseConnection::admin_get_tables ( )

Returns the list of tables from the default database, TYPO3_db (quering the DBMS) In a DBAL this method should 1) look up all tables from the DBMS of the _DEFAULT handler and then 2) add all tables configured to be managed by other handlers

Returns: array Array with tablenames as key and arrays with status information as value

Definition at line 1336 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\query().

◆ admin_query()

TYPO3\CMS\Core\Database\DatabaseConnection::admin_query ( $query )

mysqli() wrapper function, used by the Install Tool and EM for all queries regarding management of the database!

Parameters

string $query Query to execute

Returns: boolean||object MySQLi result object / DBAL object

Definition at line 1420 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), and TYPO3\CMS\Core\Database\DatabaseConnection\query().

◆ checkConnectionCharset()

TYPO3\CMS\Core\Database\DatabaseConnection::checkConnectionCharset ( )

protected

Checks if the current connection character set has the same value as the connectionCharset variable.

To determine the character set these MySQL session variables are checked: character_set_client, character_set_results and character_set_connection.

If the character set does not match or if the session variables can not be read a RuntimeException is thrown.

Returns: void

Exceptions

Definition at line 1635 of file DatabaseConnection.php.

References $GLOBALS, TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_row(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_query(), and TYPO3\CMS\Core\Utility\GeneralUtility\SYSLOG_SEVERITY_ERROR.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect().

◆ cleanIntArray()

TYPO3\CMS\Core\Database\DatabaseConnection::cleanIntArray ( $arr )

Will convert all values in the one-dimensional array to integers. Useful when you want to make sure an array contains only integers before imploding them in a select-list.

Parameters

array $arr Array with values

Returns: array The input array with all values cast to (int)

See also: cleanIntList()

Definition at line 881 of file DatabaseConnection.php.

◆ cleanIntList()

TYPO3\CMS\Core\Database\DatabaseConnection::cleanIntList ( $list )

Will force all entries in the input comma list to integers Useful when you want to make sure a commalist of supposed integers really contain only integers; You want to know that when you don't trust content that could go into an SQL statement.

Parameters

string $list List of comma-separated values which should be integers

Returns: string The input list but with every value cast to (int)

See also: cleanIntArray()

Definition at line 893 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\intExplode().

◆ connectDB()

TYPO3\CMS\Core\Database\DatabaseConnection::connectDB	(	$host = `NULL`,
		$username = `NULL`,
		$password = `NULL`,
		$db = `NULL`
	)

Connects to database for TYPO3 sites:

Parameters

string	$host	Deprecated since 6.1, will be removed in two versions Database. host IP/domain[:port]
string	$username	Deprecated since 6.1, will be removed in two versions. Username to connect with
string	$password	Deprecated since 6.1, will be removed in two versions. Password to connect with
string	$db	Deprecated since 6.1, will be removed in two versions. Database name to connect to

Exceptions

Definition at line 1550 of file DatabaseConnection.php.

References $GLOBALS, $host, TYPO3\CMS\Core\Utility\GeneralUtility\getUserObj(), TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments(), TYPO3\CMS\Core\Database\DatabaseConnection\isConnected(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_select_db().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\fullQuoteStr(), TYPO3\CMS\Core\Database\DatabaseConnection\prepare_PREPAREDquery(), TYPO3\CMS\Core\Database\DatabaseConnection\query(), TYPO3\CMS\Dbal\Database\DatabaseConnection\query(), TYPO3\CMS\Core\Database\DatabaseConnection\quoteStr(), TYPO3\CMS\Dbal\Database\DatabaseConnection\quoteStr(), and TYPO3\CMS\Dbal\Database\DatabaseConnection\sql_query().

◆ debug()

TYPO3\CMS\Core\Database\DatabaseConnection::debug	(	$func,
		$query = `''`
	)

Debug function: Outputs error if any

Parameters

string	$func	Function calling debug()
string	$query	Last query if not last built query

Returns: void

Todo:: Define visibility

Definition at line 1773 of file DatabaseConnection.php.

References $GLOBALS, TYPO3\CMS\Core\Utility\DebugUtility\debug(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_error().

◆ debug_check_recordset()

TYPO3\CMS\Core\Database\DatabaseConnection::debug_check_recordset ( $res )

Checks if record set is valid and writes debugging information into devLog if not.

Parameters

boolean|

Definition at line 1798 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\devLog(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), and TYPO3\CMS\Core\Utility\GeneralUtility\SYSLOG_SEVERITY_ERROR.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\sql_data_seek(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_assoc(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_row(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_field_type(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_num_rows().

◆ disconnectIfConnected()

TYPO3\CMS\Core\Database\DatabaseConnection::disconnectIfConnected ( )

protected

Disconnect from database if connected

Returns: void

Definition at line 1702 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

◆ escapeStrForLike()

TYPO3\CMS\Core\Database\DatabaseConnection::escapeStrForLike	(	$str,
		$table
	)

Escaping values for SQL LIKE statements.

Parameters

string	$str	Input string
string	$table	Table name for which to escape string. Just enter the table that the field-value is selected from (and any DBAL will look up which handler to use and then how to quote the string!).

Returns: string Output string; % and _ will be escaped with \ (or otherwise based on DBAL handler)

See also: quoteStr()

Definition at line 869 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\_quoteWhereClause().

◆ exec_SELECT_mm_query()

TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECT_mm_query	(	$select,
		$local_table,
		$mm_table,
		$foreign_table,
		$whereClause = `''`,
		$groupBy = `''`,
		$orderBy = `''`,
		$limit = `''`
	)

Creates and executes a SELECT query, selecting fields ($select) from two/three tables joined Use $mm_table together with $local_table or $foreign_table to select over two tables. Or use all three tables to select the full MM-relation. The JOIN is done with [$local_table].uid <–> [$mm_table].uid_local / [$mm_table].uid_foreign <–> [$foreign_table].uid The function is very useful for selecting MM-relations between tables adhering to the MM-format used by TCE (TYPO3 Core Engine). See the section on $GLOBALS['TCA'] in Inside TYPO3 for more details.

Parameters

string	$select	Field list for SELECT
string	$local_table	Tablename, local table
string	$mm_table	Tablename, relation table
string	$foreign_table	Tablename, foreign table
string	$whereClause	Optional additional WHERE clauses put in the end of the query. NOTICE: You must escape values in this argument with $this->fullQuoteStr() yourself! DO NOT PUT IN GROUP BY, ORDER BY or LIMIT! You have to prepend 'AND ' to this parameter yourself!
string	$groupBy	Optional GROUP BY field(s), if none, supply blank string.
string	$orderBy	Optional ORDER BY field(s), if none, supply blank string.
string	$limit	Optional LIMIT value ([begin,]max), if none, supply blank string.

Returns: boolean||object MySQLi result object / DBAL object

See also: exec_SELECTquery()

Definition at line 334 of file DatabaseConnection.php.

◆ exec_SELECT_queryArray()

TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECT_queryArray ( $queryParts )

Executes a select based on input query parts array

Parameters

array $queryParts Query parts array

Returns: boolean||object MySQLi result object / DBAL object

See also: exec_SELECTquery()

Definition at line 353 of file DatabaseConnection.php.

◆ exec_SELECTcountRows()

TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTcountRows	(	$field,
		$table,
		$where = `'1=1'`
	)

Counts the number of rows in a table.

Parameters

string	$field	Name of the field to use in the COUNT() expression (e.g. '*')
string	$table	Name of the table to count rows for
string	$where	(optional) WHERE statement of the query

Returns: mixed Number of rows counter (integer) or FALSE if something went wrong (boolean)

Definition at line 430 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), TYPO3\CMS\Core\Database\DatabaseConnection\query(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_row(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result().

◆ exec_SELECTgetRows()

TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTgetRows	(	$select_fields,
		$from_table,
		$where_clause,
		$groupBy = `''`,
		$orderBy = `''`,
		$limit = `''`,
		$uidIndexField = `''`
	)

Creates and executes a SELECT SQL-statement AND traverse result set and returns array with records in.

Parameters

string	$select_fields	See exec_SELECTquery()
string	$from_table	See exec_SELECTquery()
string	$where_clause	See exec_SELECTquery()
string	$groupBy	See exec_SELECTquery()
string	$orderBy	See exec_SELECTquery()
string	$limit	See exec_SELECTquery()
string	$uidIndexField	If set, the result array will carry this field names value as index. Requires that field to be selected of course!

Returns: array|NULL Array of rows, or NULL in case of SQL error

Definition at line 369 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_assoc(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result().

◆ exec_SELECTgetSingleRow()

TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTgetSingleRow	(	$select_fields,
		$from_table,
		$where_clause,
		$groupBy = `''`,
		$orderBy = `''`,
		$numIndex = `FALSE`
	)

Creates and executes a SELECT SQL-statement AND gets a result set and returns an array with a single record in. LIMIT is automatically set to 1 and can not be overridden.

Parameters

string	$select_fields	List of fields to select from the table.
string	$from_table	Table(s) from which to select.
string	$where_clause	Optional additional WHERE clauses put in the end of the query. NOTICE: You must escape values in this argument with $this->fullQuoteStr() yourself!
string	$groupBy	Optional GROUP BY field(s), if none, supply blank string.
string	$orderBy	Optional ORDER BY field(s), if none, supply blank string.
boolean	$numIndex	If set, the result will be fetched with sql_fetch_row, otherwise sql_fetch_assoc will be used.

Returns: array|FALSE|NULL Single row, FALSE on empty result, NULL on error

Definition at line 405 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_assoc(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_row(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result().

◆ explain()

TYPO3\CMS\Core\Database\DatabaseConnection::explain	(	$query,
		$from_table,
		$row_count
	)

protected

Explain select queries If $this->explainOutput is set, SELECT queries will be explained here. Only queries with more than one possible result row will be displayed. The output is either printed as raw HTML output or embedded into the TS admin panel (checkbox must be enabled!)

TODO: Feature is not DBAL-compliant

Parameters

string	$query	SQL query
string	$from_table	Table(s) from which to select. This is what comes right after "FROM ...". Required value.
integer	$row_count	Number of resulting rows

Returns: boolean TRUE if explain was run, FALSE otherwise

Definition at line 1844 of file DatabaseConnection.php.

References $GLOBALS, TYPO3\CMS\Core\Utility\GeneralUtility\cmpIP(), TYPO3\CMS\Core\Utility\DebugUtility\debug(), TYPO3\CMS\Core\Utility\DebugUtility\debugTrail(), TYPO3\CMS\Core\Utility\GeneralUtility\getIndpEnv(), TYPO3\CMS\Core\Utility\GeneralUtility\inList(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_assoc(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_free_result(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_num_rows(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_query().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\initialize().

◆ fullQuoteArray()

TYPO3\CMS\Core\Database\DatabaseConnection::fullQuoteArray	(	$arr,
		$table,
		$noQuote = `FALSE`,
		$allowNull = `FALSE`
	)

Will fullquote all values in the one-dimensional array so they are ready to "implode" for an sql query.

Parameters

array	$arr	Array with values (either associative or non-associative array)
string	$table	Table name for which to quote
boolean \| array	$noQuote	List/array of keys NOT to quote (eg. SQL functions) - ONLY for associative arrays
boolean	$allowNull	Whether to allow NULL values

Returns: array The input array with the values quoted

See also: cleanIntArray()

Definition at line 830 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\fullQuoteStr().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\INSERTquery().

◆ fullQuoteStr()

TYPO3\CMS\Core\Database\DatabaseConnection::fullQuoteStr	(	$str,
		$table,
		$allowNull = `FALSE`
	)

Escaping and quoting values for SQL statements.

Parameters

string	$str	Input string
string	$table	Table name for which to quote string. Just enter the table that the field-value is selected from (and any DBAL will look up which handler to use and then how to quote the string!).
boolean	$allowNull	Whether to allow NULL values

Returns: string Output string; Wrapped in single quotes and quotes in the string (" / ') and \ will be backslashed (or otherwise based on DBAL handler)

See also: quoteStr()

Definition at line 809 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), and TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\fullQuoteArray().

◆ getDatabaseHandle()

TYPO3\CMS\Core\Database\DatabaseConnection::getDatabaseHandle ( )

Returns current database handle

Returns: |NULL

Definition at line 1714 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$link.

◆ getDateTimeFormats()

TYPO3\CMS\Core\Database\DatabaseConnection::getDateTimeFormats ( $table )

Returns the date and time formats compatible with the given database table.

Parameters

string $table Table name for which to return an empty date. Just enter the table that the field-value is selected from (and any DBAL will look up which handler to use and then how date and time should be formatted).

Returns: array

Definition at line 970 of file DatabaseConnection.php.

◆ handleDeprecatedConnectArguments()

TYPO3\CMS\Core\Database\DatabaseConnection::handleDeprecatedConnectArguments	(	$host = `NULL`,
		$username = `NULL`,
		$password = `NULL`,
		$db = `NULL`
	)

protected

Handle deprecated arguments for sql_pconnect() and connectDB()

Parameters

string \| null	$host	Database host[:port]
string \| null	$username	Database user name
string \| null	$password	User password
string \| null	$db	Database

Definition at line 1735 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$databaseHost, TYPO3\CMS\Core\Database\DatabaseConnection\$databasePort, $host, TYPO3\CMS\Core\Utility\GeneralUtility\deprecationLog(), TYPO3\CMS\Core\Database\DatabaseConnection\setDatabaseHost(), TYPO3\CMS\Core\Database\DatabaseConnection\setDatabaseName(), TYPO3\CMS\Core\Database\DatabaseConnection\setDatabasePassword(), TYPO3\CMS\Core\Database\DatabaseConnection\setDatabasePort(), and TYPO3\CMS\Core\Database\DatabaseConnection\setDatabaseUsername().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect(), and TYPO3\CMS\Dbal\Database\DatabaseConnection\sql_pconnect().

◆ initialize()

TYPO3\CMS\Core\Database\DatabaseConnection::initialize ( )

Initialize the database connection

Returns: void

Definition at line 189 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), TYPO3\CMS\Core\Database\DatabaseConnection\explain(), TYPO3\CMS\Core\Database\DatabaseConnection\INSERTquery(), and TYPO3\CMS\Core\Database\DatabaseConnection\query().

◆ INSERTquery()

TYPO3\CMS\Core\Database\DatabaseConnection::INSERTquery	(	$table,
		$fields_values,
		$no_quote_fields = `FALSE`
	)

Creates an INSERT SQL-statement for $table from the array with field/value pairs $fields_values.

Parameters

string	$table	See exec_INSERTquery()
array	$fields_values	See exec_INSERTquery()
bool \| array \| string	$no_quote_fields	See fullQuoteArray()

Returns: string|NULL Full SQL query for INSERT, NULL if $fields_values is empty

Definition at line 486 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\fullQuoteArray().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\initialize().

◆ isConnected()

TYPO3\CMS\Core\Database\DatabaseConnection::isConnected ( )

Checks if database is connected

Returns: boolean

Definition at line 1611 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$isConnected.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected(), TYPO3\CMS\Core\Database\DatabaseConnection\fullQuoteStr(), TYPO3\CMS\Core\Database\DatabaseConnection\prepare_PREPAREDquery(), TYPO3\CMS\Core\Database\DatabaseConnection\query(), TYPO3\CMS\Core\Database\DatabaseConnection\quoteStr(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect().

◆ listQuery()

TYPO3\CMS\Core\Database\DatabaseConnection::listQuery	(	$field,
		$value,
		$table
	)

Returns a WHERE clause that can find a value ($value) in a list field ($field) For instance a record in the database might contain a list of numbers, "34,234,5" (with no spaces between). This query would be able to select that record based on the value "34", "234" or "5" regardless of their position in the list (left, middle or right). The value must not contain a comma (,) Is nice to look up list-relations to records or files in TYPO3 database tables.

Parameters

string	$field	Field name
string	$value	Value to find in list
string	$table	Table in which we are searching (for DBAL detection of quoteStr() method)

Returns: string WHERE clause for a query

Exceptions

Definition at line 692 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\quoteStr().

◆ prepare_PREPAREDquery()

TYPO3\CMS\Dbal\Database\DatabaseConnection::prepare_PREPAREDquery	(		$query,
		array	$queryComponents
	)

Prepares a prepared query.

Parameters

string	$query	The query to execute
array	$queryComponents	The components of the query to execute

Returns: |object MySQLi statement / DBAL object

Prepares a prepared query.

Parameters

string	$query	The query to execute
array	$queryComponents	The components of the query to execute

Returns: boolean||

Exceptions

Definition at line 778 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), TYPO3\CMS\Core\Database\DatabaseConnection\debug(), and TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\precompileSELECTquery().

◆ prepare_SELECTqueryArray()

TYPO3\CMS\Core\Database\DatabaseConnection::prepare_SELECTqueryArray	(	array	$queryParts,
		array	$input_parameters = `array()`
	)

Creates a SELECT prepared SQL statement based on input query parts array

Parameters

array	$queryParts	Query parts array
array	$input_parameters	An array of values with as many elements as there are bound parameters in the SQL statement being executed. All values are treated as ::PARAM_AUTOTYPE.

Returns: Prepared statement

Definition at line 766 of file DatabaseConnection.php.

◆ query()

TYPO3\CMS\Core\Database\DatabaseConnection::query ( $query )

protected

Central query method. Also checks if there is a database connection. Use this to execute database queries instead of directly calling $this->link->query()

Parameters

string $query The query to send to the database

Returns: bool|

Definition at line 466 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), and TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

◆ quoteStr()

TYPO3\CMS\Core\Database\DatabaseConnection::quoteStr	(	$str,
		$table
	)

Substitution for PHP function "addslashes()" Use this function instead of the PHP addslashes() function when you build queries - this will prepare your code for DBAL. NOTICE: You must wrap the output of this function in SINGLE QUOTES to be DBAL compatible. Unless you have to apply the single quotes yourself you should rather use ->fullQuoteStr()!

Parameters

string	$str	Input string
string	$table	Table name for which to quote string. Just enter the table that the field-value is selected from (and any DBAL will look up which handler to use and then how to quote the string!).

Returns: string Output string; Quotes (" / ') and \ will be backslashed (or otherwise based on DBAL handler)

See also: quoteStr()

Definition at line 854 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\connectDB(), and TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\listQuery().

◆ searchQuery()

TYPO3\CMS\Core\Database\DatabaseConnection::searchQuery	(	$searchWords,
		$fields,
		$table,
		$constraint = `self::AND_Constraint`
	)

Returns a WHERE clause which will make an AND or OR search for the words in the $searchWords array in any of the fields in array $fields.

Parameters

array	$searchWords	Array of search words
array	$fields	Array of fields
string	$table	Table in which we are searching (for DBAL detection of quoteStr() method)
string	$constraint	How multiple search words have to match ('AND' or 'OR')

Returns: string WHERE clause for search

Definition at line 711 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Utility\GeneralUtility\makeInstance(), and TYPO3\CMS\Core\Database\PreparedStatement\PARAM_AUTOTYPE.

◆ SELECTsubquery()

TYPO3\CMS\Core\Database\DatabaseConnection::SELECTsubquery	(	$select_fields,
		$from_table,
		$where_clause
	)

Creates a SELECT SQL-statement to be used as subquery within another query. BEWARE: This method should not be overriden within DBAL to prevent quoting from happening.

Parameters

string	$select_fields	List of fields to select from the table.
string	$from_table	Table from which to select.
string	$where_clause	Conditional WHERE statement

Returns: string Full SQL query for SELECT

Definition at line 645 of file DatabaseConnection.php.

◆ setConnectionCharset()

TYPO3\CMS\Core\Database\DatabaseConnection::setConnectionCharset ( $connectionCharset = 'utf8' )

Set the charset that should be used for the MySQL connection. The given value will be passed on to mysqli_set_charset().

The default value of this setting is utf8.

Parameters

string $connectionCharset The connection charset that will be passed on to mysqli_set_charset() when connecting the database. Default is utf8.

Returns: void

Definition at line 1534 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$connectionCharset, and TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ setConnectionCompression()

TYPO3\CMS\Core\Database\DatabaseConnection::setConnectionCompression ( $connectionCompression )

Set connection compression. Might be an advantage, if SQL server is not on localhost

Parameters

bool $connectionCompression TRUE if connection should be compressed

Definition at line 1510 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$connectionCompression, and TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ setDatabaseHandle()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabaseHandle ( $handle )

Set current database handle, usually

Parameters

\mysqli $handle

Definition at line 1723 of file DatabaseConnection.php.

◆ setDatabaseHost()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabaseHost ( $host = 'localhost' )

Set database host

Parameters

string $host

Definition at line 1439 of file DatabaseConnection.php.

References $host, and TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ setDatabaseName()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabaseName ( $name )

Set database name

Parameters

string $name

Definition at line 1469 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\admin_get_dbs(), and TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ setDatabasePassword()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabasePassword ( $password )

Set database password

Parameters

string $password

Definition at line 1489 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ setDatabasePort()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabasePort ( $port = 3306 )

Set database port

Parameters

integer $port

Definition at line 1449 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ setDatabaseSocket()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabaseSocket ( $socket = NULL )

Set database socket

Parameters

string | NULL $socket

Definition at line 1459 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ setDatabaseUsername()

TYPO3\CMS\Core\Database\DatabaseConnection::setDatabaseUsername ( $username )

Set database username

Parameters

string $username

Definition at line 1479 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ setInitializeCommandsAfterConnect()

TYPO3\CMS\Core\Database\DatabaseConnection::setInitializeCommandsAfterConnect ( array $commands )

Set commands to be fired after connection was established

Parameters

array $commands List of SQL commands to be executed after connect

Definition at line 1520 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ setPersistentDatabaseConnection()

TYPO3\CMS\Core\Database\DatabaseConnection::setPersistentDatabaseConnection ( $persistentDatabaseConnection )

Set persistent database connection

Parameters

boolean $persistentDatabaseConnection

See also: http://php.net/manual/de/mysqli.persistconns.php

Definition at line 1500 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$persistentDatabaseConnection, and TYPO3\CMS\Core\Database\DatabaseConnection\disconnectIfConnected().

◆ setSqlMode()

TYPO3\CMS\Core\Database\DatabaseConnection::setSqlMode ( )

protected

Fixes the SQL mode by unsetting NO_BACKSLASH_ESCAPES if found.

Returns: void

Definition at line 1241 of file DatabaseConnection.php.

References $result, TYPO3\CMS\Core\Database\DatabaseConnection\sql_fetch_row(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_query(), and TYPO3\CMS\Core\Utility\GeneralUtility\trimExplode().

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect().

◆ splitGroupOrderLimit()

TYPO3\CMS\Core\Database\DatabaseConnection::splitGroupOrderLimit ( $str )

Takes the last part of a query, eg. "... uid=123 GROUP BY title ORDER BY title LIMIT 5,2" and splits each part into a table (WHERE, GROUPBY, ORDERBY, LIMIT) Work-around function for use where you know some userdefined end to an SQL clause is supplied and you need to separate these factors.

Parameters

string $str Input string

Returns: array

Definition at line 930 of file DatabaseConnection.php.

◆ sql_affected_rows()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_affected_rows ( )

Returns the number of rows affected by the last INSERT, UPDATE or DELETE query

Returns: integer Number of rows affected by last query

Definition at line 1100 of file DatabaseConnection.php.

◆ sql_data_seek()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_data_seek	(	$res,
		$seek
	)

Move internal result pointer

Parameters

boolean \| \mysqli_result \| object	$res	MySQLi result object / DBAL object
integer	$seek	Seek result number.

Returns: boolean Returns TRUE on success or FALSE on failure.

Definition at line 1111 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

◆ sql_errno()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_errno ( )

Returns the error number on the last query() execution

Returns: integer MySQLi error number

Definition at line 1011 of file DatabaseConnection.php.

◆ sql_error()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_error ( )

Returns the error status on the last query() execution

Returns: string MySQLi error string.

Definition at line 1002 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\admin_get_dbs(), TYPO3\CMS\Core\Database\DatabaseConnection\checkConnectionCharset(), TYPO3\CMS\Core\Database\DatabaseConnection\debug(), TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetRows(), TYPO3\CMS\Core\Database\DatabaseConnection\explain(), TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_select_db().

◆ sql_fetch_assoc()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_fetch_assoc ( $res )

Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows. MySQLi fetch_assoc() wrapper function

Parameters

boolean | \mysqli_result | object $res MySQLi result object / DBAL object

Returns: array|boolean Associative array of result row.

Definition at line 1036 of file DatabaseConnection.php.

References $result, and TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetRows(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetSingleRow(), and TYPO3\CMS\Core\Database\DatabaseConnection\explain().

◆ sql_fetch_row()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_fetch_row ( $res )

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows. The array contains the values in numerical indices. MySQLi fetch_row() wrapper function

Parameters

boolean | \mysqli_result | object $res MySQLi result object / DBAL object

Returns: array|boolean Array with result rows.

Definition at line 1057 of file DatabaseConnection.php.

References $result, and TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\checkConnectionCharset(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTcountRows(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetSingleRow(), and TYPO3\CMS\Core\Database\DatabaseConnection\setSqlMode().

◆ sql_field_type()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_field_type	(	$res,
		$pointer
	)

Get the type of the specified field in a result mysql_field_type() wrapper function

Parameters

boolean \| \mysqli_result \| object	$res	MySQLi result object / DBAL object
integer	$pointer	Field index.

Returns: string Returns the name of the specified field index, or FALSE on error

Definition at line 1127 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

◆ sql_free_result()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_free_result ( $res )

Free result memory free_result() wrapper function

Parameters

boolean | \mysqli_result | object $res MySQLi result object / DBAL object

Returns: boolean Returns TRUE on success or FALSE on failure.

Definition at line 1077 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\checkConnectionCharset(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTcountRows(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetRows(), TYPO3\CMS\Core\Database\DatabaseConnection\exec_SELECTgetSingleRow(), and TYPO3\CMS\Core\Database\DatabaseConnection\explain().

◆ sql_insert_id()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_insert_id ( )

Get the ID generated from the previous INSERT operation

Returns: integer The uid of the last inserted record.

Definition at line 1091 of file DatabaseConnection.php.

◆ sql_num_rows()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_num_rows ( $res )

Returns the number of selected rows.

Parameters

boolean | \mysqli_result | object $res MySQLi result object / DBAL object

Returns: integer Number of resulting rows

Definition at line 1021 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug_check_recordset().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\explain().

◆ sql_pconnect()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_pconnect	(	$host = `NULL`,
		$username = `NULL`,
		$password = `NULL`
	)

Open a (persistent) connection to a MySQL server

Parameters

string	$host	Deprecated since 6.1, will be removed in two versions. Database host IP/domain[:port]
string	$username	Deprecated since 6.1, will be removed in two versions. Username to connect with.
string	$password	Deprecated since 6.1, will be removed in two versions. Password to connect with.

Returns: boolean|void

Exceptions

Definition at line 1170 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\connectDB().

◆ sql_query()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_query ( $query )

Executes query MySQLi query() wrapper function Beware: Use of this method should be avoided as it is experimentally supported by DBAL. You should consider using exec_SELECTquery() and similar methods instead.

Parameters

string $query Query to execute

Returns: boolean||object MySQLi result object / DBAL object

Definition at line 989 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\debug(), and TYPO3\CMS\Core\Database\DatabaseConnection\query().

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\checkConnectionCharset(), TYPO3\CMS\Core\Database\DatabaseConnection\explain(), and TYPO3\CMS\Core\Database\DatabaseConnection\setSqlMode().

◆ sql_select_db()

TYPO3\CMS\Core\Database\DatabaseConnection::sql_select_db ( $TYPO3_db = NULL )

Select a SQL database

Parameters

string $TYPO3_db Deprecated since 6.1, will be removed in two versions. Database to connect to.

Returns: boolean Returns TRUE on success or FALSE on failure.

Definition at line 1264 of file DatabaseConnection.php.

References TYPO3\CMS\Core\Database\DatabaseConnection\$databaseName, TYPO3\CMS\Core\Database\DatabaseConnection\sql_error(), and TYPO3\CMS\Core\Utility\GeneralUtility\SYSLOG_SEVERITY_FATAL.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\admin_get_dbs(), and TYPO3\CMS\Core\Database\DatabaseConnection\connectDB().

◆ stripGroupBy()

TYPO3\CMS\Core\Database\DatabaseConnection::stripGroupBy ( $str )

Removes the prefix "GROUP BY" from the input string. This function is used when you call the SELECTquery() function and want to pass the GROUP BY parameter by can't guarantee that "GROUP BY" is not prefixed. Generally; This function provides a work-around to the situation where you cannot pass only the fields by which to order the result.

Parameters

string $str eg. "GROUP BY title, uid @return string eg. "title, uid

See also: exec_SELECTquery(), stripOrderBy()

Definition at line 919 of file DatabaseConnection.php.

◆ stripOrderBy()

TYPO3\CMS\Core\Database\DatabaseConnection::stripOrderBy ( $str )

Removes the prefix "ORDER BY" from the input string. This function is used when you call the exec_SELECTquery() function and want to pass the ORDER BY parameter by can't guarantee that "ORDER BY" is not prefixed. Generally; This function provides a work-around to the situation where you cannot pass only the fields by which to order the result.

Parameters

string $str eg. "ORDER BY title, uid @return string eg. "title, uid

See also: exec_SELECTquery(), stripGroupBy()

Definition at line 906 of file DatabaseConnection.php.

Member Data Documentation

◆ $connectionCharset

TYPO3\CMS\Core\Database\DatabaseConnection::$connectionCharset = 'utf8'

protected

Definition at line 134 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\setConnectionCharset().

◆ $connectionCompression

TYPO3\CMS\Core\Database\DatabaseConnection::$connectionCompression = FALSE

protected

Definition at line 126 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\setConnectionCompression().

◆ $databaseHost

TYPO3\CMS\Core\Database\DatabaseConnection::$databaseHost = ''

protected

Definition at line 90 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments(), TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect().

◆ $databaseName

TYPO3\CMS\Core\Database\DatabaseConnection::$databaseName = ''

protected

Definition at line 105 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_select_db().

◆ $databasePort

TYPO3\CMS\Core\Database\DatabaseConnection::$databasePort = 3306

protected

Definition at line 95 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\handleDeprecatedConnectArguments().

◆ $databaseSocket

TYPO3\CMS\Core\Database\DatabaseConnection::$databaseSocket = NULL

protected

Definition at line 100 of file DatabaseConnection.php.

◆ $databaseUsername

TYPO3\CMS\Core\Database\DatabaseConnection::$databaseUsername = ''

protected

Definition at line 110 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init().

◆ $databaseUserPassword

TYPO3\CMS\Core\Database\DatabaseConnection::$databaseUserPassword = ''

protected

Definition at line 115 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init().

◆ $dateTimeFormats

TYPO3\CMS\Core\Database\DatabaseConnection::$dateTimeFormats

staticprotected

Initial value:

= array(
        'date' => array(
            'empty' => '0000-00-00',
            'format' => 'Y-m-d'
        ),
        'datetime' => array(
            'empty' => '0000-00-00 00:00:00',
            'format' => 'Y-m-d H:i:s'
        )
    )

Definition at line 173 of file DatabaseConnection.php.

◆ $debug_lastBuiltQuery

TYPO3\CMS\Core\Database\DatabaseConnection::$debug_lastBuiltQuery = ''

Todo:: Define visibility

Definition at line 72 of file DatabaseConnection.php.

◆ $debugOutput

TYPO3\CMS\Core\Database\DatabaseConnection::$debugOutput = FALSE

Todo:: Define visibility

Definition at line 66 of file DatabaseConnection.php.

◆ $default_charset

TYPO3\CMS\Core\Database\DatabaseConnection::$default_charset = 'utf8'

Todo:: Define visibility

Definition at line 155 of file DatabaseConnection.php.

◆ $explainOutput

TYPO3\CMS\Core\Database\DatabaseConnection::$explainOutput = 0

Todo:: Define visibility

Definition at line 85 of file DatabaseConnection.php.

◆ $initializeCommandsAfterConnect

TYPO3\CMS\Core\Database\DatabaseConnection::$initializeCommandsAfterConnect = array()

protected

Definition at line 139 of file DatabaseConnection.php.

◆ $isConnected

TYPO3\CMS\Core\Database\DatabaseConnection::$isConnected = FALSE

protected

Definition at line 144 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\isConnected().

◆ $link

TYPO3\CMS\Core\Database\DatabaseConnection::$link = NULL

protected

Definition at line 149 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\getDatabaseHandle(), TYPO3\CMS\Dbal\Database\DatabaseConnection\handler_init(), and TYPO3\CMS\Core\Database\DatabaseConnection\sql_pconnect().

◆ $persistentDatabaseConnection

TYPO3\CMS\Core\Database\DatabaseConnection::$persistentDatabaseConnection = FALSE

protected

Definition at line 121 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Core\Database\DatabaseConnection\setPersistentDatabaseConnection().

◆ $postProcessHookObjects

TYPO3\CMS\Core\Database\DatabaseConnection::$postProcessHookObjects = array()

protected

Definition at line 165 of file DatabaseConnection.php.

◆ $preProcessHookObjects

TYPO3\CMS\Core\Database\DatabaseConnection::$preProcessHookObjects = array()

protected

Definition at line 160 of file DatabaseConnection.php.

◆ $store_lastBuiltQuery

TYPO3\CMS\Core\Database\DatabaseConnection::$store_lastBuiltQuery = FALSE

Todo:: Define visibility

Definition at line 78 of file DatabaseConnection.php.

Referenced by TYPO3\CMS\Dbal\Database\DatabaseConnection\UPDATEquery().

◆ AND_Constraint

const TYPO3\CMS\Core\Database\DatabaseConnection::AND_Constraint = 'AND'

Definition at line 53 of file DatabaseConnection.php.

◆ OR_Constraint

const TYPO3\CMS\Core\Database\DatabaseConnection::OR_Constraint = 'OR'

Definition at line 60 of file DatabaseConnection.php.

Public Member Functions

Public Attributes

Protected Member Functions

Protected Attributes

Static Protected Attributes

Detailed Description

Member Function Documentation

◆ __sleep()

◆ admin_get_charsets()

◆ admin_get_dbs()

◆ admin_get_fields()

◆ admin_get_keys()

◆ admin_get_tables()

◆ admin_query()

◆ checkConnectionCharset()

◆ cleanIntArray()

◆ cleanIntList()

◆ connectDB()

◆ debug()

◆ debug_check_recordset()

◆ disconnectIfConnected()

◆ escapeStrForLike()

◆ exec_SELECT_mm_query()

◆ exec_SELECT_queryArray()

◆ exec_SELECTcountRows()

◆ exec_SELECTgetRows()

◆ exec_SELECTgetSingleRow()

◆ explain()

◆ fullQuoteArray()

◆ fullQuoteStr()

◆ getDatabaseHandle()

◆ getDateTimeFormats()

◆ handleDeprecatedConnectArguments()

◆ initialize()

◆ INSERTquery()

◆ isConnected()

◆ listQuery()

◆ prepare_PREPAREDquery()

◆ prepare_SELECTqueryArray()

◆ query()

◆ quoteStr()

◆ searchQuery()

◆ SELECTsubquery()

◆ setConnectionCharset()

◆ setConnectionCompression()

◆ setDatabaseHandle()

◆ setDatabaseHost()

◆ setDatabaseName()

◆ setDatabasePassword()

◆ setDatabasePort()

◆ setDatabaseSocket()

◆ setDatabaseUsername()

◆ setInitializeCommandsAfterConnect()

◆ setPersistentDatabaseConnection()

◆ setSqlMode()

◆ splitGroupOrderLimit()

◆ sql_affected_rows()

◆ sql_data_seek()

◆ sql_errno()

◆ sql_error()

◆ sql_fetch_assoc()

◆ sql_fetch_row()

◆ sql_field_type()

◆ sql_free_result()

◆ sql_insert_id()

◆ sql_num_rows()

◆ sql_pconnect()

◆ sql_query()

◆ sql_select_db()

◆ stripGroupBy()

◆ stripOrderBy()

Member Data Documentation

◆ $connectionCharset

◆ $connectionCompression

◆ $databaseHost

◆ $databaseName

◆ $databasePort

◆ $databaseSocket

◆ $databaseUsername

◆ $databaseUserPassword