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. WP_Query does not return the result even if the data is present in the database
  72. Getting Path To Uploaded Attachment Image After Upload
  73. Understanding apply_filters
  74. Editor not displaying dynamically after clicking on the button
  75. How to submit documentation with plugin
  76. Placement of Code in Plugin for hooking `save_post`
  77. How can plugins have their own pages?
  78. Where does WordPress store plugin (enabled/disabled) status for multisite?
  79. Reusable functions and tools (Framework)
  80. Creating a plugin to sanitize comment and the url field before display only
  81. Creating mySQL procedure with $wpdb
  82. Editable form for WordPress plugin options page
  83. wp-pagenavi getting 404 page not found
  84. remove add new post, if there is already one post
  85. WordPress checkbox and Illegal string offset
  86. dbDelta not adding additional columns in plugin database update
  87. Is it fair to use MIT licensed code in WordPress plugins? [closed]
  88. How to Show Author image and url in WordPress plugin directory? [closed]
  89. jQuery code didn’t run on my plugin
  90. Custom Module, Extending WP with a Plugin?
  91. How do I profit from a Plugin?
  92. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  93. list of custom post by custom field in frontend
  94. ajax voting for custom post type
  95. Help me with my first very basic plugin
  96. Very slow page loads
  97. How to set meta-data for my plugin
  98. WordPress isn’t sending welcome email with the password reset
  99. CPT template is not being automatically used single post pages
  100. Custom Elementor controls not appearing in the widget Advanced tab using injection hooks

Leave a Comment