Wordpress Plugin Creating Database Tables

Question

I am currently working on a plugin for personal use, but I just can't get the plugin to create a table, I try activation the plugin but it doesn't create a table here is my code:

team-monobattle-registraion.php:

<?php
/*
Plugin Name: Team Monobattle Registration
Plugin URI: http://www.web-geeks.com/
Description: Plugin for registering teams for monobattles.
Author: Web-geeks
Version: 1.0
Author URI: http://www.web-geeks.com/
*/

function tmbr_admin() {
    include('team-monobattle-admin.php');
}

function tmbr_admin_actions() {
    add_options_page('Team Monobattle Registration', 'Team Monobattle Registration', 'manage_options', 'tmbr', 'tmbr_admin');
}

add_action('admin_menu', 'tmbr_admin_actions');

include('team-monobattle-database.php');

register_activation_hook(__FILE__, 'tmbr_install');
?>

team-monobattle-database.php:

<?php

global $tmbr_db_table_version;
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
$tmbr_db_table_version = "1.0";
global $wpdb;

function tmbr_install()
{

    global $tmbr_db_table_version;
    $installed_ver = get_option( "tmbr_db_table_version" );

    if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != 'wp_teammonobattleteams' ||  $installed_ver != $tmbr_db_table_version ) {

    $sql = "CREATE TABLE wp_teammonobattleteams (
    teamid mediumint(9) NOT NULL AUTO_INCREMENT,
    teamname tinytext NOT NULL,
    pname1 tinytext NOT NULL,
    pid1 smallint NOT NULL,
    pname2 tinytext NOT NULL,
    pid2 smallint NOT NULL,
    pname3 tinytext NOT NULL,
    pid3 smallint NOT NULL,
    pname4 tinytext NOT NULL,
    pid4 smallint NOT NULL,
    UNIQUE KEY id (id)
    );";

    dbDelta($sql);

    echo('installed');
    }

}
?>

team-monobattle-admin.php:

<div class="wrap">
<?php    echo "<h2>" . __( 'Team Monobattle Admin', 'tmbr_admin' ) . "</h2>"; ?>
</div>

Help appreciated.

Any error messages? Can you read tables?

mrtsherman
– mrtsherman

2011-07-18 22:36:20 +00:00
Commented Jul 18, 2011 at 22:36 — mrtsherman
– mrtsherman, Commented Jul 18, 2011 at 22:36

Alexcp · Accepted Answer · 2011-07-19 13:55:37Z

1

The variables have to be inside your function.

answered Jul 19, 2011 at 13:55

Alexcp

3331 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

techy Over a year ago

Thanks! I got it all figured out! :)

user3094069 · Accepted Answer · 2014-06-21 06:35:23Z

0

" CREATE TABLE " is not safe to use. Because if the table already exist it will be a error in your mysql query. also which reports un avoidable error. So try to use " CREATE TABLE IF NOT EXISTS" . That's good practice.

If you have any problem in table creation read some online tutorials and create one. Here is a link for your reference.

http://kvcodes.com/2014/06/how-to-create-table-in-wordpress-database/

answered Jun 21, 2014 at 6:35

user3094069

Collectives™ on Stack Overflow

Wordpress Plugin Creating Database Tables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related