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 check if image is already stored in a site’s post database? (network)
  2. How To Make Connection To WordPress Data Base In A Plugin?
  3. Changing user_nicename
  4. WordPress will not operate correctly
  5. How to Join two tables from separate databases within WordPress
  6. Refresh page after update_post_meta
  7. Search and Replace in database: How to replace data in SQL dump file on Windows?
  8. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  9. Import 10,000 Users into WordPress WITH a specific ID for each user
  10. WP database error for comments_popup_link()
  11. if statement on database query
  12. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  13. How to create Sub Sub domain Multi User blogs?
  14. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  15. How to generate page content from database the right way?
  16. Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
  17. Store and Work with huge array in WP [closed]
  18. phpMyAdmin displays error when importing database
  19. Adding Custom Forms
  20. How to get the POST TITLE using the POST ID?
  21. Why is the post meta[] empty when I make a call to the wordpress rest api?
  22. Is it necessary to sanitize wp_set_password user input?
  23. WordPress Scheduled Event Request Blocking
  24. Trying to establish connection to External Database
  25. Getting id of poll from WP database
  26. How to insert a single row to WP database table?
  27. $wpdb->update with multiple parameters gives error
  28. wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
  29. Is it possible to create a wordpress database with php code?
  30. Store a default value for a transient on plugin activation
  31. Split reads to a different connection string
  32. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  33. inserting a post from an extern php file but post content doesn’t show on wp site
  34. Using custom tables for old posts
  35. db converts decimal number wrong
  36. Not connecting to database in file with multiple MySQL connections
  37. How can I import an excel column into wordpress database?
  38. WordPress Block developer from exporting Database via PHP
  39. Execute a function every hour in the background
  40. Create page with custom php script and fetched data
  41. How do I display offsite database info on my wordpress site?
  42. Creating Database Table vs. Adding MetaData to Post & User
  43. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  44. Building a REST API for your web app exposes primary keys of DB records?
  45. Most commented posts by time period (last 12h, last 24h and etc)
  46. wpdb Cannot Update column in Database
  47. Cant connect to database with php 7.3
  48. Set default Database Storage Engine when creating tables with plugins?
  49. WPDB – Read and write value from / to database
  50. How do I make this Metabox show current DB value?
  51. How to Generate a list of Most Commented post?
  52. Why when I create a new post I found 2 record related to this post into the posts database table?
  53. SQL error with custom query
  54. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  55. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  56. Change wordpress’ database data using ajax – how to get current user id?
  57. $_POST returning empty values
  58. How to send custom form submissions to WordPress Database?
  59. add role on WordPress in PHP on a second database
  60. Create a new account on site B with data from the purchase of site A
  61. How to search order using database frontend short code WordPress
  62. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  63. wp_update_post gives 500 internal error
  64. Unable to insert two value in two different columns (WordPress database)
  65. Retrieving and Displaying Data From a Table
  66. why not selecting multiple rows of same standard_id using SQL query from database?
  67. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  68. Updating the database after parsing CSV document
  69. getting the values of hidden inputs to use them in a php mysql query
  70. custom search query database in child theme
  71. wp-login.php?redirect_to=https problem
  72. How to query a staging database?
  73. Get meta_query value by user meta array
  74. Front end/Database connection in WP
  75. Issue in url update when using wordpress update query
  76. can’t delete a row from post_meta table
  77. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  78. Can form entries from a WordPress form go to a database
  79. AJAX Not Working With WordPress Database properly
  80. Weird Behaviour: Not all WordPress Posts appearing
  81. Can not manually create a database ( db, user, pass ) for a plugin
  82. Insert double entry in DB
  83. Manipulate database of WordPress site with my own scripts
  84. Problems with plugin that fetches data from database with ajax
  85. Let users register weight each day and save it in DB
  86. Query specific posts per user selections from dropdown menus
  87. Fetching wpdb data from a php file seems to break?
  88. How to pass username into form that sends data to database
  89. How to edit the default database of WordPress [closed]
  90. Insert into db with foreach problem
  91. notify users when changed database
  92. Execute multiple PHP Snippets causes error?
  93. How to get the last date updated of postmeta?
  94. Putting form result in my database
  95. Bulk data save in custom table
  96. Issue with WordPress Plugin Activation Hook and Table Creation
  97. WordPress Insert line in DB when clicking a button
  98. Updates applied to staging WordPress site affecting production even with different databases
  99. Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  100. How to improve the performance when using a flat-file dataset and PHP for implementing advanced search function?