How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?

Simple, hook on the query filter and structure that “unstructured” sql data. Parsing SQL is annoying but can’t be that difficult.

Of course some queries are ran before plugins are loaded as you do need to get the list of active plugins and active theme before including their file. And if you need to access a DB which is different from mysql or ignores the dbname/user/password settings from wp_config.php file, you need to do override $wpdb before the first query is sent.

Related Posts:

  1. Should I use wpdb prepare?
  2. Is it mandatory to use $wpdb->prefix in custom tables
  3. $wpdb->insert_id
  4. Check for success of $wpdb->update() correctly
  5. WordPress and multithreading
  6. $wpdb->insert is changing a value
  7. Actions or filters fired when data is saved in a custom table
  8. Retrieving custom fields with $wpdb->get_results
  9. Really simple query giving error in SQL syntax
  10. Custom Plugin Database relations
  11. why creating tables using $wpdb is not being executed while installing plugins?
  12. How to use mysql IN statement with wpdb update method?
  13. Using $wpdb object in a widget
  14. Activation hook not creating table
  15. $wpdb -> Batch insert from XML File?
  16. How to Download and install plugin database remotely
  17. How to insert data to a database table when the field is not yet created?
  18. Where to store the name of a custom table?
  19. include wp-blog-header not working on MAMP
  20. creating custom function to log actions in plugin
  21. SQL query for custom taxonomy slugs
  22. Issue regarding $wpdb->prepare()
  23. Error on inserting a form value to database
  24. How to create database table, add data, update and delete using wpdb via plugins?
  25. Using WPDB to output raw XML fails because of wp-blog-header.php
  26. how to search users by ajax live search
  27. Adding custom end points, No error line
  28. Intermittent database errors when accessing WordPress database
  29. Storing data in wordpress database from ajax call from different website
  30. wpdb->prepare and mysql UPDATE – how is it done?
  31. $wpdb->prepare with LIKE and sprintf
  32. How to optimize multiple insert into wordpress database
  33. $wpdb->update() always need a second try
  34. Data inserted by wpdb insert is different than data pressnt in database.
  35. Proper Prepare Statement for ALTER TABLE and using AFTER
  36. $wpdb->prepare is not working like mysql_real_escape_string
  37. $wpdb in php 5.5
  38. Plugin to create Posts and Forums then choose category and parent forum
  39. $wpdb->update Issue
  40. How to relate the Category to user?
  41. WordPress database error: [Query was empty] – using $wpdb->prepare()
  42. Why doesn’t my Table get created?
  43. How to display specific data from a custom table to logged in users with a custom role
  44. $wpbd->insert_id is returning null
  45. How to store sensitive user data (passwords)
  46. How to get inserted row IDs for bulk/batch insert with wpdb query?
  47. WordPress Query doesn’t return the correct value
  48. User avatar-ACF fields
  49. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  50. Update database record in plugin
  51. Dedicated server and WPDB Class : huge slow-down of the website
  52. How to implement pagination into a wpdb->result query?
  53. How to CRUD from wordpress database in wordpress theme?
  54. I can’t write in my DB using $wpdb->insert
  55. $wpdb how can i save my postmeta table before querying it
  56. WordPress plugin tables become corrupt
  57. Nothing happens on WordPress Update command
  58. Fixing plugin for wpdb::prepare
  59. multiple record insert creating many duplicate records
  60. add_action hook for completely new post?
  61. Is there a hook for when you switch themes?
  62. Problems after wp_set_password() containing an apostrophe
  63. Front-End Form Submission in Shortcode
  64. Plugin Localization
  65. Why cant the WP Filesystem API read googlefonts.json?
  66. calling jquery function on plugin page
  67. Check if someone is editing a post (this content is currently locked)
  68. How can I create a plugin that changes the title color of a website?
  69. Two functions utilizing registration_errors filter
  70. Issue plugin commands in admin settings page
  71. Creating a shortcode, but getting tied up with OOP and Classes?
  72. add_shortcode() not working inside of function
  73. How to add and remove a page
  74. correct way to call javascript into hook function
  75. “dashboard”-named PHP file doesn’t get included
  76. How to Upload Images From a Folder (Not WP_Uploads)
  77. Plugin uninstall function is not working
  78. Loading custom js file on the admin page through plugin
  79. I am unable to save my data from a form
  80. Check if post belongs to any category
  81. What’s wrong with my usage of add_filter
  82. Moving/dragging a metabox removes TinyMCE’s content
  83. Preventing double loading JS scripts (like React) when developing for Gutenberg
  84. Can calling wp_enqueue_style in wp_iframe apply the stylesheet to everything not just the iframe?
  85. Copied files from plugin to theme not working
  86. How can I allow the user to press enter without creating a new element in the editor?
  87. Is there anything special required to make a plugin work in a multisite environment?
  88. How to exclude “uncategorized” from custom categories widget?
  89. Using WordPress Boilerplate (WPBP) for WP Multisite Plugin
  90. WordPress5.2.3: Better File Download Plugin validation issue
  91. How do I make secure API calls from my WordPress plugin?
  92. esc_attr() on hard coded string
  93. WordPress Plugin Boilerplate – add actions and/or filters based on user’s role
  94. How to use functions from Woocommerce documentation?
  95. WP API users per page
  96. Problem with Poedit [closed]
  97. Insert plugin html content to a specific spot in the frontpage
  98. Is Explicit Versioning a better alternative to Semantic Versioning for wordpress?
  99. Need someone to help you want to manage points for members to code interface functions? thank you
  100. Call API on post save/update and show the result in admin area
tech