Home › API reference › database.inc › DatabaseConnection

DatabaseConnection::prefixTables

  1. drupal
    1. 7
Versions
7 public DatabaseConnection::prefixTables($sql)

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.

Code

drupal/includes/database/database.inc, line 411

<?php
public function prefixTables($sql) {
  // Replace specific table prefixes first.
  foreach ($this->prefixes as $key => $val) {
    $sql = strtr($sql, array('{' . $key . '}' => $val . $key));
  }
  // Then replace remaining tables with the default prefix.
  return strtr($sql, array('{' => $this->defaultPrefix, '}' => ''));
}
?>