WordPress.org

1. Yaeko
   Member
   Posted 1 year ago #

   Hi,

   I'm creating my first WordPress plugin and I'm already hitting a problem. I need to create a table when activating my plugin, but it doesn't work. here's my code:

   <?php
   /*
    * Plugin Name: plugin name
    * Description: bla bla bla
    * Version: 1.0
    * Author: Author
    */
   
   register_activation_hook(__FILE__, 'flashplayer_install');
   
   function flashplayer_install(){
   
       global $wpdb;
   
       $tbl_name = $wpdb->prefix.'flashplayer';
   
       if( $wpdb->get_var("show tables like '$tbl_name'") != $tbl_name ){
   
           $sql = "CREATE TABLE ".$tbl_name." (
                       id INT(10) NOT NULL AUTO INCREMENT,
                       title TINYTEXT NOT NULL,
                       filename VARCHAR(100) NOT NULL,
                       UNIQUE KEY id(id)
                   );";
           require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
           dbDelta($sql);
   
       }
   
   }
   
   ?>

   What Am I doing wrong here?

2. vjmayr
   Member
   Posted 1 year ago #

   Sorry, you probably fixed this long time ago ...

   I guess it's the missing empty space after 'prefix'. make it

   $tbl_name = $wpdb->prefix .'flashplayer';

Topic Closed

This topic has been closed to new replies.