wpdb::set_prefix() WordPress Method
The wpdb::set_prefix() method allows you to set a new table prefix for WordPress tables. This is useful if you need to run multiple WordPress installations in a single database.
wpdb::set_prefix( string $prefix, bool $set_table_names = true ) #
Sets the table prefix for the WordPress tables.
Parameters
- $prefix
(string)(Required)Alphanumeric name for the new prefix.
- $set_table_names
(bool)(Optional) Whether the table names, e.g. wpdb::$posts, should be updated or not.
Default value: true
Return
Source
File: wp-includes/wp-db.php
public function set_prefix( $prefix, $set_table_names = true ) {
if ( preg_match( '|[^a-z0-9_]|i', $prefix ) ) {
return new WP_Error( 'invalid_db_prefix', 'Invalid database prefix' );
}
$old_prefix = is_multisite() ? '' : $prefix;
if ( isset( $this->base_prefix ) ) {
$old_prefix = $this->base_prefix;
}
$this->base_prefix = $prefix;
if ( $set_table_names ) {
foreach ( $this->tables( 'global' ) as $table => $prefixed_table ) {
$this->$table = $prefixed_table;
}
if ( is_multisite() && empty( $this->blogid ) ) {
return $old_prefix;
}
$this->prefix = $this->get_blog_prefix();
foreach ( $this->tables( 'blog' ) as $table => $prefixed_table ) {
$this->$table = $prefixed_table;
}
foreach ( $this->tables( 'old' ) as $table => $prefixed_table ) {
$this->$table = $prefixed_table;
}
}
return $old_prefix;
}
Expand full source codeCollapse full source codeView on TracView on GitHub
Changelog
| Version | Description |
|---|---|
| 2.5.0 | Introduced. |