wpdb::get_blog_prefix( int $blog_id = null )

Gets blog prefix.


Description Description


Parameters Parameters

$blog_id

(int) (Optional)

Default value: null


Top ↑

Return Return

(string) Blog prefix.


Top ↑

Source Source

File: wp-includes/wp-db.php

	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;
		}
	}

Top ↑

Changelog Changelog

Changelog
Version Description
3.0.0 Introduced.


Top ↑

User Contributed Notes User Contributed Notes

  1. Skip to note 1 content
    Contributed by shossain571

    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.