Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing

Either you have a typo or your syntax is incorrect for this line:

$dbconnection = new $wpdb($username, $password, $dbname, $hostname );

It should be:

$dbconnection = new wpdb($username, $password, $dbname, $hostname ); (no $ in referencing the wpdb class)

Related Posts:

  1. How to return number of found rows from SELECT query
  2. what is the use of /wp-includes/SimplePie?
  3. How to check if image is already stored in a site’s post database? (network)
  4. How to export/import theme customizer settings?
  5. Inserting choice in database table
  6. WP API V2 returning Invalid User ID
  7. How To Make Connection To WordPress Data Base In A Plugin?
  8. Has anyone tried putting PHP ActiveRecord on WordPress?
  9. Changing user_nicename
  10. How to auto login user again after change user_login
  11. WordPress will not operate correctly
  12. Duplicate domain database to local – How?
  13. error importing localhost export file to server
  14. How can I call a row of user specific data from a custom table added to the WP Database
  15. How to merge local and live databases?
  16. How to track a users progress through pages by inserting data into WordPress Database?
  17. WPDB: how to get the value of a field in a custom database table
  18. if statement on database query
  19. Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  20. Access/update database with jQuery
  21. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  22. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  23. How to create and work with custom data / tables (i.e., for arbitrary data)?
  24. Add custom php database code above
  25. wp_insert_post not working
  26. Prevent Data Resubmission On Page refresh
  27. SQL QUERY – Select a value directly from the database
  28. Any possible way to make $wpdb->get_results() return anything else than array?
  29. database interactions using OOP
  30. Transferring working local PHP site to wordpress – with database (MySQL)
  31. Getting id of poll from WP database
  32. Storing Array from returned database query and using the array in a new query
  33. How to insert a single row to WP database table?
  34. WordPress not reflecting changed of the database
  35. wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
  36. How does WordPress know wich language is chosen when there is a database connection error
  37. How can I save unique user data on my site? [closed]
  38. Dynamic content in template
  39. Using custom tables for old posts
  40. db converts decimal number wrong
  41. Not connecting to database in file with multiple MySQL connections
  42. How can I import an excel column into wordpress database?
  43. WordPress Block developer from exporting Database via PHP
  44. Execute a function every hour in the background
  45. Create page with custom php script and fetched data
  46. Should I use WordPress to skin a database website?
  47. How do I display offsite database info on my wordpress site?
  48. Creating Database Table vs. Adding MetaData to Post & User
  49. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  50. Building a REST API for your web app exposes primary keys of DB records?
  51. Most commented posts by time period (last 12h, last 24h and etc)
  52. wpdb Cannot Update column in Database
  53. Cant connect to database with php 7.3
  54. Set default Database Storage Engine when creating tables with plugins?
  55. WPDB – Read and write value from / to database
  56. How do I make this Metabox show current DB value?
  57. How to Generate a list of Most Commented post?
  58. Why when I create a new post I found 2 record related to this post into the posts database table?
  59. SQL error with custom query
  60. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  61. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  62. Change wordpress’ database data using ajax – how to get current user id?
  63. $_POST returning empty values
  64. How to send custom form submissions to WordPress Database?
  65. add role on WordPress in PHP on a second database
  66. Create a new account on site B with data from the purchase of site A
  67. How to search order using database frontend short code WordPress
  68. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  69. wp_update_post gives 500 internal error
  70. Unable to insert two value in two different columns (WordPress database)
  71. Retrieving and Displaying Data From a Table
  72. why not selecting multiple rows of same standard_id using SQL query from database?
  73. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  74. Updating the database after parsing CSV document
  75. getting the values of hidden inputs to use them in a php mysql query
  76. custom search query database in child theme
  77. wp-login.php?redirect_to=https problem
  78. How to query a staging database?
  79. Get meta_query value by user meta array
  80. Front end/Database connection in WP
  81. Issue in url update when using wordpress update query
  82. can’t delete a row from post_meta table
  83. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  84. Can form entries from a WordPress form go to a database
  85. AJAX Not Working With WordPress Database properly
  86. Weird Behaviour: Not all WordPress Posts appearing
  87. Can not manually create a database ( db, user, pass ) for a plugin
  88. Insert double entry in DB
  89. Manipulate database of WordPress site with my own scripts
  90. Problems with plugin that fetches data from database with ajax
  91. Let users register weight each day and save it in DB
  92. Query specific posts per user selections from dropdown menus
  93. Fetching wpdb data from a php file seems to break?
  94. How to pass username into form that sends data to database
  95. How to edit the default database of WordPress [closed]
  96. Insert into db with foreach problem
  97. notify users when changed database
  98. save array of objects with update_option
  99. Execute multiple PHP Snippets causes error?
  100. Can’t insert into a database wordpress