Integrating Custom Database with WordPress

You can use wpdb class to query your custom data from MySQL. Depending on your implementation you would either use:

  • global $wpdb object, if your custom data is in same database as WP itself
  • new custom instance of wpdb class if you need to connect to different database for custom data

Related Posts:

  1. How does WordPress handle MySQL row lock errors?
  2. Help With MySQL to WPDB Query Conversion
  3. WordPress Backend HA (Automatic failover)
  4. DB Query not working in Plugin
  5. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  6. WordPress plugin: efficient way to store large data
  7. How to display results from a data table with an encrypted user id?
  8. How can I delete the options from DB when the plugin is deleted?
  9. How to structure a plugin
  10. is_plugin_active function doesn’t exist
  11. Custom pages with plugin
  12. WordPress Plugin Development In MVC Architecture, How?
  13. How to properly insert data into custom table via plugin
  14. Checking if an attribute exists in a shortcode
  15. Show Similar Post Titles ( Similar to Stack Exchange )
  16. How do I unlock a post programmatically?
  17. Create page when plugin is activated
  18. How can I limit functionality in one version of a plugin?
  19. Can I explicitly specify ENGINE=InnoDB in WordPress?
  20. How to show custom message once on plugin activation?
  21. How to list the Hooks and order of execution in current loading page? [duplicate]
  22. How to load a new template page according to a particular URL?
  23. WordPress network: set themes and plugins for new blog
  24. Updating post meta for custom post types
  25. Can a plugin add to header/footer/body content?
  26. Changing BIGINT to INT
  27. WordPress register_activation_hook table creation not working
  28. REST-API: extend media-endpoint
  29. clean wp_options table unused rows
  30. greatest() function returns undefined property
  31. Is there a way to alter the order in which the plugins appear in the page?
  32. How to write one comment and publish on every post using database or plugin?
  33. How to use get_theme_mod in gutenberg editor wordpress?
  34. Get IDs of Images from Gallery Block in InnerBlocks of a Custom Gutenberg Block
  35. WordPress plugin – Error “Plugin generate 2890 characters of unexpected output when activated”
  36. My plugin wants to update another plugin
  37. Plugin Options Not Saving to Database in WP 4.5
  38. How to create custom tables in WordPress using my own plugin?
  39. Edit Yoast SEO breadcrumbs output [closed]
  40. How would I go about creating a user ranked post popularity page?
  41. Disable woocommerce cookies and delete cart data automatically
  42. How can I perform high-level database merging for WordPress within continues delivery?
  43. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  44. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  45. Customization API for plugin development
  46. Fromcraft Plugin On click submit button [closed]
  47. Migrating to WordPress Recipe Plugin and Some SQL Issues
  48. Multiple instance of data in plugin custom database table on plugin activation
  49. How to redirect users to their profile after they successfully edit their profile
  50. Better ads plugin has 500.000 entries in wp_postmeta
  51. Redirect to another page using contact form 7? [closed]
  52. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  53. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  54. Custom post types – remove default post supports through empty array?
  55. How to insert and call new data in wordpress website database through a plugin
  56. WPDB: Update table
  57. Separate database for a wordpress plugin
  58. Add some fileds to the wp_posts table
  59. Best/Correct way to add an option to a category
  60. Always get creating a new table with foreign key
  61. How to do database for download stats?
  62. What is the WordPress approach to custom data?
  63. Loop in elementor custom widget not working
  64. Way to send multiple values for column to MySQL?
  65. Delete data from custom table when deleting a post
  66. Can’t create tables with my plugin
  67. unregister a sidebar widget
  68. add_action for publish_post doesn’t work
  69. How to keep plugin (media-sync) running even the tab is closed?
  70. What database state changes happen after a post is manually “updated” with no changes?
  71. Cant create table on plugin activation
  72. How to access a wordpress plugin page or add posts without doing it from the WordPress dashboard?
  73. Custom Plugin: How to Include Install Buttons of other 3rd Party Plugins?
  74. Rename a folder via HTML POST request
  75. Move plugin pages from dashboard to front-end
  76. working code, not working – Plugin Dev
  77. WordPress UPDATE queries on MySQL database stuck
  78. Cannot view Custom Post Type no matter what I try
  79. Moving a few select DB tables to a new WP instance
  80. Custom wp_list_tables redirect on specfic page
  81. Paid Membership Pro displaying a user name in PHP
  82. Installation failed, trying to install ANY plugin
  83. How to use custom footer template in a site-plugin?
  84. Creating Nested custom fields
  85. Where do the section input fields values are stored in database
  86. My plugin can’t see my files
  87. Confusing problem with displaying message recipient metadata
  88. Resetting AUTO_INCREMENT primary key
  89. Why the output of an image gallery plugin is not displayed into a page of my custom theme?
  90. Update Plugin Without Overwriting Custom Settings
  91. Get page type to display content
  92. Creating fields in the database
  93. How to submit the custom form data in database in WordPress without plugin?
  94. how to search through plugin in wordpress cimy-user-extra-fields?
  95. Get all the related data from WordPress DB
  96. How to add image for custom taxonomy
  97. Why haven’t I see plugins using get_file_data to handle retrieving plugin version?
  98. How can I properly sanitize the update_option in WordPress?
  99. Create Custom Coupon Type
  100. Take Elementor For Email FIeld Check if user is registered. IF not registered then register on woocommerece