Display data from phpMyAdmin with WordPress

if you are trying to query from the same database in which your WordPress is installed then there is a great way to do sql query with ease. WordPress has a database access abstraction class called wpdb that allows you to run raw mysql query without any issue.

You can start using it like one of two methods bellow:

// 1st Method - Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

or

// 2nd Method - Utilizing the $GLOBALS superglobal. Does not require global keyword ( but may not be best practice )
$results = $GLOBALS['wpdb']->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Explore the documentation here and get started!

Related Posts:

  1. How to display SQL query that ran in query?
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. WordPress creating excessive joins on meta_query with search
  6. cron job to auto delete posts of a specific post type older than x days
  7. Are database queries created using WordPress filters protected from SQL injection?
  8. Get posts by category with pure SQL query
  9. Custom query to get terms from post ids
  10. Get the timout value of a saved transient?
  11. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  12. Update slug (URL) of pending posts via phpMyAdmin
  13. What’s wrong with my $wpdb prepare?
  14. How do I see the mysql query generated by get_posts( $args )?
  15. sql select query in wordpress ‘page’ [closed]
  16. problem with sql query in wordpress plugin
  17. Attempt to improve WP search, can someone check my SQL query?
  18. wpdb query problem to access previous 3 days posts
  19. I can’t figure out what’s wrong with this statement. $wpdb->query update
  20. Custom Query – Based on user input
  21. how to insert missing tags into the posts through mySQL?
  22. $wpdb->prepare affecting the query?
  23. WordPress SQL search, how to handle SQL Injection?
  24. exclude pingbacks from wordpress SQL query
  25. prepare function sql safe method
  26. WordPress SQL query to tag all posts containing a specific word on title
  27. Select column name dynamically mySQL Query
  28. How do I query for posts by custom meta and those that have been stickied?
  29. Change pure SQL database query to WordPress post query?
  30. Cannot get sql request from Query object?
  31. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  32. SQL to Query the db and return all posts and it’s metas
  33. SQL query to delete users with multiple meta keys and comments
  34. Nested select statements not working
  35. Speed up search query that searches in post meta?
  36. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  37. Fastest and most efficient SQL query to check if UID exists
  38. How to make MySQL search queries with quotes
  39. How i make a custom sql query for Woocommerce
  40. $wpdb query for price in custom field value
  41. Run an update query in a function
  42. How to display a specific category using a custom Query in WordPress?
  43. Slow query when joining wp_posts with a lookup-table?
  44. Wpdb generates too many queries
  45. learn to run wpdb class
  46. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  47. Where can I find the SQL to get the most used information by wordpress database?
  48. Custom Query for wp_posts using wp_postmeta
  49. 3 queries to update WordPress
  50. Differences between wpdb->get_results() and wpdb->query()
  51. Using WordPress public query variables
  52. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  53. $query->query_var[‘post_type’] not set for pages
  54. Show recent products first but “sold out last” in query
  55. Get IDs of posts currently visible on archive
  56. WordPress query by category, sorted by custom field
  57. How many queries are normal to execute on a WP site?
  58. How to optimize my query filtering out unwanted data?
  59. Remove posts from query for events whose start date has passed
  60. Insert static element only once in query archive
  61. How to run a mysql query when admin updates user role?
  62. Error when using setup_postdata()
  63. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  64. Getting post data from private page
  65. Optional Meta Query
  66. SQL query to select posts from multiple categories
  67. Select Query demand excesive resources [closed]
  68. Create Indexes for Slow Queries
  69. Query to get number of posts last week
  70. I want to create a filter for the query string is this possible?
  71. Exclude categories from the_category();
  72. How can i show all categories using wp query?
  73. Query returning same results even though the ID changes
  74. Why my query ‘REPLACE INTO…’ does not work?
  75. Is it possible to query from external database? [duplicate]
  76. Restrict query to last day with posts
  77. Custom query object with Simple-Fields custom date field
  78. How to read the value of a WordPress $query associative array (hash) key
  79. PHP -> SQL Query with Summing
  80. Query posts based on previous query
  81. Waypoints + infinite scroll with custom query
  82. Customizing the_tags output?
  83. Querying with WP query using meta key price
  84. Re-sort get_posts query results
  85. How do I get all results from my query
  86. Pagination not working on custom post types with rewrite slug
  87. Filter orders by modify date
  88. How to add url parameter to every search query in SearchWp?
  89. Update WooCommerce stock status with SQL query if stock value is greater than 0
  90. SQL query to list all posts of specific post type with a specific set of associated postmeta values as a column
  91. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  92. Category_in return empty
  93. How to run select query of post with category and tags?
  94. WordPress character set issue
  95. modifying main query to query for ranges e.g. from 1999 to 2016
  96. Querying users by meta value and getting a strange answer
  97. $wpdb: how to use a query as a base for another query?
  98. Multilingual WordPress page – using URL to determine language?
  99. WP_Query with checkbox meta_query – WordPress [duplicate]
  100. What is the best way to cache pages and queries in WordPress?