WordPress.org
Get WordPress
WordPress.org

WordPress Developer Resources

wpdb::get_blog_prefix()

wpdb::get_blog_prefix( int $blog_id = null ): string

In this article

Back to top

Gets blog prefix.

Parameters

$blog_idintoptional
Blog ID to retrieve the table prefix for.
Defaults to the current blog ID.

Default:null

Return

string Blog prefix.

Source

public function get_blog_prefix( $blog_id = null ) {	if ( is_multisite() ) {	if ( null === $blog_id ) {	$blog_id = $this->blogid;	}	$blog_id = (int) $blog_id;	if ( defined( 'MULTISITE' ) && ( 0 === $blog_id || 1 === $blog_id ) ) {	return $this->base_prefix;	} else {	return $this->base_prefix . $blog_id . '_';	}	} else {	return $this->base_prefix;	} }

View all references View on Trac View on GitHub

UsesDescription
is_multisite()wp-includes/load.php

Determines whether Multisite is enabled.

Used byDescription
wp_register_persisted_preferences_meta()wp-includes/user.php

Registers the user meta property for persisted preferences.

wp_initialize_site()wp-includes/ms-site.php

Runs the initialization routine for a given site.

wp_default_packages_inline_scripts()wp-includes/script-loader.php

Adds inline scripts required for the WordPress JavaScript packages.

WP_User::for_site()wp-includes/class-wp-user.php

Sets the site to operate on. Defaults to the current site.

WP_Roles::for_site()wp-includes/class-wp-roles.php

Sets the site to operate on. Defaults to the current site.

wp_get_users_with_no_role()wp-includes/user.php

Gets the user IDs of all users with no role on this site.

get_author_user_ids()wp-admin/includes/deprecated.php

Get all user IDs.

get_editable_user_ids()wp-admin/includes/deprecated.php

Gets the IDs of any users who can edit posts.

get_nonauthor_user_ids()wp-admin/includes/deprecated.php

Gets all users who are not authors.

WP_User::update_user_level_from_caps()wp-includes/class-wp-user.php

Updates the maximum user level for the user.

WP_User::remove_all_caps()wp-includes/class-wp-user.php

Removes all of the capabilities of the user.

WP_User::_init_caps()wp-includes/class-wp-user.php

Sets up capability object properties.

get_users_of_blog()wp-includes/deprecated.php

Get users for the site.

WP_User_Query::prepare_query()wp-includes/class-wp-user-query.php

Prepares the query variables.

update_user_option()wp-includes/user.php

Updates user option with global blog capability.

delete_user_option()wp-includes/user.php

Deletes user option with global blog capability.

count_users()wp-includes/user.php

Counts number of users who have each of the user roles.

get_user_option()wp-includes/user.php

Retrieves user option that can be either per Site or per Network.

is_user_option_local()wp-includes/ms-deprecated.php

Check whether a usermeta key has to do with the current blog.

get_most_recent_post_of_user()wp-includes/ms-functions.php

Gets a user’s most recent post.

install_blog()wp-includes/ms-deprecated.php

Install an empty blog.

wpmu_validate_blog_signup()wp-includes/ms-functions.php

Processes new site registrations.

get_blog_list()wp-includes/ms-deprecated.php

Deprecated functionality to retrieve a list of all sites.

switch_to_blog()wp-includes/ms-blogs.php

Switches the current blog.

restore_current_blog()wp-includes/ms-blogs.php

Restores the current blog, after calling switch_to_blog() .

wpdb::tables()wp-includes/class-wpdb.php

Returns an array of WordPress tables.

wpdb::set_prefix()wp-includes/class-wpdb.php

Sets the table prefix for the WordPress tables.

wpdb::set_blog_id()wp-includes/class-wpdb.php

Sets blog ID.

Show 23 moreShow less

Changelog

VersionDescription
3.0.0Introduced.

User Contributed Notes

  1. Skip to note 2 content
    shossain571
    You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note

    Create a table while installing the plugin. Get the database table prefix with $wpdb::get_blog_prefix();

    register_activation_hook( __FILE__, 'myplugin_activation' ); function myplugin_activation() {	// Get access to global database access class	global $wpdb;	// Create table on main blog in network mode or single blog	myplugin_create_table( $wpdb->get_blog_prefix() ); } function myplugin_create_table( $prefix ) {	// Prepare SQL query to create database table	// using function parameter	$creation_query =	'CREATE TABLE IF NOT EXISTS ' . $prefix . 'myplugin_bug_data (	`bug_id` int(20) NOT NULL AUTO_INCREMENT,	`bug_description` text,	`bug_version` varchar(10) DEFAULT NULL,	`bug_report_date` date DEFAULT NULL,	`bug_status` int(3) NOT NULL DEFAULT 0,	PRIMARY KEY (`bug_id`)	);';	global $wpdb;	$wpdb->query( $creation_query ); }

You must log in before being able to contribute a note or feedback.