why creating tables using $wpdb is not being executed while installing plugins?

Try using a different method. WordPress fires a hook during plugin activation activate_yourplugin/filename.php. You can use this to create tables.

function creating_order_tables() {

    if(!get_option('tables_created', false)) {

        global $wpdb;

        $ptbd_table_name = $wpdb->prefix . 'printtextbd_order';

        if ($wpdb->get_var("SHOW TABLES LIKE '". $ptbd_table_name ."'"  ) != $ptbd_table_name ) {

            $sql="CREATE TABLE exone(
            customer_id INT(20) AUTO_INCREMENT,
            customer_name VARCHAR(255),
            order_type VARCHAR(255),
            choosen_template VARCHAR(255),
            order_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY(customer_id))";

            if(!function_exists('dbDelta')) {
                require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
            }

            dbDelta($sql);
            echo "Tables created...";
            update_option('tables_created', true);
        }
    }
}
add_action('activate_yourplugin/yourplugin.php', 'creating_order_tables');

Related Posts:

  1. WordPress plugin tables become corrupt
  2. Should I use wpdb prepare?
  3. Is it mandatory to use $wpdb->prefix in custom tables
  4. How to redirect to settings page once the plugin is activated?
  5. How to output message during plugin activation
  6. Prevent network activation of plugin
  7. Inserting Taxonomy Terms During a Plugin Activation?
  8. $wpdb->insert_id
  9. Check for success of $wpdb->update() correctly
  10. WordPress and multithreading
  11. Using wp_cron with custom time interval and the register activation hook
  12. $wpdb->insert is changing a value
  13. Actions or filters fired when data is saved in a custom table
  14. Retrieving custom fields with $wpdb->get_results
  15. Call activation hook multiple times
  16. Only allow plugin to be activated on root site of multisite
  17. Really simple query giving error in SQL syntax
  18. Custom Plugin Database relations
  19. How to use mysql IN statement with wpdb update method?
  20. Override pluggable functions in a plugin?
  21. Plugin activation error due to unexpected output
  22. Using $wpdb object in a widget
  23. Activation hook not creating table
  24. $wpdb -> Batch insert from XML File?
  25. Settings not set after calling register_setting()
  26. How to Download and install plugin database remotely
  27. How to insert data to a database table when the field is not yet created?
  28. Where to store the name of a custom table?
  29. include wp-blog-header not working on MAMP
  30. creating custom function to log actions in plugin
  31. SQL query for custom taxonomy slugs
  32. Insert terms for custom taxonomy on plugin activation, or each page load (init hook)
  33. Issue regarding $wpdb->prepare()
  34. Error on inserting a form value to database
  35. How to create database table, add data, update and delete using wpdb via plugins?
  36. Using WPDB to output raw XML fails because of wp-blog-header.php
  37. how to search users by ajax live search
  38. Adding custom end points, No error line
  39. Intermittent database errors when accessing WordPress database
  40. Storing data in wordpress database from ajax call from different website
  41. wpdb->prepare and mysql UPDATE – how is it done?
  42. Add Link Category on Activation?
  43. WordPress Plugin Activate / Deactive Failing
  44. $wpdb->prepare with LIKE and sprintf
  45. How to optimize multiple insert into wordpress database
  46. $wpdb->update() always need a second try
  47. Multiple array for post_content on plugin activation
  48. Class cannot be found, but it’s available in the file, I get: Fatal Error: Uncaught Error: Class ‘Blocks\Base\Activation’ not found
  49. Data inserted by wpdb insert is different than data pressnt in database.
  50. Proper Prepare Statement for ALTER TABLE and using AFTER
  51. $wpdb->prepare is not working like mysql_real_escape_string
  52. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  53. Plugin can’t be activated [closed]
  54. Clean way to initialize plugin in newly-added site when plugin has been network activated?
  55. Activate / Deactivate plugin
  56. $wpdb in php 5.5
  57. Plugin to create Posts and Forums then choose category and parent forum
  58. $wpdb->update Issue
  59. How to relate the Category to user?
  60. WordPress database error: [Query was empty] – using $wpdb->prepare()
  61. Why doesn’t my Table get created?
  62. How to display specific data from a custom table to logged in users with a custom role
  63. $wpbd->insert_id is returning null
  64. How to store sensitive user data (passwords)
  65. How to get inserted row IDs for bulk/batch insert with wpdb query?
  66. WordPress Query doesn’t return the correct value
  67. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  68. Custom Plugin activation error in Multisite
  69. User avatar-ACF fields
  70. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  71. Update database record in plugin
  72. How to store in the database directly the translation?
  73. Dedicated server and WPDB Class : huge slow-down of the website
  74. How to implement pagination into a wpdb->result query?
  75. Unable to show a message after plugin activation
  76. How to CRUD from wordpress database in wordpress theme?
  77. I can’t write in my DB using $wpdb->insert
  78. $wpdb how can i save my postmeta table before querying it
  79. Refresh or redirect page after activate my plugin
  80. I can install my plugin in localhost but not in my server
  81. Nothing happens on WordPress Update command
  82. Deactivate plugin on registration
  83. Fixing plugin for wpdb::prepare
  84. how can a plugin return an error message on activation?
  85. Is there a canonical way for a plugin to install a mu-plugin or drop-in?
  86. My activator class isn’t running the code inside
  87. multiple record insert creating many duplicate records
  88. Should I create a theme or a plugin?
  89. How to change wordpress post title?
  90. How do I approach removing menu items on the fly based on settings in my plugin?
  91. Can I use core’s “or Link to Existing Content” feature in my plugin?
  92. Preview Changes button missing on custom post type page since updating to 3.4
  93. Link Pop-up in custom plugin
  94. Custom plugin & calling REST api of wordpress instance the plugins is running on
  95. Add variables from rewrite rules to query var
  96. How do I specify where to save the debug.log?
  97. How to fetch the post content from the wordpress editor before it can be saved(published)?
  98. How does one set cookies in WordPress without getting the ‘headers not sent’ error? within WP
  99. Glyphicons Dont Show in WordPress Plugin Only
  100. Advanced Custom Fields conflicting with custom plugin when saving custom field

Leave a Comment