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

User Contributed Notes

1. Skip to note 2 content

   Saroar Hossain 6 years ago

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