Creating two database tables via plugin

Basic programming techniques you should have learned before building a plugin:

  1. You can concatenate checks with && (and) and || (or).
  2. You can (and should) guard each CREATE query with its own check

SQL syntax you should have looked into before writing queries on your own:

On a related note, please make sure that you delete these tables when the plugin is uninstalled/deleted.

PS: No offense intended, but it does look like you copy pasted without knowing what the code does. Please be aware that by doing this in a plugin you risk other people’s installations!

Related Posts:

  1. How to Add an Index to Plugin Database table
  2. Query Posts by Custom Field ‘Price’
  3. How does WordPress handle MySQL row lock errors?
  4. insert data in database table from plugin with WP3.1
  5. How to count number of records found in a database table?
  6. WordPress register_activation_hook table creation not working
  7. How use %like% in sql statement wordpress
  8. Accessing GET variable named ‘error’
  9. Default Plugin Settings Not Writing to Database
  10. WP_Query ordering numbers as letters
  11. Building an email signup form. Where should the information be saved in the DB?
  12. Plugin Options Not Saving to Database in WP 4.5
  13. How to create custom tables in WordPress using my own plugin?
  14. Is it possible to create Custom Post plug-in?
  15. switched from query_posts to WP_query, not working now?
  16. Help With MySQL to WPDB Query Conversion
  17. AJAX search posts and pages
  18. DROP TABLE with uninstall hook not working
  19. Prevent duplicate records in plugin table
  20. WordPress Backend HA (Automatic failover)
  21. how to use in custom single.php template using php?
  22. How can I change the meta_key for a particular piece of information?
  23. How to create a custom shortcode based on the layout?
  24. Redirect to another page using contact form 7? [closed]
  25. Can I create a table on my DB without creating a plugin?
  26. WordPress : Explain Plugins & Theme string value in database
  27. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  28. How to insert and call new data in wordpress website database through a plugin
  29. WPDB: Update table
  30. Issue running db create table query from static method
  31. Separate database for a wordpress plugin
  32. Best/Correct way to add an option to a category
  33. What is the WordPress approach to custom data?
  34. How to create plugin/ page that reads from database
  35. DB Query not working in Plugin
  36. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  37. WordPress plugin: efficient way to store large data
  38. Delete data from custom table when deleting a post
  39. Integrating Custom Database with WordPress
  40. How to display results from a data table with an encrypted user id?
  41. How to make a Product page without ordering and database
  42. How to Join wp_posts & wp_postmeta table using custom query
  43. What database state changes happen after a post is manually “updated” with no changes?
  44. adding dynamic/multiple slug values in ‘option_none_value’
  45. I want to schedule email (date, time is in database->table) wp_schedule_event() not working
  46. How to securely controlling data without keeping it in postmeta?
  47. $wpdb->insert not working inside save_post tag
  48. Performance considerations – postmeta table versus new table for custom posts with foreign keys?
  49. Checkbox field that add a subscription product and change prices of other products in checkout and cart page
  50. How to use information from the database in the front-end?
  51. Where do the section input fields values are stored in database
  52. My plugin can’t see my files
  53. how can i get records from wp_postmeta table using particular meta_key in database?
  54. How to insert variable which contain array value in wp_options table?
  55. Shortcode in a blog post, footer and related products stop working
  56. wpdb get_var is not returning any result (verified mysql query returns only one value)
  57. WP-Snap too slow (caused by WP_Query?)
  58. WordPress Meta Query: Relation is not working correctly
  59. Insert data in custom table during new post creation
  60. Making a Custom Post Type Publish Loop
  61. Checking url from plugin [duplicate]
  62. Create New Admin Menu Section – Like how custom post type works, in a way
  63. Creating fields in the database
  64. How to submit the custom form data in database in WordPress without plugin?
  65. get_option returning a different value from what’s saved
  66. How can I delete the options from DB when the plugin is deleted?
  67. register_activation_hook not working
  68. On the same site, how do I send data from a plugin file to a theme file?
  69. plugin doesn’t retrieve data from database
  70. Accessing Correct Database to Create REST API Endpoint
  71. fatal error get_page_permastruct()
  72. Pass $this to function nested in another public function of the same class
  73. Way to hook into a sidebar call to replace it with a custom sidebar
  74. WP Plugin Developers – Accessing my wordpress site [closed]
  75. How to determine what is generating large amount of database queries?
  76. why doesn’t this update part of this plugin work? it take me to nothing here page
  77. Using a custom plugin to capture input data via Ajax and PHP
  78. Display post lists in 2nd paragraph
  79. Is there a way to test that readme looks in other language before submitting translation?
  80. Create tabs in admin options page from custom post type loop
  81. populating a form field with output from a custom plugin function
  82. Is there a way to add custom endpoint to specific page only
  83. IF condition based on wp_remote_get output
  84. Add User Role: Pre-saved in User-Meta [SOLVED]
  85. How WordPress core manage the plugin installation
  86. Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]
  87. count the number of views of a post excluding own views
  88. How to set Google Analytics tracking code on WordPress plugin directory page?
  89. Load my Inline js footer area
  90. Remove action added in plugin class from theme
  91. wc_get_product_terms() throws “Notice: Undefined offset: 0”
  92. How do I add a textarea (multirow) option to my WordPress plugin?
  93. Passing ajax variable to more than one wordpress plugin function
  94. Why isn’t my plugin seeing other classes?
  95. How to add jquery to my custom post type wp plugin
  96. Update post meta not working on wp_postmeta
  97. wp_insert_post_data filter to set category
  98. is there a way I can add or remove some plugin options?
  99. What can I do to customize a widget provided with this plugin? from where have I to start?
  100. How to add a simple design in classic editor plugin creating post page through another Wp plugin

Leave a Comment

error code: 523