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. can not serialize and insert data from custom form
  73. How do I turn a custom post type into a plugin?
  74. Plugin exceeds memory limit
  75. How to write one comment and publish on every post using database or plugin?
  76. How can I implement a notification system in wordpress?
  77. Redirect to a welcome page after updating plugin
  78. medoo framework in WP plugin
  79. Find the URL of the current plugin directory
  80. WordPress logo upload option in theme panel
  81. How to automate wordpress plugin activate and deactivate by php logic?
  82. Custom plugins/Manipulated plugins: Always a terrible idea to inherit these types of WP sites that discourage updates? [closed]
  83. Where does WordPress register default scripts like jQuery?
  84. Minimum PHP Required for WordPress
  85. Adding content before the loop in category pages
  86. How to get variables from fucntion.php to my plugin files
  87. admin_notices hook show message all admin pages after plugin activate
  88. Adding Attachment Display Settings in custom media frame
  89. Set user ID at time of wp_create_user
  90. How to include code into functions.php file via a plugin
  91. building plugin and it is displaying above plugins page
  92. like to keep reading plugin
  93. Check if email address exists front end with AJAX in a plugin
  94. Is the wordpress user-model changed in wpmu?
  95. Avoiding Duplicate function names in Post Loop (WP_Footer script)
  96. Creating Tables on Network Activation
  97. add action for displaying posts using a shortcode
  98. How do I write into a file (css)
  99. Make id column as AUTO INCREMENT on plugin activation
  100. WP Plugin Developers – Accessing my wordpress site [closed]

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)