wpdb::tables() WordPress Method

The wpdb::tables() method is used to get a list of all the tables in a WordPress database. This is useful for making sure that all the tables are created correctly when installing or upgrading WordPress.

wpdb::tables( string $scope = 'all', bool $prefix = true, int $blog_id ) #

Returns an array of WordPress tables.


Description

Also allows for the CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE to override the WordPress users and usermeta tables that would otherwise be determined by the prefix.

The $scope argument can take one of the following:

  • ‘all’ – returns ‘all’ and ‘global’ tables. No old tables are returned.
  • ‘blog’ – returns the blog-level tables for the queried blog.
  • ‘global’ – returns the global tables for the installation, returning multisite tables only on multisite.
  • ‘ms_global’ – returns the multisite global tables, regardless if current installation is multisite.
  • ‘old’ – returns tables which are deprecated.

Top ↑

Parameters

$scope

(string)(Optional) Possible values include 'all', 'global', 'ms_global', 'blog', or 'old' tables.

Default value: 'all'

$prefix

(bool)(Optional) Whether to include table prefixes. If blog prefix is requested, then the custom users and usermeta tables will be mapped.

Default value: true

$blog_id

(int)(Optional) The blog_id to prefix. Used only when prefix is requested. Defaults to wpdb::$blogid.


Top ↑

Return

(string[]) Table names. When a prefix is requested, the key is the unprefixed table name.


Top ↑

Source

File: wp-includes/wp-db.php

	public function tables( $scope = 'all', $prefix = true, $blog_id = 0 ) {
		switch ( $scope ) {
			case 'all':
				$tables = array_merge( $this->global_tables, $this->tables );
				if ( is_multisite() ) {
					$tables = array_merge( $tables, $this->ms_global_tables );
				}
				break;
			case 'blog':
				$tables = $this->tables;
				break;
			case 'global':
				$tables = $this->global_tables;
				if ( is_multisite() ) {
					$tables = array_merge( $tables, $this->ms_global_tables );
				}
				break;
			case 'ms_global':
				$tables = $this->ms_global_tables;
				break;
			case 'old':
				$tables = $this->old_tables;
				break;
			default:
				return array();
		}

		if ( $prefix ) {
			if ( ! $blog_id ) {
				$blog_id = $this->blogid;
			}
			$blog_prefix   = $this->get_blog_prefix( $blog_id );
			$base_prefix   = $this->base_prefix;
			$global_tables = array_merge( $this->global_tables, $this->ms_global_tables );
			foreach ( $tables as $k => $table ) {
				if ( in_array( $table, $global_tables, true ) ) {
					$tables[ $table ] = $base_prefix . $table;
				} else {
					$tables[ $table ] = $blog_prefix . $table;
				}
				unset( $tables[ $k ] );
			}

			if ( isset( $tables['users'] ) && defined( 'CUSTOM_USER_TABLE' ) ) {
				$tables['users'] = CUSTOM_USER_TABLE;
			}

			if ( isset( $tables['usermeta'] ) && defined( 'CUSTOM_USER_META_TABLE' ) ) {
				$tables['usermeta'] = CUSTOM_USER_META_TABLE;
			}
		}

		return $tables;
	}


Top ↑

Changelog

Changelog
VersionDescription
3.0.0Introduced.

The content displayed on this page has been created in part by processing WordPress source code files which are made available under the GPLv2 (or a later version) license by theĀ Free Software Foundation. In addition to this, the content includes user-written examples and information. All material is subject to review and curation by the WPPaste.com community.