Using wpdb to connect to a different database is not working

I found the problem.

I had defined variables using the names DB_USER, DB_PASSWORD etc in my own database connection config file. I then found that wordpress already defines variables using these exact same names, which are stored in one of the files in the wp-includes directory. So my own defined variables with the same name were being overwritten or ignored when I attempted to use a wpdb connection.

The reason my own defined variables worked for my_sqli and not wpdb is, I assume, that calling a wpdb connection would fire up the script with these defined connection variables inside. I discovered this when using var_dump on the wpdb connection, where I discovered a completely random username was used instead of my own.

So if you want to use a wpdb connection and connect to a database with differing connection details, do not define variables named DB_USER, DB_PASSWORD, DB_SERVER and DB_DATABASE. Choose different names.

Related Posts:

  1. How to return number of found rows from SELECT query
  2. $wpdb->delete column values IN ARRAY()?
  3. Update results, Before deleting the related category [closed]
  4. I can’t update my data through $wpdb
  5. Add row to custom database Table and delete all rows older than 1 day
  6. select a single val though a table in wordpress
  7. MySQL database migration to WordPress
  8. Putting form result in my database
  9. Can i use php sql functions instead of $wpdb?
  10. Custom query to get post names beginning with a digit
  11. How To Make Connection To WordPress Data Base In A Plugin?
  12. Changing user_nicename
  13. WordPress will not operate correctly
  14. How to Join two tables from separate databases within WordPress
  15. error importing localhost export file to server
  16. How to sort results from a custom database table
  17. How can I call a row of user specific data from a custom table added to the WP Database
  18. How to merge local and live databases?
  19. How to track a users progress through pages by inserting data into WordPress Database?
  20. Import 10,000 Users into WordPress WITH a specific ID for each user
  21. WPDB: how to get the value of a field in a custom database table
  22. if statement on database query
  23. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  24. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  25. WordPress get pagination on wpdb get_results
  26. How to create and work with custom data / tables (i.e., for arbitrary data)?
  27. Ajax $wpdb not returning table data
  28. Converting MYSQL to WordPress $WPDB
  29. Show MySQL errors that occur when I excute $wpdb->insert()
  30. Any possible way to make $wpdb->get_results() return anything else than array?
  31. database interactions using OOP
  32. Can’t get wp_insert_post to work
  33. Trying to establish connection to External Database
  34. Getting id of poll from WP database
  35. How to insert a single row to WP database table?
  36. I want to select the from values from database in WordPress? [closed]
  37. WordPress not reflecting changed of the database
  38. $wpdb->update with multiple parameters gives error
  39. How can I save unique user data on my site? [closed]
  40. wp query foreach deleting record returning only first or last item
  41. inserting a post from an extern php file but post content doesn’t show on wp site
  42. Database query works fine outside WordPress
  43. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  44. Using custom tables for old posts
  45. Help with a $wpdb MySQL Query
  46. Not connecting to database in file with multiple MySQL connections
  47. Custom array from a query only write the last row of the query
  48. WordPress Block developer from exporting Database via PHP
  49. $wpdb returns duplicate posts
  50. Should I use WordPress to skin a database website?
  51. How do I display offsite database info on my wordpress site?
  52. Creating Database Table vs. Adding MetaData to Post & User
  53. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  54. Most commented posts by time period (last 12h, last 24h and etc)
  55. Use $wpdb or other PHP script method to find/replace in WP database
  56. How can I add a new row in a separate database when someone registers via WordPress?
  57. Basic wpdb update question
  58. wpdb Cannot Update column in Database
  59. How to use mysql LIKE with wpdb?
  60. How do I prepare strings for insertions as values into a MySQL table?
  61. How to use AJAX in WordPress in MYSQL query?
  62. WPDB – Read and write value from / to database
  63. How to Generate a list of Most Commented post?
  64. Why won’t this wpdb get_results query return results?
  65. WPDB secure custom form
  66. Why when I create a new post I found 2 record related to this post into the posts database table?
  67. Adding data to custom wordpress database table
  68. populate select options from extra mysql table data
  69. Query the links Database
  70. SQL error with custom query
  71. Add posts to custom table in database instead of wp_posts
  72. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  73. Passing in MySQL prepare statement parameter separately throwing error
  74. Database SQL query error
  75. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  76. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  77. What is the correct way to search 3 custom fields only in WordPress?
  78. Insert data from form to database
  79. Rewrite SQL query as a prepared statement and use in foreach loop
  80. Advanced WordPress SQL Query
  81. can’t delete a row from post_meta table
  82. MySQL query in WordPress with AJAX
  83. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  84. MySQL queries in WordPress
  85. two wordpress sites, two themes, one database, same content
  86. Insert double entry in DB
  87. How to connect database table to each registered wordpress user.
  88. Let users register weight each day and save it in DB
  89. Custom query_posts() parameter
  90. Fetching wpdb data from a php file seems to break?
  91. How to pass username into form that sends data to database
  92. How to edit the default database of WordPress [closed]
  93. Insert into db with foreach problem
  94. Display total count of products in orders of a specific order status
  95. Execute multiple PHP Snippets causes error?
  96. Custom form that stores data in mysql database
  97. How to get data (not value or name) from radio options to POST to database
  98. Error resetting database index using ALTER TABLE in $wpdb->query
  99. How can I update a value of a field depending on outside source?
  100. Can’t insert into a database wordpress