You are here

public function DatabaseConnection::prefixTables in Drupal 7

Appends a database prefix to all tables in a query.

Queries sent to Drupal should wrap all table names in curly brackets. This function searches for this syntax and adds Drupal's table prefix to all tables, allowing Drupal to coexist with other systems in the same database and/or schema if necessary.

Parameters

$sql: A string containing a partial or entire SQL query.

Return value

The properly-prefixed string.

3 calls to DatabaseConnection::prefixTables()
DatabaseConnection::makeSequenceName in includes/database/database.inc
Creates the appropriate sequence name for a given table and serial field.
DatabaseConnection::prepareQuery in includes/database/database.inc
Prepares a query string and returns the prepared statement.
DatabaseConnection_sqlite::prepareQuery in includes/database/sqlite/database.inc
Prepares a query string and returns the prepared statement.

File

includes/database/database.inc, line 497
Core systems for the database layer.

Class

DatabaseConnection
Base Database API class.

Code

public function prefixTables($sql) {
  return str_replace($this->prefixSearch, $this->prefixReplace, $sql);
}